[ https://issues.apache.org/jira/browse/CALCITE-2625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16648569#comment-16648569 ]
Julian Hyde commented on CALCITE-2625: -------------------------------------- I agree. Note that we already have {{boolean SqlOperator.allowsFraming()}}. We just need to use it when generating SQL. Can you change the Jira case title to something more specific, e.g. about RANK generating invalid SQL. > Function Specific Sql Window Unparsing where Framing Not Allowed > ---------------------------------------------------------------- > > Key: CALCITE-2625 > URL: https://issues.apache.org/jira/browse/CALCITE-2625 > Project: Calcite > Issue Type: Bug > Components: core > Reporter: KrishnaKant Agrawal > Assignee: Julian Hyde > Priority: Major > > The SQL standard says:- > If <ntile function>, <lead or lag function>, <rank function type> or > ROW_NUMBER is specified, then: … The window framing clause of WDX shall not > be present. > So, Calcite should not print the Window Frames when such functions are used. -- This message was sent by Atlassian JIRA (v7.6.3#76005)