wayinit opened a new issue, #16650:
URL: https://github.com/apache/shardingsphere/issues/16650
### Which version of ShardingSphere did you use?
ShardingSphere proxy 5.1.0
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-proxy
### Expected behavior
show the result
### Actual behavior
got an error
### Reason analyze (If you can)
Errors will be reported when using functions in multi table associated
queries, but correct in one table queries.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
got an error:
SELECT tmp.id,
tmk.tb_mem_no mem_no,
tmk.tb_kyc_flag kyc_flag
FROM tb_mem_personal tmp,
tb_mem_kyc tmk,
tb_country tc
WHERE tmk.id = tmp.tb_kyc_id
AND tc.tb_country_code = tmk.tb_credentials_city
AND DATE_FORMAT(tmp.kyc_submit_time, '%Y%m%d') = date_format(now(),
'%Y%m%d');
no error:
SELECT tmp.id FROM tb_mem_personal tmp where
DATE_FORMAT(tmp.kyc_submit_time, '%Y%m%d') = date_format(now(), '%Y%m%d');
--
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]
