You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org> on 2015/09/09 22:47:46 UTC
[jira] [Updated] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option
for LEAD, LAG window functions
[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Hsuan-Yi Chu updated CALCITE-883:
--------------------------------------
Description:
This issue was brought up in Drill community: (https://issues.apache.org/jira/browse/DRILL-3597)
For convenience, I copied and pasted the reporter Khurram Faraaz's description here:
"The SQL standard defines a RESPECT NULLS or IGNORE NULLS option for lead, lag, first_value, and last_value window functions."
In Calcite, we should have been able to recognized this option.
was:
This issue was brought up in Drill community: (https://issues.apache.org/jira/browse/DRILL-3597)
For convenience, I copied and pasted the reporter Khurram Faraaz's description here:
The SQL standard defines a RESPECT NULLS or IGNORE NULLS option for lead, lag, first_value, and last_value window functions.
In Calcite, we should have been able to recognized this option.
> RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions
> -----------------------------------------------------------------
>
> Key: CALCITE-883
> URL: https://issues.apache.org/jira/browse/CALCITE-883
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Sean Hsuan-Yi Chu
>
> This issue was brought up in Drill community: (https://issues.apache.org/jira/browse/DRILL-3597)
> For convenience, I copied and pasted the reporter Khurram Faraaz's description here:
> "The SQL standard defines a RESPECT NULLS or IGNORE NULLS option for lead, lag, first_value, and last_value window functions."
> In Calcite, we should have been able to recognized this option.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)