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]

Reply via email to