Repository navigation
Validate subquery expressions #2361
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
The SQL query planner and the DataFrame API both allow logical plans to be created that contain subquery expressions but we do not yet do any validation on these expressions.
Examples of validation we should do:
- Scalar subqueries should return a single row and single column
- IN subqueries should return a single column
Describe the solution you'd like
I am leaning towards performing this validation in an optimizer rule because that would be applied regardless of how the logical plan was created.
Describe alternatives you've considered
None
Additional context
None
Activity
jon-chuang commentedon May 7, 2022
@andygrove is there any reason why we can't support multiple columns in the IN subquery? As far as implementation goes, it's fairly trivial.
mingmwang commentedon Mar 13, 2023
I am working on it now.
mingmwang commentedon Mar 13, 2023
@jon-chuang
I think we do not support named Struct in DataFusion today.
mingmwang commentedon May 17, 2023
This issue is resolved.