SEPURI-SAI-KRISHNA commented on issue #13296: URL: https://github.com/apache/seatunnel/issues/13296#issuecomment-6971213233
@SEZ9 Thanks. The fix is in #13297. It resolves the names in the MySQL-CDC resolver, not in `AlterTableSchemaEventHandler`: other sources can have column names that differ only in case (quoted identifiers in PostgreSQL or Oracle, for example), so a case-insensitive handler would change them. `AbstractSchemaChangeResolver` gets a `resolveColumnName` hook whose default keeps the parsed name, and `MySqlSchemaChangeResolver` maps a name to the one table column that matches it ignoring case, keeping the table's spelling. `MySqlSchemaChangeResolverColumnCaseTest` covers all six DDL cases of the table, including the three that raised no error: `DROP COLUMN Name` and `MODIFY COLUMN NAME VARCHAR(128)` are now applied to `name`, and `CHANGE COLUMN name NAME VARCHAR(128)` keeps `name`, as Debezium's records do. Another case compares the column names after each statement with Debezium's own table model. With the resolver of dev, 9 of its 10 cases fail. -- 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]
