SbloodyS commented on code in PR #13900: URL: https://github.com/apache/dolphinscheduler/pull/13900#discussion_r1170904617
########## dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/mysql/dolphinscheduler_ddl.sql: ########## @@ -495,6 +495,104 @@ delimiter ; CALL alter_t_ds_task_instance_col_log_path; DROP PROCEDURE alter_t_ds_task_instance_col_log_path; +-- Dealing with table name case issues +drop PROCEDURE if EXISTS qrtz_table_name_lowercase_to_uppercase; +delimiter d// +CREATE PROCEDURE qrtz_table_name_lowercase_to_uppercase() +BEGIN +IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.STATISTICS + WHERE TABLE_NAME='qrtz_blob_triggers' Review Comment: When initializing the table structure, it will follow the configuration of the mysql library to create it, and there will be no differences in table naming between different versions. The reason for this issue may be an exception caused by the user manually modifying the table naming method of the MySQL library after initializing the table structure, so I don't think this PR is necessary. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
