[ https://issues.apache.org/jira/browse/CALCITE-5013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17494955#comment-17494955 ]
Jiajun Xie commented on CALCITE-5013: ------------------------------------- Here is the pr:https://github.com/apache/calcite/pull/2724 > Parentheses should be retained 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 > Priority: Major > > - 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)