[GitHub] [shardingsphere] KnothHe commented on issue #21233: ShardingSphere5.1.1 does not support querying JSON data from MySQL, ShardingSphere4.1.1 is available

[GitBox]

KnothHe commented on issue #21233:
URL: 
https://github.com/apache/shardingsphere/issues/21233#issuecomment-1261229649

    @sxlArtless 
   
   In my test, ShardingSphere 5.1.1  is okay, ShardingSphere 4.1.1 is run with 
error. The reason is incorrect parsing of SQL by the results of the test. 
Resulting in no routing table, query error.
   
   For simplicity, JdbcTemplate is used
   
   <img width="2390" alt="image" 
src="https://user-images.githubusercontent.com/25814839/192848610-985f9a25-da2e-4693-9af9-3e631b71a08c.png";>
   
   
   <img width="2089" alt="image" 
src="https://user-images.githubusercontent.com/25814839/192846251-340ed91d-6b48-4de8-8726-6beeabdf2b2e.png";>
   
   I have uploaded my test project, you can test it. Checkout different branch 
to test different sharding version.
   [address](https://github.com/KnothHe/sharding-issues-21233)
   


-- 
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: notifications-unsubscr...@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org