You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/09/28 17:26:20 UTC

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

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-unsubscribe@shardingsphere.apache.org

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