[GitHub] [shardingsphere] seowen808 opened a new issue #7050: sql cannot be sharded using Group BY

Mon, 24 Aug 2020 23:45:06 -0700 


seowen808 opened a new issue #7050:
URL: https://github.com/apache/shardingsphere/issues/7050


    用springBoot2.3+mybatis+mysql8 集成sharding 4.1.1，
   使用读写分离+分片。当sql语句中 有 group by 时，就会分片失败，无法路由到具体的物理表。  去掉 group 
by后。就可以路由到具体表，并执行成功.
   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.
   
   springboot yaml 配置如下：
   
![image](https://user-images.githubusercontent.com/46375421/91130850-e3f78880-e6de-11ea-955e-b5db43dea7f4.png)
   **核心代码(带gruop by)如下：**
   
![image](https://user-images.githubusercontent.com/46375421/91132986-ec03f800-e6df-11ea-97c8-9eab9b93032b.png)
   
   执行的输出日志如下(无法路由到consumer_link_8和 consumer_link_9)：
   
![image](https://user-images.githubusercontent.com/46375421/91131531-8283e980-e6df-11ea-8c48-75f9b60656af.png)
   
   **核心代码(不带gruop by)如下：**
   
![image](https://user-images.githubusercontent.com/46375421/91133235-fde59b00-e6df-11ea-92e6-366a2667340d.png)
   
   执行的输出日志如下(成功路由到consumer_link_8和 consumer_link_9)：
   
![image](https://user-images.githubusercontent.com/46375421/91138017-61bc9380-e6e1-11ea-8eaf-f1d7a6bbf875.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.

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

Reply via email to