[jira] [Created] (CALCITE-3788) SqlValidatorImpl.registerOperandSubQueries should skip creating SCALAR_QUERY call when operand is a SqlSelect

["Rui Wang (Jira)" <ji...@apache.org>]

Rui Wang created CALCITE-3788:
---------------------------------

             Summary: SqlValidatorImpl.registerOperandSubQueries should skip creating SCALAR_QUERY call when operand is a SqlSelect
                 Key: CALCITE-3788
                 URL: https://issues.apache.org/jira/browse/CALCITE-3788
             Project: Calcite
          Issue Type: Sub-task
            Reporter: Rui Wang
            Assignee: Rui Wang


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.






--
This message was sent by Atlassian Jira
(v8.3.4#803005)