[GitHub] [shardingsphere] wayinit commented on issue #16652: union all not correct in multi table associated queries, but correct in onetable queries.

[GitBox <gi...@apache.org>]

wayinit commented on issue #16652:
URL: https://github.com/apache/shardingsphere/issues/16652#issuecomment-1092638531

   <img width="614" alt="origin_img_v2_f325fe05-13e6-4d0c-a31a-3d9a14d9e3bg" src="https://user-images.githubusercontent.com/16432884/162402122-d208ed77-321e-4504-bf74-cc2867116be1.png">
   I have open this, but also empty.
   And I have found new issuer, 
   when I queries the two tables tb_a_user  tb_apply by each query,
   select * from tb_a_user;
   select * from tb_apply;
   I can got the result of both, 
   but for this sql:
   SELECT tu.use_id,
   tu.tb_mobile,
   ta.class_no
   FROM tb_a_user tu,
   tb_apply ta
   where tu.mem_no = ta.use_id
   and tu.cert_s = 'Y'
   and ta.tb_status = 2
   inner join in two tables association,
   I got empty.
   All tables' rules I made are same of that in two databases db0 and db1, and the data is only in db0 for tb_a_user and tb_apply.


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