[
https://issues.apache.org/jira/browse/CALCITE-6374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17838774#comment-17838774
]
Julian Hyde commented on CALCITE-6374:
--------------------------------------
[~allendang], Can you please remove the PNG and replace it with text. Use full
words, e.g. NullPointerException. This makes the case searchable.
> LatticeSuggester throw npe when agg call covered with cast
> -----------------------------------------------------------
>
> Key: CALCITE-6374
> URL: https://issues.apache.org/jira/browse/CALCITE-6374
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: allendang
> Priority: Critical
> Attachments: image-2024-04-18-21-44-04-262.png
>
>
> org.apache.calcite.materialize.LatticeSuggesterTest#testExpressionEvolution
>
> final String q1 = "select\n"
> + " \"num_children_at_home\" + 10 as \"n10\",\n"
> + " \"num_children_at_home\" + 14 as \"n14\",\n"
> + " cast(sum(\"num_children_at_home\" + 12) as double) as \"n12\",\n"
> + " sum(\"num_children_at_home\" + 13) as \"n13\"\n"
> + "from \"customer\"\n"
> + "group by \"num_children_at_home\" + 10,"
> + " \"num_children_at_home\" + 14";
>
> measure.name
> java.lang.NullPointerException: measure.name
> at java.util.Objects.requireNonNull(Objects.java:228)
> at
> org.apache.calcite.materialize.LatticeSuggester.deriveAlias(LatticeSuggester.java:290)
> at
> org.apache.calcite.materialize.LatticeSuggester.lambda$addFrame$3(LatticeSuggester.java:250)
> at org.apache.calcite.util.Util$TransformingList.get(Util.java:2810)
> at java.util.AbstractList$Itr.next(AbstractList.java:358)
> at java.util.AbstractCollection.toArray(AbstractCollection.java:141)
> at com.google.common.collect.ImmutableList.copyOf(ImmutableList.java:265)
> at com.google.common.collect.ImmutableList.copyOf(ImmutableList.java:238)
> at org.apache.calcite.materialize.Lattice$Measure.<init>(Lattice.java:567)
> at
> org.apache.calcite.materialize.LatticeSuggester.addFrame(LatticeSuggester.java:240)
> at
> org.apache.calcite.materialize.LatticeSuggester.lambda$addQuery$1(LatticeSuggester.java:143)
> at java.util.ArrayList.forEach(ArrayList.java:1259)
> at
> org.apache.calcite.materialize.LatticeSuggester.addQuery(LatticeSuggester.java:143)
> at
> org.apache.calcite.materialize.LatticeSuggesterTest$Tester.addQuery(LatticeSuggesterTest.java:851)
> at
> org.apache.calcite.materialize.LatticeSuggesterTest.testExpressionEvolution(LatticeSuggesterTest.java:551)
> !image-2024-04-18-21-44-04-262.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
