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/09/28 02:08:52 UTC

[GitHub] [shardingsphere] asdxiaoqex opened a new issue #7636: 关于子查询的问题

asdxiaoqex opened a new issue #7636:
URL: https://github.com/apache/shardingsphere/issues/7636


   select g.create_time as createTime, g.group_id as groupId, g.parent_id as parentId, g.title as title, g.remark as remark, g.status as status, (select (case when count(1) != 0 then true else false end)
    FROM tb_user_group ug
    WHERE ug.has_deleted = 'False' and ug.user_id = 'root' and ug.group_id = g.group_id ) as selected
    FROM tb_group g
    WHERE g.has_deleted = 'False';
   ![image](https://user-images.githubusercontent.com/50010140/94383378-7376d800-0172-11eb-9e89-102d551e80de.png)
   但是用Navicat查询是有数据的 或者 不适用sharding jdbc也是 有数据的
   如图
   ![image](https://user-images.githubusercontent.com/50010140/94383418-8d181f80-0172-11eb-9bb3-a57f2568f935.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:
users@infra.apache.org

[GitHub] [shardingsphere] asdxiaoqex commented on issue #7636: 关于子查询的问题

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


   ![image](https://user-images.githubusercontent.com/50010140/94383450-ab7e1b00-0172-11eb-81e6-d8745cf5e38e.png)
   ![image](https://user-images.githubusercontent.com/50010140/94383463-b5a01980-0172-11eb-8f7d-8d9e3686bf92.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:
users@infra.apache.org

[GitHub] [shardingsphere] asdxiaoqex commented on issue #7636: 关于子查询的问题

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


   > select g.create_time as createTime, g.group_id as groupId, g.parent_id as parentId, g.title as title, g.remark as remark, g.status as status, (select (case when count(1) != 0 then true else false end)
   > FROM tb_user_group ug
   > WHERE ug.has_deleted = 'False' and ug.user_id = 'root' and ug.group_id = g.group_id ) as selected
   > FROM tb_group g
   > WHERE g.has_deleted = 'False';
   > ![image](https://user-images.githubusercontent.com/50010140/94383378-7376d800-0172-11eb-9e89-102d551e80de.png)
   > 但是用Navicat查询是有数据的 或者 不使用sharding jdbc也是 有数据的
   > 如图
   > ![image](https://user-images.githubusercontent.com/50010140/94383418-8d181f80-0172-11eb-9bb3-a57f2568f935.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:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #7636: 关于子查询的问题

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


   @asdxiaoqex For english only, other languages ​​will not be accepted.


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

[GitHub] [shardingsphere] strongduanmu closed issue #7636: 关于子查询的问题

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #7636:
URL: https://github.com/apache/shardingsphere/issues/7636


   


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