Qiulin Li created CALCITE-4537:
----------------------------------

             Summary: The pos property will drop consecutive parentheses 
                 Key: CALCITE-4537
                 URL: https://issues.apache.org/jira/browse/CALCITE-4537
             Project: Calcite
          Issue Type: Bug
            Reporter: Qiulin Li


The pos property will drop one parenthesis if there are consecutive parentheses.

For example, with the query below, the parenthesis marked red won't be included 
in the subquery information.

 

SELECT * from

(SELECT drinker FROM frequents

UNION ALL

   (SELECT name FROM drinker WHERE drinker.name > 'A' 

    EXCEPT ALL 

    SELECT name FROM drinker WHERE drinker.name = 'Amy'{color:#de350b}){color}) 
as A;



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to