qiuweilu commented on issue #33355:
URL:
https://github.com/apache/shardingsphere/issues/33355#issuecomment-2430685469
```
SELECT part_cmnt.*
FROM part_cmnt
LEFT JOIN part_vote ON part_vote.part_fkid = part_cmnt.part_fkid
AND part_vote.part_fkid = #{partFkid,jdbcType=BIGINT}
AND part_vote.vote_label = #{voteLabel,jdbcType=VARCHAR}
AND part_vote.vote_mark = #{voteMark,jdbcType=VARCHAR}
AND part_vote.vote_del = 0
WHERE part_cmnt.part_fkid = #{partFkid,jdbcType=BIGINT}
AND part_cmnt.cmnt_label = #{cmntLabel,jdbcType=VARCHAR}
AND part_cmnt.cmnt_mark = #{cmntMark,jdbcType=VARCHAR}
AND part_cmnt.cmnt_score <= #{cmntScore,jdbcType=INTEGER}
AND part_cmnt.cmnt_ctime >= #{cmntCtime,jdbcType=TIMESTAMP}
AND part_cmnt.cmnt_del = 0
```
When I changed the join key in a left join to part_fkid according to the
documentation, it still executed a Cartesian product query.
--
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]
