[CALCITE-3788] SqlValidatorImpl.registerOperandSubQueries should skip creating SCALAR_QUERY call when operand is a SqlSelect cause the SqlSelect does not return a scalar value

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Rui Wang
• Created: 12/Feb/20 20:23
• Updated: 14/Aug/20 05:50
• Resolved: 14/Aug/20 05:50

Description

For a table function which uses named argument for a TABLE parameter:

Select * From
TABLE(TUMBLE(
           data =>  TABLE orders
           ...
)

The TABLE parameter will be wrapped by a SCALAR_QUERY call at this line: https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/validate/SqlValidatorImpl.java#L3067

However, it is wrong because TABLE paramter is not a query that returns a scalar value.

It cannot be solved by overriding SqlOperator.argumentMustBeScalar because named argument is a special operator that doesn't tied with other operators.

One possible resolution is also check if operand is SqlSelect at SqlValidatorImpl.java#L3067.

Issue Links

• duplicates: CALCITE-4171 Support named parameters for table window functions