sandynz commented on issue #5432: URL: https://github.com/apache/shardingsphere/issues/5432#issuecomment-667690901
Hi, I'd like try to solve it. From masankin's description, part of the sql is : SELECT NULL AS TABLE_CAT, looks the problem is caused by column name is uppercased, I reproduced this problem with H2 database, sql: SELECT user_id AS USER_ID FROM t_order LIMIT 1 . After reading MySQL/PostgreSQL/H2 implementation of java.sql.ResultSet.findColumn(columnLabel), they are different and every one is complicated than DatabaseMetaDataResultSet's implementation, columnLabelIndexMap is not enough to implement findColumn. A possible solution : Delegate DatabaseMetaDataResultSet.findColumn to underlying resultSet.findColumn . ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
