ZhiYu2018 opened a new issue, #21407:
URL: https://github.com/apache/shardingsphere/issues/21407
## Bug Report
when use 5.1.2 to execute sql like this:
select cc,
sum(a) as a,
sum(b) as b,
sum(c) as c
from xxxx
where xxxx = 0
and ec ='xxx'
and cc in('U','B','E', 'u')
group by cc
then the result U has not been aggregated. the result like this:
B,***,***,***,
E,***,***,***.
U,***,***,***.
u,***,***,***.
U,***,***,***.
the U returned two rows when we had two shards.
--
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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
