[jira] [Created] (CALCITE-987) Push limit 0 through union will result in an infinite loop

[Pengcheng Xiong (JIRA)]

Pengcheng Xiong created CALCITE-987:
---------------------------------------

             Summary: Push limit 0 through union will result in an infinite loop
                 Key: CALCITE-987
                 URL: https://issues.apache.org/jira/browse/CALCITE-987
             Project: Calcite
          Issue Type: Bug
            Reporter: Pengcheng Xiong
            Assignee: Pengcheng Xiong


We use "checkInputForCollationAndLimit" in RelMdUtil.java to check the input 
#rows. However, it calls RelMetadataQuery.getRowCount which will validate the 
#rows. The validation will change #row=0 to #row=1. This will result in an 
infinite loop to push limit. The affected rules include 
SortUnionTransposeRule and any Sort***TransposeRules that call  
checkInputForCollationAndLimit.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)