xuschang opened a new issue, #27878: URL: https://github.com/apache/shardingsphere/issues/27878
## Bug Report ShardingSphere-JDBC:5.4.0 When using Oracle as a shardingDataSource, MyBatis will convert the selectCount statement to SELECT COUNT( * ) for execution. ColumnLabelAndIndexMap in ShardingResultSet stores the original column name and index value, which is [COUNT( * ),index]. However, Oracle returns the column name as COUNT(*), causing an error when retrieving the index. Related error Error attempting to get column 'COUNT(*)' from result set. Cause: java.sql.SQLFeatureNotSupportedException: Can not get index from column label `COUNT(*)`.\n; Can not get index from column label `COUNT(*)`.; nested exception is java.sql.SQLFeatureNotSupportedException: Can not get index from column label `COUNT(*)`. The relevant code is as follows   -- 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]
