File tree Expand file tree Collapse file tree 1 file changed +4
-4
lines changed
dolphinscheduler-dao/src/main/resources/sql/upgrade/3.3.0_schema/postgresql Expand file tree Collapse file tree 1 file changed +4
-4
lines changed Original file line number Diff line number Diff line change @@ -29,14 +29,14 @@ COMMENT ON COLUMN "t_ds_listener_event" ."sign" IS 'sign=sha1(content)';
2929delimiter d//
3030CREATE OR REPLACE FUNCTION modify_data_t_ds_dq_rule_input_entry () RETURNS void AS $$
3131BEGIN
32- IF EXISTS (SELECT 1
32+ IF EXISTS (SELECT 1
3333 FROM information_schema .columns
3434 WHERE table_name = ' t_ds_dq_rule_input_entry'
3535 AND column_name = ' value' )
3636 THEN
3737 ALTER TABLE t_ds_dq_rule_input_entry
3838 RENAME COLUMN " value" TO " data" ;
39- END IF;
39+ END IF;
4040END;
4141$$ LANGUAGE plpgsql;
4242d//
@@ -48,14 +48,14 @@ DROP FUNCTION IF EXISTS modify_data_t_ds_dq_rule_input_entry();
4848delimiter d//
4949CREATE OR REPLACE FUNCTION modify_data_type_t_ds_dq_rule_input_entry () RETURNS void AS $$
5050BEGIN
51- IF EXISTS (SELECT 1
51+ IF EXISTS (SELECT 1
5252 FROM information_schema .columns
5353 WHERE table_name = ' t_ds_dq_rule_input_entry'
5454 AND column_name = ' value_type' )
5555 THEN
5656 ALTER TABLE t_ds_dq_rule_input_entry
5757 RENAME COLUMN " value_type" TO " data_type" ;
58- END IF;
58+ END IF;
5959END;
6060$$ LANGUAGE plpgsql;
6161d//
You can’t perform that action at this time.
0 commit comments