terrymanu opened a new issue #10184:
URL: https://github.com/apache/shardingsphere/issues/10184


   The PostgreSQLBinaryStatementRegistry is different with 
MySQLBinaryStatementRegistry.
   
   The scope of MySQLBinaryStatementRegistry is for proxy instance, all 
connections share same MySQLBinaryStatement map, key of binaryStatements is 
`statementID`, value is `SQL, parameters and parameter types`.
   
   But the scope of PostgreSQLBinaryStatementRegistry is for connection 
instance, per connection hold independent PostgreSQLBinaryStatement map, key is 
`connectionID`, value is `ConnectionScopeBinaryStatementRegistry`, and 
`ConnectionScopeBinaryStatementRegistry` hold another map, key is 
`statementID`, value is `SQL, parameters and parameter types`.
   
   Obviously, PostgreSQLBinaryStatementRegistry has one more layer than 
MySQLBinaryStatementRegistry.
   
   Please clear the PostgreSQLBinaryStatementRegistry data structure. It is 
better to use same data structure with MySQLBinaryStatementRegistry if possible.
   


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


Reply via email to