You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by ki...@apache.org on 2021/06/15 02:30:43 UTC

[dolphinscheduler] 04/12: [Fix-5583][sql] fix table name error in sql upgrade script (#5606)

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

kirs pushed a commit to branch json_split_two
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git

commit 006fb67439aa8db91b51ff0315baa0e4f5e3c88e
Author: leeli <17...@qq.com>
AuthorDate: Wed Jun 9 11:45:08 2021 +0800

    [Fix-5583][sql] fix table name error in sql upgrade script (#5606)
    
    * [DS-5583][fix] fix table ·name error in sql upgrade script
    
    * [DS-5583][fix] fix table ·name error in sql upgrade script
    
    Co-authored-by: lihongwei <li...@ebchinatech.com>
---
 sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql b/sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql
index 0fadd71..21a82b2 100644
--- a/sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql
+++ b/sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql
@@ -276,7 +276,7 @@ BEGIN
           WHERE relname='t_ds_alertgroup'
                             AND indexrelname ='t_ds_alertgroup_name_UN')
       THEN
-         ALTER TABLE t_ds_process_definition ADD CONSTRAINT t_ds_alertgroup_name_UN UNIQUE (group_name);
+         ALTER TABLE t_ds_alertgroup ADD CONSTRAINT t_ds_alertgroup_name_UN UNIQUE (group_name);
        END IF;
 END;
 $$ LANGUAGE plpgsql;
@@ -294,7 +294,7 @@ BEGIN
           WHERE relname='t_ds_datasource'
                             AND indexrelname ='t_ds_datasource_name_UN')
       THEN
-         ALTER TABLE t_ds_process_definition ADD CONSTRAINT t_ds_datasource_name_UN UNIQUE (name, type);
+         ALTER TABLE t_ds_datasource ADD CONSTRAINT t_ds_datasource_name_UN UNIQUE (name, type);
        END IF;
 END;
 $$ LANGUAGE plpgsql;