xxjingcd opened a new pull request, #13516: URL: https://github.com/apache/dolphinscheduler/pull/13516
<!--Thanks very much for contributing to Apache DolphinScheduler. Please review https://dolphinscheduler.apache.org/en-us/community/development/pull-request.html before opening a pull request.--> ## Purpose of the pull request <!--(For example: This pull request adds checkstyle plugin).--> Fix the problems of the sql upgradation script in 3.2.0 schema. This closes #13515 ## Brief change log <!--*(for example:)* - *Add maven-checkstyle-plugin to root pom.xml* --> modify `dolphinscheduler_postgresql.sql` in `3.2.0_schema` directory, the brief change is as follow: - fix error syntax and use simpler syntax to add fields instead of defining functions - add column's comment; - remove the `DROP` script SQL. It is very dangerous to drop tables or drop columns in an upgradation script, because it may cause data loss in an existing database; - add `t_ds_fav_task.task_name`'s upgradation sql. #12277 ## Verify this pull request - create DS database using `3.1.x` schema. - upgrade DB：execute `dolphinscheduler_postgresql.sql` in `3.2.0_schema` directory; - Use the upgraded database to run version 3.2.0 DS. I have upgraded the DB from 3.1.4 schema to 3.2.0 schema, created the process, and ran the process to verify. -- 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]
