[
https://issues.apache.org/jira/browse/OPTIQ-337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14053380#comment-14053380
]
Vladimir Sitnikov commented on OPTIQ-337:
-----------------------------------------
I am not sure if {{IGNORE/RESPECT NULLS}} should be available for all
aggregates (similar to {{isCountStar}}).
I am not sure if {{SqlOperator.supportsIgnoreNull}} should be added to allow
validation of the improper usage of the clause.
I guess this might be a good starter issue.
> 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)
