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-475133553 1. Set sql.show : true to get a Sharding-JDBC log. 2. I have got your monitor log and understand very clearly, but we talk only Sharding-JDBC log from now on. Don't put your debug info here, thanks. 3. Your monitor log is never a behavior of Sharding-JDBC. To describe a behavior show the **result rows** please. I will not ask you to put 2147483647 rows here, you can only put 11 rows to prove there is a bug. 4. I can't reproduce it because I don't have the configuration, I even don't know what's in your database. 5. Focus on the **result rows**. It's not helpful to analyze before you find out what you want and what you acutally get. 6. More detail. Please **answer** these two questions: Access MySQL Server without Sharding-JDBC: how many rows will return when you execute this SQL? Access MySQL Server with Sharding-JDBC: how many rows will return when you execute this SQL? And put the results here.
---------------------------------------------------------------- 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
