[incubator-dolphinscheduler] branch dev updated: [Bug-3845]postgresql need to add IF NOT EXISTS for table t_ds_process… (#3852)

[jo...@apache.org]

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

journey pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-dolphinscheduler.git


The following commit(s) were added to refs/heads/dev by this push:
     new 7c1ff53  [Bug-3845]postgresql need to add IF NOT EXISTS for table t_ds_process… (#3852)
7c1ff53 is described below

commit 7c1ff53a7428b9edb8d179c01a6d715920745f1e
Author: yangruochen <ya...@gmail.com>
AuthorDate: Thu Oct 8 17:23:40 2020 +0800

    [Bug-3845]postgresql need to add IF NOT EXISTS for table t_ds_process… (#3852)
    
    * [Bug-3845]postgresql need to add IF NOT EXISTS for table t_ds_process_definition_version too.
    
    * restart unit test
    
    * rerun unit test
---
 sql/upgrade/1.3.3_schema/postgresql/dolphinscheduler_ddl.sql | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

diff --git a/sql/upgrade/1.3.3_schema/postgresql/dolphinscheduler_ddl.sql b/sql/upgrade/1.3.3_schema/postgresql/dolphinscheduler_ddl.sql
index 3351cac..477cb3b 100644
--- a/sql/upgrade/1.3.3_schema/postgresql/dolphinscheduler_ddl.sql
+++ b/sql/upgrade/1.3.3_schema/postgresql/dolphinscheduler_ddl.sql
@@ -91,7 +91,7 @@ DROP FUNCTION IF EXISTS uc_dolphin_T_t_ds_task_instance_A_var_pool();
 delimiter d//
 CREATE OR REPLACE FUNCTION ct_dolphin_T_t_ds_process_definition_version() RETURNS void AS $$
 BEGIN
-CREATE TABLE t_ds_process_definition_version (
+CREATE TABLE IF NOT EXISTS t_ds_process_definition_version (
                                                  id int NOT NULL  ,
                                                  process_definition_id int NOT NULL  ,
                                                  version int DEFAULT NULL ,
@@ -140,5 +140,3 @@ DROP FUNCTION IF EXISTS uc_dolphin_T_t_ds_resources_un();
 
 
 
-
-