You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2017/06/28 22:57:00 UTC

[jira] [Created] (CALCITE-1862) StackOverflowException in RelMdUtil.estimateFilteredRows

Julian Hyde created CALCITE-1862:
------------------------------------

             Summary: StackOverflowException in RelMdUtil.estimateFilteredRows
                 Key: CALCITE-1862
                 URL: https://issues.apache.org/jira/browse/CALCITE-1862
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


The query

{code}select *
from (
  select *
  from (
    select cast(null as integer) as d
    from "scott".emp)
  where d is null and d is null)
where d is null;{code}

gives

{noformat}
java.lang.StackOverflowError
> 	at org.apache.calcite.adapter.clone.ArrayTable.getStatistic(ArrayTable.java:76)
> 	at org.apache.calcite.prepare.RelOptTableImpl.getRowCount(RelOptTableImpl.java:224)
> 	at org.apache.calcite.rel.core.TableScan.estimateRowCount(TableScan.java:75)
> 	at org.apache.calcite.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:206)
> 	at GeneratedMetadataHandler_RowCount.getRowCount_$(Unknown Source)
> 	at GeneratedMetadataHandler_RowCount.getRowCount(Unknown Source)
> 	at org.apache.calcite.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:236)
> 	at org.apache.calcite.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:71)
> 	at GeneratedMetadataHandler_RowCount.getRowCount_$(Unknown Source)
> 	at GeneratedMetadataHandler_RowCount.getRowCount(Unknown Source)
> 	at org.apache.calcite.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:236)
> 	at org.apache.calcite.rel.metadata.RelMdUtil.estimateFilteredRows(RelMdUtil.java:718)
> 	at org.apache.calcite.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:123)
> 	at GeneratedMetadataHandler_RowCount.getRowCount_$(Unknown Source)
> 	at GeneratedMetadataHandler_RowCount.getRowCount(Unknown Source)
> 	at org.apache.calcite.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:236)
> 	at org.apache.calcite.rel.metadata.RelMdRowCount.getRowCount(RelMdRowCount.java:71)
> 	at GeneratedMetadataHandler_RowCount.getRowCount_$(Unknown Source)
> 	at GeneratedMetadataHandler_RowCount.getRowCount(Unknown Source)
> 	at org.apache.calcite.rel.metadata.RelMetadataQuery.getRowCount(RelMetadataQuery.java:236)
> 	at org.apache.calcite.rel.metadata.RelMdUtil.estimateFilteredRows(RelMdUtil.java:718){noformat}

For a test case, add the query to misc.iq and run QuidemTest.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)