suibianwanwank commented on PR #4177:
URL: https://github.com/apache/calcite/pull/4177#issuecomment-2648780856
@antonkw Maybe I’m overthinking it, but I still believe that only
considering NOT and EXISTS doesn't cover all possible cases for subqueries.
Could you try the example with
```
final String sql = "SELECT * FROM "
+ "(select * from ("
+ "select e1.\"product_id\" FROM \"foodmart\".\"product\" e1 "
+ "LEFT JOIN \"foodmart\".\"product\" e3 "
+ "on e1.\"product_id\" = e3.\"product_id\""
+ ")"
+ ") selected where 1 in\n"
+ "(select \"gross_weight\" from \"foodmart\".\"product\" e2 "
+ "where e2.\"product_id\" = selected.\"product_id\" and
e2.\"product_id\" > 10)";
```
and see if it works?
--
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]
