seowen808 opened a new issue #7052: URL: https://github.com/apache/shardingsphere/issues/7052
SpringBoot2.3 +mybatis+mysql8 integration sharding 4.1.1, Use read/write separation + sharding.When there is Group BY in the SQL statement, sharding fails and cannot be routed to a specific physical table.After removing Group BY.You can route to a specific table and execute successfully. The Springboot YAML configuration is as follows：  Some of the important code (with GRUop by) is as follows：  The output log is executed as follows (cannot be routed to CONSUMER_link_8 and consumer_link_9)：  Some of the important code (without GRUop BY) is as follows：  The output log is executed as follows (successfully routed to CONSUMER_link_8 and consumer_link_9)：  ---------------------------------------------------------------- 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]
