Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
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 --
Attachments
Issue Links
- relates to
-
CALCITE-5048 Query with parameterized LIMIT and correlated sub-query throws AssertionError "not a literal"
- Closed
-
CALCITE-2061 Dynamic parameters in OFFSET, FETCH and LIMIT clauses
- Closed
- links to