zhuangchong commented on PR #14124:
URL:
https://github.com/apache/dolphinscheduler/pull/14124#issuecomment-1550583194
> ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS sign varchar(40) NOT NULL
DEFAULT '';
> ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS "warning_type" int
DEFAULT 2;
> ALTER TABLE t_ds_user ADD COLUMN IF NOT EXISTS "time_zone" varchar(32)
DEFAULT NULL;
> ALTER TABLE t_ds_task_instance ADD COLUMN IF NOT EXISTS "task_group_id"
int DEFAULT NULL;
> ALTER TABLE t_ds_task_definition ADD COLUMN IF NOT EXISTS "task_group_id"
int DEFAULT NULL;
> ALTER TABLE t_ds_task_definition ADD COLUMN IF NOT EXISTS
"task_group_priority" int DEFAULT '0';
> ALTER TABLE t_ds_task_definition_log ADD COLUMN IF NOT EXISTS
"task_group_id" int DEFAULT NULL;
> ALTER TABLE t_ds_task_definition_log ADD COLUMN IF NOT EXISTS
"task_group_priority" int DEFAULT '0';
> ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS "project_code" bigint
DEFAULT NULL;
> ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS "process_definition_code"
bigint DEFAULT NULL;
> ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS "process_instance_id" int
DEFAULT NULL;
> ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS "alert_type" int DEFAULT
NULL;
There is no problem with the above sql, use
```ALTER TABLE ${table_name} ADD COLUMN IF NOT EXISTS ${column_name} int
DEFAULT NULL```,
but these sql in the 3.2.0 file cannot be executed:
```
ALTER TABLE t_ds_command alter column test_flag type int DEFAULT NULL;
ALTER TABLE t_ds_process_instance ADD `project_code` bigint DEFAULT NULL
COMMENT 'project code';
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
