2.1.2.252 T616, Null treatment option for LEAD and LAG functions

V0288:

The specification states the following:

 Subclause 6.10, "<window function>":
  
 <lead or lag function> ::=
 <lead or lag> <left paren> <lead or lag extent>
 [ <comma> <offset> [ <comma> <default expression> ] ] <right paren>
 [ <null treatment> ]
  
 <lead or lag> ::=
 LEAD | LAG
  
 <lead or lag extent> ::=
 <value expression>
  
 ...
  
 <null treatment> ::=
 RESPECT NULLS | IGNORE NULLS
  
 ...
  
 Conformance Rules:
  
 Without Feature T616, "Null treatment option for LEAD and LAG functions", in conforming SQL language, <lead or lag function> shall not contain <null treatment>.

Microsoft SQL Server 2008 R2 varies as follows:

This feature is absent from the [ISO/IEC9075-2:2008] standard.

Microsoft SQL Server 2012 varies as follows:

Transact-SQL does not support this feature.