Jzjsnow opened a new issue, #3742: URL: https://github.com/apache/amoro/issues/3742
### What happened? 1. Executing postgres init sql failed due to table `table_optimizing_process` not exists when executing `CREATE INDEX task_runtime_index ON table_optimizing_process (table_id, process_id);`. 2. Compared to MySQL, pg's init SQL is missing the table `table_process_state`. 3. Executing mysql upgrade sql failed due to syntax error. 4. The upgrade.sql did not add DDL for table `table_process_state` after introducing. ### Affects Versions master ### What table formats are you seeing the problem on? _No response_ ### What engines are you seeing the problem on? AMS ### How to reproduce Init tables in postgres database with `src/main/resources/postgres/ams-postgres-init.sql` Update tables in mysql database with `src/main/resources/mysql/upgrade.sql` ### Relevant log output ```shell ``` ### Anything else _No response_ ### Are you willing to submit a PR? - [x] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's Code of Conduct -- 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]
