[Bug]: result is error of the in-subquery sql (correlated columns)

[ouyuanning]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

1、[ERROR] [SCRIPT FILE]: cases/subquery/subquery-with-in.sql [ROW NUMBER]: 10 [SQL STATEMENT]: SELECT 1 FROM (SELECT 1 as a) b WHERE 1 not IN (SELECT (SELECT a));

correlated subquery will support in future version.

Expected Behavior

Steps to Reproduce

No response

Additional information

from #3320

[fengttt]

in general panic bug cannot be 0.6.

[domingozhang]

this will be supported in 0.6.0

[ouyuanning]

this is a feature: support correlated subqueries in projection. i think this issue should be suspended until the feature is finished.

[ouyuanning]

no progress

[ouyuanning]

no progress

[ouyuanning]

this is a feature: support correlated subqueries in projection. i think this issue should be suspended until the feature is finished.

[ouyuanning]

this is a feature: support correlated subqueries in projection. i think this issue should be suspended until the feature is finished.

[ouyuanning]

this is a feature: support correlated subqueries in projection. i think this issue should be suspended until the feature is finished.

[ouyuanning]

this is a feature: support correlated subqueries in projection. i think this issue should be suspended until the feature is finished.

[fengttt]

Convert to P0 dev task.

[ouyuanning]

fixed