This is an automated email from the ASF dual-hosted git repository.
lidongdai pushed a commit to branch 2.0.3-prepare
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
The following commit(s) were added to refs/heads/2.0.3-prepare by this push:
new 6d0b5a5 fix 7732 update is_directory in upgrade sql. (#8055)
6d0b5a5 is described below
commit 6d0b5a5837d035470a7259e9d25ee1d73fe752e2
Author: BaoLiang <[email protected]>
AuthorDate: Sat Jan 15 09:10:45 2022 +0800
fix 7732 update is_directory in upgrade sql. (#8055)
---
.../sql/upgrade/2.0.3_schema/postgresql/dolphinscheduler_ddl.sql | 3 +++
1 file changed, 3 insertions(+)
diff --git
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/2.0.3_schema/postgresql/dolphinscheduler_ddl.sql
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/2.0.3_schema/postgresql/dolphinscheduler_ddl.sql
index fd65814..a828a1a 100644
---
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/2.0.3_schema/postgresql/dolphinscheduler_ddl.sql
+++
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/2.0.3_schema/postgresql/dolphinscheduler_ddl.sql
@@ -36,6 +36,9 @@ EXECUTE 'CREATE INDEX IF NOT EXISTS idx_code_relation ON ' ||
quote_ident(v_sche
EXECUTE 'CREATE INDEX IF NOT EXISTS idx_process_code_version_relation_log ON '
|| quote_ident(v_schema) ||'.t_ds_process_task_relation_log USING
Btree("process_definition_code","process_definition_version")';
EXECUTE 'CREATE INDEX IF NOT EXISTS idx_code_version_task_log ON ' ||
quote_ident(v_schema) ||'.t_ds_task_definition_log USING
Btree("code","version")';
+EXECUTE 'ALTER TABLE t_ds_resources alter COLUMN is_directory TYPE bool using
(is_directory::bool)';
+EXECUTE 'ALTER TABLE t_ds_resources alter COLUMN is_directory SET DEFAULT
FALSE';
+
return 'Success!';
exception when others then
---Raise EXCEPTION '(%)',SQLERRM;
