Vladimir Sitnikov created OPTIQ-337:
---------------------------------------
Summary: Support IGNORE NULLS in window aggregates
Key: OPTIQ-337
URL: https://issues.apache.org/jira/browse/OPTIQ-337
Project: Optiq
Issue Type: Improvement
Reporter: Vladimir Sitnikov
Assignee: Julian Hyde
Some of the functions are a bit more useful when they support IGNORE/RESPECT
NULLS clause.
For instance, FIRST_VALUE, LAST_VALUE, LEAD, LAG run in RESPECT NULLS by
default. In IGNORE NULLS mode FIRST_VALUE calculates first not null value in
the partiton.
[Ignore nulls behaviour can be
simulated|http://rwijk.blogspot.ru/2010/06/simulating-laglead-ignore-nulls.html]
however it makes sense to support it.
Here's Oracle DB documentation on the subject:
http://docs.oracle.com/cd/E16655_01/server.121/e17209/functions073.htm
--
This message was sent by Atlassian JIRA
(v6.2#6252)
