[CALCITE-5286] Join with parameterized LIMIT throws AssertionError "not a literal"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.33.0
• Labels: pull-request-available
• Assignee: Jiajun Xie
• Reporter: Ulrich Kramer
• Created: 13/Sep/22 12:58
• Updated: 07/Feb/23 22:33
• Resolved: 03/Oct/22 09:33

Description

A query like the following one

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 ?

fails with

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)

The 2 tables are located in a schema where joins can't be pushed down.

See also CALCITE-5048  --

CALCITE-2061

 

Issue Links

• relates to: CALCITE-5048 Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"
• relates to: CALCITE-2061 Dynamic parameters in OFFSET, FETCH and LIMIT clauses
• links to: GitHub Pull Request #2921