sandynz edited a comment on issue #9109: URL: https://github.com/apache/shardingsphere/issues/9109#issuecomment-764400072
> > > Hi @sandynz , I understant that the SQL doesn't have `order by`. > > `SELECT * FROM t_order WHERE order_id>=1 AND order_id<=10;` will get data from `t_order_0` and `t_order_0` and merge the result. > > If you want to sort the result, should specify the sort column. Hi @dongzl , that's true, result ordering is not guaranteed if sql without `order by` clause for all RDBMS. But it could be a trival enhancement when backend is MySQL InnoDB, respond similar result as MySQL might be a little better. ---------------------------------------------------------------- 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: us...@infra.apache.org
