spilledyear opened a new issue #11593:
URL: https://github.com/apache/shardingsphere/issues/11593


   Scene description:
   1. Same DB and sub-table
   2. Set the value of maxConnectionsSizePerQuery greater than 1
   3. Assuming that a logical SQL will be split into two physical SQLs, in the 
scenario where maxConnectionsSizePerQuery is greater than 1, two database 
connections will be created at this time. Two physical SQLs will eventually be 
executed in two database connections
   4. Assuming that there is a query statement next, it is possible that the 
latest data cannot be obtained because of the wrong connection.
   
   
   
   The core code is as follows:
   ResourceManagedExecuteGroupEngine#generateSQLExecuteGroups
   
   
   this is a demo:
   
![image](https://user-images.githubusercontent.com/24663965/127762585-2a31fb11-49e9-4fcc-acba-9de8f49eeb99.png)
   


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

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to