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


Reply via email to