taigam opened a new issue #8478: URL: https://github.com/apache/shardingsphere/issues/8478
## Bug Report **For English only**, other languages will not accept. Before report a bug, make sure you have: - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues). - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview). Please pay attention on issues you submitted, because we maybe need more details. If no response anymore and we cannot reproduce it on current information, we will **close it**. Please answer these questions before submitting your issue. Thanks! ### Which version of ShardingSphere did you use? <dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId> <version>5.0.0-alpha</version> </dependency> ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-JDBC 2020-12-03 09:48:25.162 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -Logic SQL: SELECT count(0) FROM (SELECT a.group_id, a.group_code, a.group_name, a.data_source_flag, a.data_source_type, a.auto_syn_status, b.app_name, count(c.user_id) AS active_user FROM user_info c LEFT JOIN group_info a ON a.group_id = c.group_id INNER JOIN application b ON a.app_code = b.app_code GROUP BY c.group_id) table_count 2020-12-03 09:48:25.162 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -SQLStatement: MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty) 2020-12-03 09:48:25.163 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -Actual SQL: magic-image0 ::: SELECT count(0) FROM (SELECT a.group_id, a.group_code, a.group_name, a.data_source_flag, a.data_source_type, a.auto_syn_status, b.app_name, count(c.user_id) AS active_user FROM user_info0 c LEFT JOIN group_info a ON a.group_id = c.group_id INNER JOIN application b ON a.app_code = b.app_code GROUP BY c.group_id) table_count 2020-12-03 09:48:25.163 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -Actual SQL: magic-image0 ::: SELECT count(0) FROM (SELECT a.group_id, a.group_code, a.group_name, a.data_source_flag, a.data_source_type, a.auto_syn_status, b.app_name, count(c.user_id) AS active_user FROM user_info1 c LEFT JOIN group_info a ON a.group_id = c.group_id INNER JOIN application b ON a.app_code = b.app_code GROUP BY c.group_id) table_count 2020-12-03 09:48:25.163 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -Actual SQL: magic-image1 ::: SELECT count(0) FROM (SELECT a.group_id, a.group_code, a.group_name, a.data_source_flag, a.data_source_type, a.auto_syn_status, b.app_name, count(c.user_id) AS active_user FROM user_info0 c LEFT JOIN group_info a ON a.group_id = c.group_id INNER JOIN application b ON a.app_code = b.app_code GROUP BY c.group_id) table_count 2020-12-03 09:48:25.163 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -Actual SQL: magic-image1 ::: SELECT count(0) FROM (SELECT a.group_id, a.group_code, a.group_name, a.data_source_flag, a.data_source_type, a.auto_syn_status, b.app_name, count(c.user_id) AS active_user FROM user_info1 c LEFT JOIN group_info a ON a.group_id = c.group_id INNER JOIN application b ON a.app_code = b.app_code GROUP BY c.group_id) table_count 2020-12-03 09:48:25.164 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -Actual SQL: magic-image2 ::: SELECT count(0) FROM (SELECT a.group_id, a.group_code, a.group_name, a.data_source_flag, a.data_source_type, a.auto_syn_status, b.app_name, count(c.user_id) AS active_user FROM user_info0 c LEFT JOIN group_info a ON a.group_id = c.group_id INNER JOIN application b ON a.app_code = b.app_code GROUP BY c.group_id) table_count 2020-12-03 09:48:25.164 INFO [http-nio-8443-exec-2]ShardingSphere-SQL.log:74 -Actual SQL: magic-image2 ::: SELECT count(0) FROM (SELECT a.group_id, a.group_code, a.group_name, a.data_source_flag, a.data_source_type, a.auto_syn_status, b.app_name, count(c.user_id) AS active_user FROM user_info1 c LEFT JOIN group_info a ON a.group_id = c.group_id INNER JOIN application b ON a.app_code = b.app_code GROUP BY c.group_id) table_count when i excute this sql ` private boolean getValueCaseSensitiveFromTables(final QueryResult queryResult, final SelectStatementContext selectStatementContext, final PhysicalSchemaMetaData schemaMetaData, final int columnIndex) throws SQLException { for (SimpleTableSegment each : selectStatementContext.getSimpleTableSegments()) { String tableName = each.getTableName().getIdentifier().getValue(); PhysicalTableMetaData tableMetaData = schemaMetaData.get(tableName); Map<String, PhysicalColumnMetaData> columns = tableMetaData.getColumns(); String columnName = queryResult.getColumnName(columnIndex); if (columns.containsKey(columnName)) { return columns.get(columnName).isCaseSensitive(); } } return false; }` the table group_info is in broadcast-tables schemaMetaData can't get the table tableMetaData will be null what 's wrong with it ? ---------------------------------------------------------------- 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]
