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/10 06:41:40 UTC

[GitHub] [shardingsphere] xfzhaoGit opened a new issue, #15798: query result bug

xfzhaoGit opened a new issue, #15798:
URL: https://github.com/apache/shardingsphere/issues/15798

   ## Bug Report
   
   **For English only**, other languages will not accept.
   .org/document/current/en/overview).
   
   SELECT
   b.id,
   a.name,
   IFNULL(b.signTime, ''),
   date_str dateStr
   FROM
   user a
   LEFT JOIN (
   SELECT
   sum(sign_time) AS signTime,
   date_str,
   user_id,
   FROM
   user_sign_record <!— Slice table —>
   WHERE
   user_id = ?
   GROUP BY date_str
   ) b ON a.id = b.user_id
   ORDER BY a.name
   
   user:
   id | name
   ---|---
   1 | zhangsan
   2 | lisi
   
   user_sign_record
   id | user_id | sign_time| date_str
   ---|---|---|---
   1 | 1 | 1000|2022-03-04
   2 | 2 | 1000|2022-03-04
   
   user_sign_record2022
   id | user_id | sign_time| date_str
   ---|---|---|---
   1 | 1 | 500|2022-03-04
   2 | 2 | 500|2022-03-04
   
   `create_date`  is sharding key,  this sql is all tables scans.
   
   expectd：
   id | name |dateStr| signTime
   ---|---|---|---
   1 | zhangsan|2022-03-04 | 1500
   2 | lisi |2022-03-04| 1500
   
   actual：
   id | name | dateStr| signTime
   ---|---|---|---
   1 | zhangsan|2022-03-04 | 1000
   2 | lisi|2022-03-04 | 1000
   
   or
   
   id | name | dateStr| signTime
   ---|---|---|---
   1 | zhangsan|2022-03-04 | 500
   2 | lisi|2022-03-04 | 500
   
   ### Which version of ShardingSphere did you use?
   5.1.0
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-JDBC 
   
   


-- 
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 #15798: query result bug

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.

RaigorJiang closed issue #15798: query result bug
URL: https://github.com/apache/shardingsphere/issues/15798


-- 
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] github-actions[bot] commented on issue #15798: query result bug

Posted by GitBox <gi...@apache.org>.

github-actions[bot] commented on issue #15798:
URL: https://github.com/apache/shardingsphere/issues/15798#issuecomment-1272350254

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
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] github-actions[bot] closed issue #15798: query result bug

Posted by GitBox <gi...@apache.org>.

github-actions[bot] closed issue #15798: query result bug
URL: https://github.com/apache/shardingsphere/issues/15798


-- 
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 #15798: query result bug

Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.

RaigorJiang commented on issue #15798:
URL: https://github.com/apache/shardingsphere/issues/15798#issuecomment-1407578236

   This issue has been inactive for a long time, so I will close it.
   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