tuohai666 commented on issue #2062: Wrong LIMIT rewrite while GROUP BY and ORDER BY on different items URL: https://github.com/apache/incubator-shardingsphere/issues/2062#issuecomment-475105768 I am not very sure what's the problem. I don't know where the log come from. So I must know the behavior. Let me guess what the program behavior you haven seen: 1. You input a sql and expect a result with 10 rows. If you don't use Sharding-JDBC, you connect to mysql directly, execute the same sql, you got 10 rows. That means your expect is right. 2. But you **got** and **saw** 2147483647 rows in your screen. Please answer are the two above right? If they are right, please prove you got 2147483647 rows, you don't need to past all 2147483647, but try to prove it. Don't use log to prove it, I think the log is not from Sharding-JDBC. Also, please provide the example codes and configurations. BTW, **What I input is limit 0, 10** is your behavior, it's not the program behavior.
---------------------------------------------------------------- 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] With regards, Apache Git Services
