[ https://issues.apache.org/jira/browse/CALCITE-5286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ruben Q L resolved CALCITE-5286. -------------------------------- Resolution: Fixed Done in https://github.com/apache/calcite/commit/3a38ebf40f6dfc1170ba3d3acc5d8e1f234ed45c Thanks [~kramerul] for reporting the issue and [~jiajunbernoulli] for the PR! > Join with parameterized LIMIT throws AssertionError "not a literal" > ------------------------------------------------------------------- > > Key: CALCITE-5286 > URL: https://issues.apache.org/jira/browse/CALCITE-5286 > Project: Calcite > Issue Type: Bug > Reporter: Ulrich Kramer > Assignee: Jiajun Xie > Priority: Major > Labels: pull-request-available > Fix For: 1.33.0 > > Time Spent: 20m > Remaining Estimate: 0h > > A query like the following one > {code:java} > select T."name", T."valueLeverId", T."type", T."ID", T."parentId" > from ( > SELECT VD."id" as ID, VD."name", VD."typeId", VD."type", VD."valueLeverId", > VD."valueLever", VD."parentId", VDtoSC."VDtoSC_List" > FROM VD > LEFT JOIN VDtoSC > ON VD."id" = VDtoSC."Value_Driver_ID" > ) AS T > where T."ID" = ? limit ? > {code} > fails with > {code:java} > findValue:1208, RexLiteral (org.apache.calcite.rex) > intValue:1183, RexLiteral (org.apache.calcite.rex) > getMaxRowCount:207, RelMdMaxRowCount (org.apache.calcite.rel.metadata) > getMaxRowCount_$:-1, GeneratedMetadata_MaxRowCountHandler > (org.apache.calcite.rel.metadata.janino) > getMaxRowCount:-1, GeneratedMetadata_MaxRowCountHandler > (org.apache.calcite.rel.metadata.janino) > getMaxRowCount:277, RelMetadataQuery (org.apache.calcite.rel.metadata) > alreadySmaller:914, RelMdUtil (org.apache.calcite.rel.metadata) > checkInputForCollationAndLimit:887, RelMdUtil > (org.apache.calcite.rel.metadata) > onMatch:138, SortJoinTransposeRule (org.apache.calcite.rel.rules) > onMatch:223, VolcanoRuleCall (org.apache.calcite.plan.volcano) > drive:59, IterativeRuleDriver (org.apache.calcite.plan.volcano) > findBestExp:523, VolcanoPlanner (org.apache.calcite.plan.volcano) > lambda$standard$3:276, Programs (org.apache.calcite.tools) > run:-1, Programs$$Lambda$2787/0x000000080121f9c0 (org.apache.calcite.tools) > run:336, Programs$SequenceProgram (org.apache.calcite.tools) > transform:373, PlannerImpl (org.apache.calcite.prepare) > {code} > The 2 tables are located in a schema where joins can't be pushed down. > See also CALCITE-5048 -- > CALCITE-2061 > -- This message was sent by Atlassian Jira (v8.20.10#820010)