You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Min-Seok Kim (Jira)" <ji...@apache.org> on 2023/05/22 09:19:00 UTC

[jira] [Commented] (CALCITE-5712) VolcanoPlanner with FilterableTable shows wrong best cost

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

Min-Seok Kim commented on CALCITE-5712:
---------------------------------------

i've modified the description.

> VolcanoPlanner with FilterableTable shows wrong best cost 
> ----------------------------------------------------------
>
>                 Key: CALCITE-5712
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5712
>             Project: Calcite
>          Issue Type: Bug
>         Environment: Operating System: macOS Ventura 13.3.1(22E261)
> JDK Version: openjdk version "17.0.5" 2022-10-18 LTS
>            Reporter: Min-Seok Kim
>            Priority: Major
>         Attachments: image-2023-05-19-16-09-28-894.png
>
>
> We've encountered an issue in the interaction between the VolcanoPlanner and FilterableTable. Specifically, when the org.apache.calcite.util.trace.getPlannerTracer logger level is set to DEBUG, the isValid method within VolcanoPlanner throws an exception.
> *Steps to Reproduce:*
>  # Set the logger level for org.apache.calcite.util.trace.getPlannerTracer to DEBUG.
>  # Run an existing test that uses FilterableTable.
> $ ./gradlew :example:csv:test --tests "org.apache.calcite.test.CsvTest.testFilterableWhere"
> *Actual Behavior:*
> Running the above steps results in an AssertionError exception, which states:
> {code:java}
> FAILURE   1.1sec, org.apache.calcite.test.CsvTest > testFilterableWhere()
>     java.lang.AssertionError: RelSubset [rel#42:RelSubset#2.ENUMERABLE.[]] has wrong best cost {130.0 rows, 246.0 cpu, 0.0 io}. Correct cost is {150.5 rows, 350.505 cpu, 0.0 io}
>         at org.apache.calcite.util.Litmus.lambda$static$0(Litmus.java:31)
>         at org.apache.calcite.plan.volcano.VolcanoPlanner.isValid(VolcanoPlanner.java:663)
>         at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:620)
>         at org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:144)
> {code}



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