You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/12/03 01:59:46 UTC
[GitHub] [shardingsphere] taigam opened a new issue #8478: 'group by 'error 5.0.0
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:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #8478: 'group by 'error 5.0.0
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #8478:
URL: https://github.com/apache/shardingsphere/issues/8478#issuecomment-744460980
Closed because of no response
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #8478: 'group by 'error 5.0.0
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #8478:
URL: https://github.com/apache/shardingsphere/issues/8478#issuecomment-744001100
@taigam Hi, can you give me a reply?
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #8478: 'group by 'error 5.0.0
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #8478:
URL: https://github.com/apache/shardingsphere/issues/8478#issuecomment-739253579
@taigam Can you provide the sharding configuration and table structure? I will try to reproduce this problem.
----------------------------------------------------------------
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:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #8478: 'group by 'error 5.0.0
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #8478:
URL: https://github.com/apache/shardingsphere/issues/8478
----------------------------------------------------------------
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:
users@infra.apache.org