[Bug][Connector-V2][MySQL] Target tables missing comments and non-primary-key indexes in schema auto-creation #10736

When using SeaTunnel 2.1.13 for data migration from MySQL to MySQL, the tables automatically created in the target database are missing a lot of information compared with the source database tables, such as table comments, column comments, and indexes other than the primary key index. I am not sure if this is normal. If I want the automatically generated tables in the target database to be more complete, what should I do?