bug: If you add predicate condition maybe wrong result.

[haitaoguan]

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!