wayinit opened a new issue, #16652:
URL: https://github.com/apache/shardingsphere/issues/16652
### Which version of ShardingSphere did you use?
5.1.0
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
shardingsphere-proxy
### Expected behavior
get the result
### Actual behavior
no result, empty
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
like the SQL, when I use multi table associated queries, the result is
empty, but the tables has data.
SELECT tu.use_id,
tu.tb_mobile,
ta.class_no
FROM tb_user tu,
tb_apply ta
where tu.use_id = ta.use_id
and tu.tb_cert_s = 'Y'
and ta.tb_status = 2
union all
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
but only union all the tb_user and tb_a_user, I can get the result.
for this sutuation, there is just tb_a_user has data.
--
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:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
