This is an automated email from the ASF dual-hosted git repository.
wenjun pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
The following commit(s) were added to refs/heads/dev by this push:
new af9091a98a Use convert to set the exist column collate to utf8_bin
(#13479)
af9091a98a is described below
commit af9091a98a79cd64beef34fcdd7e82fc330cf181
Author: Wenjun Ruan <[email protected]>
AuthorDate: Wed Feb 1 18:40:18 2023 +0800
Use convert to set the exist column collate to utf8_bin (#13479)
---
.../3.2.0_schema/mysql/dolphinscheduler_ddl.sql | 127 +++++++++++----------
1 file changed, 64 insertions(+), 63 deletions(-)
diff --git
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.2.0_schema/mysql/dolphinscheduler_ddl.sql
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.2.0_schema/mysql/dolphinscheduler_ddl.sql
index 8f31bbc73d..500b16db9e 100644
---
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.2.0_schema/mysql/dolphinscheduler_ddl.sql
+++
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.2.0_schema/mysql/dolphinscheduler_ddl.sql
@@ -298,69 +298,70 @@ delimiter ;
CALL add_t_ds_task_instance_add_project_code;
DROP PROCEDURE add_t_ds_task_instance_add_project_code;
-alter table QRTZ_BLOB_TRIGGERS collate = utf8mb4_bin;
-alter table QRTZ_CALENDARS collate = utf8mb4_bin;
-alter table QRTZ_CRON_TRIGGERS collate = utf8mb4_bin;
-alter table QRTZ_FIRED_TRIGGERS collate = utf8mb4_bin;
-alter table QRTZ_JOB_DETAILS collate = utf8mb4_bin;
-alter table QRTZ_LOCKS collate = utf8mb4_bin;
-alter table QRTZ_PAUSED_TRIGGER_GRPS collate = utf8mb4_bin;
-alter table QRTZ_SCHEDULER_STATE collate = utf8mb4_bin;
-alter table QRTZ_SIMPLE_TRIGGERS collate = utf8mb4_bin;
-alter table QRTZ_SIMPROP_TRIGGERS collate = utf8mb4_bin;
-alter table QRTZ_TRIGGERS collate = utf8mb4_bin;
-alter table t_ds_access_token collate = utf8mb4_bin;
-alter table t_ds_alert collate = utf8mb4_bin;
-alter table t_ds_alertgroup collate = utf8mb4_bin;
-alter table t_ds_command collate = utf8mb4_bin;
-alter table t_ds_datasource collate = utf8mb4_bin;
-alter table t_ds_error_command collate = utf8mb4_bin;
-alter table t_ds_process_definition collate = utf8mb4_bin;
-alter table t_ds_process_definition_log collate = utf8mb4_bin;
-alter table t_ds_task_definition collate = utf8mb4_bin;
-alter table t_ds_task_definition_log collate = utf8mb4_bin;
-alter table t_ds_process_task_relation collate = utf8mb4_bin;
-alter table t_ds_process_task_relation_log collate = utf8mb4_bin;
-alter table t_ds_process_instance collate = utf8mb4_bin;
-alter table t_ds_project collate = utf8mb4_bin;
-alter table t_ds_queue collate = utf8mb4_bin;
-alter table t_ds_relation_datasource_user collate = utf8mb4_bin;
-alter table t_ds_relation_process_instance collate = utf8mb4_bin;
-alter table t_ds_relation_project_user collate = utf8mb4_bin;
-alter table t_ds_relation_resources_user collate = utf8mb4_bin;
-alter table t_ds_relation_udfs_user collate = utf8mb4_bin;
-alter table t_ds_resources collate = utf8mb4_bin;
-alter table t_ds_relation_resources_task collate = utf8mb4_bin;
-alter table t_ds_schedules collate = utf8mb4_bin;
-alter table t_ds_session collate = utf8mb4_bin;
-alter table t_ds_task_instance collate = utf8mb4_bin;
-alter table t_ds_tenant collate = utf8mb4_bin;
-alter table t_ds_udfs collate = utf8mb4_bin;
-alter table t_ds_user collate = utf8mb4_bin;
-alter table t_ds_worker_group collate = utf8mb4_bin;
-alter table t_ds_version collate = utf8mb4_bin;
-alter table t_ds_plugin_define collate = utf8mb4_bin;
-alter table t_ds_alert_plugin_instance collate = utf8mb4_bin;
-alter table t_ds_dq_comparison_type collate = utf8mb4_bin;
-alter table t_ds_dq_execute_result collate = utf8mb4_bin;
-alter table t_ds_dq_rule collate = utf8mb4_bin;
-alter table t_ds_dq_rule_execute_sql collate = utf8mb4_bin;
-alter table t_ds_dq_rule_input_entry collate = utf8mb4_bin;
-alter table t_ds_dq_task_statistics_value collate = utf8mb4_bin;
-alter table t_ds_relation_rule_execute_sql collate = utf8mb4_bin;
-alter table t_ds_relation_rule_input_entry collate = utf8mb4_bin;
-alter table t_ds_environment collate = utf8mb4_bin;
-alter table t_ds_environment_worker_group_relation collate = utf8mb4_bin;
-alter table t_ds_task_group_queue collate = utf8mb4_bin;
-alter table t_ds_task_group collate = utf8mb4_bin;
-alter table t_ds_audit_log collate = utf8mb4_bin;
-alter table t_ds_k8s collate = utf8mb4_bin;
-alter table t_ds_k8s_namespace collate = utf8mb4_bin;
-alter table t_ds_relation_namespace_user collate = utf8mb4_bin;
-alter table t_ds_alert_send_status collate = utf8mb4_bin;
-alter table t_ds_cluster collate = utf8mb4_bin;
-alter table t_ds_fav_task collate = utf8mb4_bin;
-alter table t_ds_trigger_relation collate = utf8mb4_bin;
+
+ALTER TABLE QRTZ_BLOB_TRIGGERS CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table QRTZ_CALENDARS CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table QRTZ_CRON_TRIGGERS CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table QRTZ_FIRED_TRIGGERS CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table QRTZ_JOB_DETAILS CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table QRTZ_LOCKS CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table QRTZ_PAUSED_TRIGGER_GRPS CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table QRTZ_SCHEDULER_STATE CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table QRTZ_SIMPLE_TRIGGERS CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table QRTZ_SIMPROP_TRIGGERS CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table QRTZ_TRIGGERS CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_access_token CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_alert CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_alertgroup CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_command CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_datasource CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_error_command CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_process_definition CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_process_definition_log CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_task_definition CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_task_definition_log CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_process_task_relation CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_process_task_relation_log CONVERT TO CHARACTER SET utf8
COLLATE utf8_bin;
+alter table t_ds_process_instance CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_project CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_queue CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_relation_datasource_user CONVERT TO CHARACTER SET utf8
COLLATE utf8_bin;
+alter table t_ds_relation_process_instance CONVERT TO CHARACTER SET utf8
COLLATE utf8_bin;
+alter table t_ds_relation_project_user CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_relation_resources_user CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_relation_udfs_user CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_resources CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_relation_resources_task CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_schedules CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_session CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_task_instance CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_tenant CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_udfs CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_user CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_worker_group CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_version CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_plugin_define CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_alert_plugin_instance CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_dq_comparison_type CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_dq_execute_result CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_dq_rule CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_dq_rule_execute_sql CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_dq_rule_input_entry CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_dq_task_statistics_value CONVERT TO CHARACTER SET utf8
COLLATE utf8_bin;
+alter table t_ds_relation_rule_execute_sql CONVERT TO CHARACTER SET utf8
COLLATE utf8_bin;
+alter table t_ds_relation_rule_input_entry CONVERT TO CHARACTER SET utf8
COLLATE utf8_bin;
+alter table t_ds_environment CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_environment_worker_group_relation CONVERT TO CHARACTER SET
utf8 COLLATE utf8_bin;
+alter table t_ds_task_group_queue CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_task_group CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_audit_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_k8s CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_k8s_namespace CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_relation_namespace_user CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_alert_send_status CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
+alter table t_ds_cluster CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_fav_task CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;
+alter table t_ds_trigger_relation CONVERT TO CHARACTER SET utf8 COLLATE
utf8_bin;
