[DRILL-3596] Allow only (<expression>) or (<expression>, 1) for LEAD and LAG window functions as input parameters

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: Execution - Relational Operators
• Labels: window_function
• Assignee: Abdel Hakim Deneche
• Reporter: Khurram Faraaz
• Created: 03/Aug/15 23:32
• Updated: 24/Jan/23 18:53
• Resolved: 27/Sep/15 19:22

Description

We need to disable the third input parameter in LEAD and LAG window functions. We should support this syntax.

LEAD(<expression>) ,or LEAD(<expression>,1)
LAG(<expression>), or LAG(<expression>,1)

In both the functions above, the second parameter is the default offset value, use of any other value must he handled and reported to user as error.

Use of a third input parameter to both the functions must be disallowed.