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:45 UTC

[jira] [Created] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

Sean Hsuan-Yi Chu created CALCITE-883:
-----------------------------------------

             Summary: 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)