Issue Number : 700363a
| Issue | 1. A PATH_EMPTY error occurs when executing a query where a subquery is used on the/NOT IN clause. 2. A PATH_EMPTY error occurs when a subquery is nested inside the right side subquery of a NOT IN clause, and there is a Correlated Column within it. |
| Cause | 1. When the left side of the IN clause is a subquery, some necessary information for execution plan generation was not properly configured under certain conditions during the IN โ EXISTS transformation process. 2. During the Unnest process for the subquery in the NOT IN clause, some information related to the Correlated Column was omitted, resulting in an error. |
| Solutions | 1. Modified the logic for handling the left-side expression of the IN clause during the IN โ EXISTS transformation process. 2. Modified the logic for duplicating information related to Correlated Columns. |