kimmking edited a comment on issue #7091: URL: https://github.com/apache/shardingsphere/issues/7091#issuecomment-681480667
It's a bug. test is a logic table with id as sharding key. > select distinct id,name from test where id=1000 > will be converted to > select distinct id,name from test00 where id=1000 but the subquery can't routing to sharidng table: > select count(1) from (select distinct id,name from test where id=1000)t; > will be converted to > select count(1) from (select distinct id,name from test where id=1000)t; @jingshanglu ---------------------------------------------------------------- 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]
