[CALCITE-2625] ROW_NUMBER, RANK generating Invalid SQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Component/s: jdbc-adapter
• Labels: pull-request-available
• Assignee: Julian Hyde
• Reporter: KrishnaKant Agrawal
• Created: 12/Oct/18 08:51
• Updated: 25/Mar/19 00:11
• Resolved: 04/Jan/19 13:58

Description

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.

Issue Links

• links to: PR#889