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 <[email protected]>
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();
-
-
