Issue Number: 700479a
| Issue | When a query using LEFT OUTER JOIN includes a column from the right table as the comparison target in the NOT IN clause, the result may be returned incorrectly under certain conditions. |
| Cause | Even if the left value in the NOT IN clause is NULL, if there are no results in the right subquery, the condition may be evaluated as true. However, the previous logic did not sufficiently account for these cases, resulting in the condition being handled ambiguously, which could cause the join processing method to be applied differently from the intended behavior. |
| Solutions | The logic for evaluating conditions when NULL values are included in IN / NOT IN clauses has been improved. The IN clause is now handled as false or indeterminate, and the NOT IN clause is handled as true or indeterminate, ensuring that the meaning of the condition is accurately reflected. |