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

Sun, 27 Sep 2020 19:12:43 -0700 


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:
[email protected]

Reply via email to