[
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)