Laughingtt opened a new issue, #8363: URL: https://github.com/apache/seatunnel/issues/8363
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened 同步mysql 表时，字段ID为自增状态时，自增状态 AUTO_INCREMENT 不会同步 mysql> show create table test.A; +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | A | CREATE TABLE `A` ( `id` int NOT NULL AUTO_INCREMENT, `data` varchar(50) DEFAULT NULL, `age` int NOT NULL DEFAULT '18', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 | +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show create table test_sink.A; +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ | A | CREATE TABLE `A` ( `id` int NOT NULL, `data` varchar(50) DEFAULT NULL, `age` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) ### SeaTunnel Version 3.8.- ### SeaTunnel Config ```conf { "env": { "parallelism": 1, "job.mode": "batch" }, "source": [ { "plugin_name": "Jdbc", "url": "", "driver": "com.mysql.cj.jdbc.Driver", "connection_check_timeout_sec": 100, "user": "", "password": "", "table_list": [ { "table_path": "test.A" }, { "table_path": "test.B" } ] } ], "sink": [ { "plugin_name": "jdbc", "url": "", "driver": "com.mysql.cj.jdbc.Driver", "user": "", "password": "", "generate_sink_sql": true, "database": "test_sink", "schema_save_mode": "RECREATE_SCHEMA", "data_save_mode": "DROP_DATA" } ] } ``` ### Running Command ```shell post api ``` ### Error Exception ```log null ``` ### Zeta or Flink or Spark Version _No response_ ### Java or Scala Version _No response_ ### Screenshots _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/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: commits-unsubscr...@seatunnel.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
