chana71 commented on issue #6497: URL: https://github.com/apache/shardingsphere/issues/6497#issuecomment-694774625
> @chana71 You mean the table `t_order` not been rewrited to actual table? @jingshanglu Actually the log just shows as below. Tested sql is the 3rd one - `select id from (select * from t_order limit 10)a` . ``` Actual SQL: ds0 ::: select id from (select * from t_order limit 10)a Actual SQL: ds1 ::: select id from (select * from t_order limit 10)a Actual SQL: ds2 ::: select id from (select * from t_order limit 10)a Actual SQL: ds3 ::: select id from (select * from t_order limit 10)a ``` but the sql query result will return 40 rows and the rewrite result seems wrong cause I think it should rewrite to `limit 40` each ds as doc says. > ...将偏移量前的记录全部取出，并仅获取排序后的最后10条记录。 ---------------------------------------------------------------- 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]
