flike/kingshard

order by 表名没有被解析成对应分表的名称

ziux opened this issue · 0 comments

ziux commented

select * FROM test_shard_hash ORDER BY test_shard_hash.id

order by中的表名没有被解析成对应分表的名称
2020/09/04 19:07:29 - ERROR - 0.2ms - 127.0.0.1:49780->127.0.0.1:3306:select test_shard_hash_0000.id as test_shard_hash_id, test_shard_hash_0000.name as test_shard_hash_name, test_shard_hash_0000.name1 as test_shard_hash_name1, test_shard_hash_0000.name2 as test_shard_hash_name2 from test_shard_hash_0000 order by test_shard_hash.id asc
2020/09/04 19:07:29 - ERROR - 0.1ms - 127.0.0.1:49780->127.0.0.1:3306:select test_shard_hash_0001.id as test_shard_hash_id, test_shard_hash_0001.name as test_shard_hash_name, test_shard_hash_0001.name1 as test_shard_hash_name1, test_shard_hash_0001.name2 as test_shard_hash_name2 from test_shard_hash_0001 order by test_shard_hash.id asc
2020/09/04 19:07:29 - ERROR - 0.2ms - 127.0.0.1:49780->127.0.0.1:3306:select test_shard_hash_0002.id as test_shard_hash_id, test_shard_hash_0002.name as test_shard_hash_name, test_shard_hash_0002.name1 as test_shard_hash_name1, test_shard_hash_0002.name2 as test_shard_hash_name2 from test_shard_hash_0002 order by test_shard_hash.id asc
2020/09/04 19:07:29 - ERROR - 0.2ms - 127.0.0.1:49780->127.0.0.1:3306:select test_shard_hash_0003.id as test_shard_hash_id, test_shard_hash_0003.name as test_shard_hash_name, test_shard_hash_0003.name1 as test_shard_hash_name1, test_shard_hash_0003.name2 as test_shard_hash_name2 from test_shard_hash_0003 order by test_shard_hash.id asc
2020/09/04 19:07:29 - ERROR - conn_select.go:[126] - [ClientConn] "handleSelect" "ERROR 1054 (42S22): Unknown column 'test_shard_hash.id' in 'order clause'" "" conn_id=10024
2020/09/04 19:07:29 - ERROR - conn.go:[316] - [ClientConn] "Run" "ERROR 1054 (42S22): Unknown column 'test_shard_hash.id' in 'order clause'" "" conn_id=10024