[jira] [Updated] (FLINK-38750) Validation of queries with functions erroneously invoked under select fails with StackOverflow

[Sergey Nuyanzin (Jira)]

     [ 
https://issues.apache.org/jira/browse/FLINK-38750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sergey Nuyanzin updated FLINK-38750:
------------------------------------
    Description: 
Example of such queries leading to {{StackOverflow}}
{code:sql}
SELECT coalesce(SELECT invalid);
{code}

{code:sql}
SELECT coalesce(SELECT coalesce(SELECT invalid));
{code}

{noformat}
java.lang.StackOverflowError
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1120)
        at 
org.apache.calcite.sql.validate.AbstractNamespace.getRowType(AbstractNamespace.java:119)
        at 
org.apache.calcite.sql.validate.SelectNamespace.getRowType(SelectNamespace.java:32)
        at 
org.apache.calcite.sql.validate.AbstractNamespace.getType(AbstractNamespace.java:130)
        at 
org.apache.calcite.sql.validate.SelectNamespace.getType(SelectNamespace.java:32)
        at 
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1123)
        at 
org.apache.calcite.sql.validate.AbstractNamespace.getRowType(AbstractNamespace.java:119)
        at 
org.apache.calcite.sql.validate.SelectNamespace.getRowType(SelectNamespace.java:32)
{noformat}

  was:
Example of such queries leading to {{StackOverflow}}
{code:sql}
SELECT coalesce(SELECT invalid);
{code}

{code:sql}
SELECT coalesce(SELECT coalesce(SELECT invalid));
{code}


> Validation of queries with functions erroneously invoked under select fails 
> with StackOverflow
> ----------------------------------------------------------------------------------------------
>
>                 Key: FLINK-38750
>                 URL: https://issues.apache.org/jira/browse/FLINK-38750
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Planner
>            Reporter: Sergey Nuyanzin
>            Assignee: Sergey Nuyanzin
>            Priority: Major
>
> Example of such queries leading to {{StackOverflow}}
> {code:sql}
> SELECT coalesce(SELECT invalid);
> {code}
> {code:sql}
> SELECT coalesce(SELECT coalesce(SELECT invalid));
> {code}
> {noformat}
> java.lang.StackOverflowError
>       at 
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1120)
>       at 
> org.apache.calcite.sql.validate.AbstractNamespace.getRowType(AbstractNamespace.java:119)
>       at 
> org.apache.calcite.sql.validate.SelectNamespace.getRowType(SelectNamespace.java:32)
>       at 
> org.apache.calcite.sql.validate.AbstractNamespace.getType(AbstractNamespace.java:130)
>       at 
> org.apache.calcite.sql.validate.SelectNamespace.getType(SelectNamespace.java:32)
>       at 
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1123)
>       at 
> org.apache.calcite.sql.validate.AbstractNamespace.getRowType(AbstractNamespace.java:119)
>       at 
> org.apache.calcite.sql.validate.SelectNamespace.getRowType(SelectNamespace.java:32)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)