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 2020/01/08 11:33:03 UTC
[GitHub] [incubator-shardingsphere] taojintianxia commented on issue #3869:
version:4.0.0-RC1 group by bug
taojintianxia commented on issue #3869: version:4.0.0-RC1 group by bug
URL: https://github.com/apache/incubator-shardingsphere/issues/3869#issuecomment-572009947
> sharding version: 4.0.0-RC1
> mybatis-plus version: 3.2.0
> logic table name:C
> related physical tables and datas as follows:
> table A:
> act_amount order_type
> 1000 0
> 1000 1
>
> table B:
> act_amount order_type
> 300 0
> 500 1
>
> sql desc: select order_type,sum(act_amount) from C group by order_type
> result expected:
> order_type sum(act_amount)
> 0 1300
> 1 1500
> but the real result is :
> order_type sum(act_amount)
> 0 1000
> 1 1000
> thus it can be seen that the result data comes from table A only and the table B data is discarded
After I tried the test senario you described , I got the result you expected
The version of frameworks I used as followings :
|name|version|
|-|-|
|sharding-jdbc-spring-boot-starter | 4.0.0-RC3 |
|mybatis-plus-boot-starter | 3.3.0 |
|springboot | 1.5.22.RELEASE |
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services