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/10/09 02:07:19 UTC

[GitHub] [shardingsphere] ZhiYu2018 opened a new issue, #21407: 5.1.2 group by function bug

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

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

[GitHub] [shardingsphere] RaigorJiang closed issue #21407: 5.1.2 group by function bug

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #21407: 5.1.2 group by function bug 
URL: https://github.com/apache/shardingsphere/issues/21407


-- 
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

[GitHub] [shardingsphere] RaigorJiang commented on issue #21407: 5.1.2 group by function bug

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #21407:
URL: https://github.com/apache/shardingsphere/issues/21407#issuecomment-1407270947

   Closed due to no response.
   If this problem persists, please reopen it or submit a new one.


-- 
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

[GitHub] [shardingsphere] TeslaCN commented on issue #21407: 5.1.2 group by function bug

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #21407:
URL: https://github.com/apache/shardingsphere/issues/21407#issuecomment-1364887237

   Please try the ShardingSphere 5.3.0.


-- 
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