tuohai666 commented on issue #4460: SQL exec `order by` and `desc` feedback result may hung URL: https://github.com/apache/incubator-shardingsphere/issues/4460#issuecomment-599421325 @lklkxcxc The root cause of this problem is an exception fired when query via a existing stream resultset. A stream resultset must be closed before a new query. This problem only occur when order by a String column, because the String order by clause need the collation which is obtained by a SQL query. To avoid the additional SQL query I set useDynamicCharsetInfo = false, and Connector/J will cache the collation instead of send a query to the MySQL server.
---------------------------------------------------------------- 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
