stonedb
stonedb copied to clipboard
bug: If you add predicate condition maybe wrong result.
Have you read the Contributing Guidelines on issues?
- [X] I have read the Contributing Guidelines on issues.
Please confirm if bug report does NOT exists already ?
- [X] I confirm there is no existing issue for this
Describe the problem
SELECT a.currency_id,
a.currency_name,
d.taxis_no
FROM c1md_bank_acct a
JOIN c1cd_currency d
ON a.currency_id = d.row_id
AND d.deleted_flag = '0'
LEFT JOIN c1cd_exchange_rate r
ON a.currency_id = r.currency_id
AND r.deleted_flag = '0'
AND r.using_flag = '1'
Expected behavior
No response
How To Reproduce
No response
Environment
./mysqld Ver 5.7.36-StoneDB-v1.0.4 for Linux on x86_64 (build-) build information as follow: Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev Branch name: stonedb-5.7-dev Last commit ID: f3a16d5 Last commit time: Date: Mon Jul 17 17:29:19 2023 +0800 Build time: Date: Tue Jul 18 01:14:09 UTC 2023
Are you interested in submitting a PR to solve the problem?
- [X] Yes, I will!