[GitHub] [shardingsphere] dongzl commented on issue #9109: MySQL InnoDB back-end ShardingSphere-Proxy query result of sql without order by clause is not sorted by primary key ascending

[GitBox]

dongzl commented on issue #9109:
URL: https://github.com/apache/shardingsphere/issues/9109#issuecomment-764174295


   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.


----------------------------------------------------------------
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