You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Jiajun Xie (Jira)" <ji...@apache.org> on 2022/02/19 10:14:00 UTC

[jira] [Created] (CALCITE-5013) Parentheses should be reserved when the operand of SetOp has limit or offset

Jiajun Xie created CALCITE-5013:
-----------------------------------

             Summary: Parentheses should be reserved when the operand of SetOp has limit or offset
                 Key: CALCITE-5013
                 URL: https://issues.apache.org/jira/browse/CALCITE-5013
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Jiajun Xie


- In standard SQL, the operand of union should not have limit  or order by.So parse will fail in SqlParserTetest#testLimitUnion and SqlParserTetest#OrderUnion.

 - When users use parentheses, most engines allow it. See the discussion:[CALCITE-1892|https://issues.apache.org/jira/browse/CALCITE-1892].   



--
This message was sent by Atlassian Jira
(v8.20.1#820001)