flink-connector-jdbc icon indicating copy to clipboard operation
flink-connector-jdbc copied to clipboard
verified publisher icon apache

fix db2 Db2Dialect error

Open andyphone opened this issue 1 year ago • 3 comments

Removed the semicolon from the SQL query as it caused a syntax error . ( Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;columnA, SOURCE.columnB);END-OF-STATEMENT, DRIVER=4.26.14 ) This error only occurs when a primary key is defined in the table structure.

andyphone avatar Dec 30 '24 08:12 andyphone

Thanks for the improvement @andyphone Could you add some test to validate that we don't introduce this again. Thanks

eskabetxe avatar Jan 01 '25 12:01 eskabetxe

@andyphone are in a position to add tests for this, if not I could take this on.

davidradl avatar Nov 11 '25 09:11 davidradl

@davidradl I'm not very familiar with the unit testing process on Git, so I'd really appreciate it if you could take care of this. Thanks!

andyphone avatar Nov 11 '25 09:11 andyphone