waylink opened a new issue #7877:
URL: https://github.com/apache/shardingsphere/issues/7877
**About:**
version: 5.0.0-RC1-SNAPSHOT
Sharding: user % 8
origin_sql: SELECT id, user, type FROM user_t WHERE (id > 0) ORDER BY id
ASC limit 10;
actual_sql: SELECT id, user, type FROM user_t_0 WHERE (id > 0) ORDER BY id
ASC limit 10;
Exception at: **_tableMetaData_**
**code:**
private boolean getOrderValuesCaseSensitiveFromTables(final
SelectStatementContext selectStatementContext,
final
PhysicalSchemaMetaData schemaMetaData, final OrderByItem eachOrderByItem)
throws SQLException {
for (SimpleTableSegment eachSimpleTableSegment :
selectStatementContext.getAllTables()) {
String tableName =
eachSimpleTableSegment.getTableName().getIdentifier().getValue();
PhysicalTableMetaData tableMetaData =
schemaMetaData.get(tableName);
Map<String, PhysicalColumnMetaData> columns =
**tableMetaData**.getColumns();
OrderByItemSegment orderByItemSegment =
eachOrderByItem.getSegment();
if (orderByItemSegment instanceof ColumnOrderByItemSegment) {
String columnName = ((ColumnOrderByItemSegment)
orderByItemSegment).getColumn().getIdentifier().getValue();
if (columns.containsKey(columnName)) {
return columns.get(columnName).isCaseSensitive();
}
} else if (orderByItemSegment instanceof
IndexOrderByItemSegment) {
int columnIndex = ((IndexOrderByItemSegment)
orderByItemSegment).getColumnIndex();
String columnName = queryResult.getColumnName(columnIndex);
if (columns.containsKey(columnName)) {
return columns.get(columnName).isCaseSensitive();
}
} else {
return false;
}
}
return false;
}
----------------------------------------------------------------
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]
