Issue Number : 700534a
| Issue | When the Join condition of an Anti Join is an equality comparison condition and all columns used in that condition are from the outer table of the subquery, if there is another general condition using one of these columns, the query results may be incorrect. |
| Cause | EQC optimization is performed even in cases where it should not be applied, causing incorrect conditions to be added and resulting in incorrect results. |
| Solutions | Modify so that when the Join condition of the Anti Join is in the form L=R (where L is a column from the outer table of the subquery and R is a column from the subquery table), and there is another general condition using the L column, only then generate the R column condition using this. |