[ 
https://issues.apache.org/jira/browse/FLINK-38750?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18042186#comment-18042186
 ] 

Sergey Nuyanzin commented on FLINK-38750:
-----------------------------------------

1.20: 
[042956cb626513cca1ba074dc3e2707ee2d9b8e7|https://github.com/apache/flink/commit/042956cb626513cca1ba074dc3e2707ee2d9b8e7]
2.1: 
[d875af901b4a3a3a8788977e8bbefe3a6f5491e9|https://github.com/apache/flink/commit/d875af901b4a3a3a8788977e8bbefe3a6f5491e9]
2.2: 
[ad47717862567f76216e68a07b474a593382001e|https://github.com/apache/flink/commit/ad47717862567f76216e68a07b474a593382001e]

> 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
>              Labels: pull-request-available
>             Fix For: 2.3.0
>
>
> 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)

Reply via email to