[dolphinscheduler] branch dev updated: Modify the table t_ds_worker_group to add a description field in the postgresql upgrade script (#12883)

[ke...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

kerwin 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 713046b043 Modify the table t_ds_worker_group to add a description field in the postgresql upgrade script (#12883)
713046b043 is described below

commit 713046b04328edd10c06711a39092f739298c6c6
Author: Kerwin <37...@users.noreply.github.com>
AuthorDate: Tue Nov 15 17:26:41 2022 +0800

    Modify the table t_ds_worker_group to add a description field in the postgresql upgrade script (#12883)
---
 .../sql/upgrade/3.1.1_schema/postgresql/dolphinscheduler_ddl.sql       | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

diff --git a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.1_schema/postgresql/dolphinscheduler_ddl.sql b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.1_schema/postgresql/dolphinscheduler_ddl.sql
index fd465802ec..b67b1247b9 100644
--- a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.1_schema/postgresql/dolphinscheduler_ddl.sql
+++ b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.1.1_schema/postgresql/dolphinscheduler_ddl.sql
@@ -30,5 +30,4 @@ END IF;
 END $$;
 
 --- add column
-ALTER TABLE t_ds_task_group alter COLUMN description type varchar(255);
-
+ALTER TABLE t_ds_worker_group ADD COLUMN IF NOT EXISTS description varchar(255) DEFAULT NULL;