You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@asterixdb.apache.org by "Dmitry Lychagin (JIRA)" <ji...@apache.org> on 2018/04/24 23:44:00 UTC

[jira] [Created] (ASTERIXDB-2371) Implement null-related functions

Dmitry Lychagin created ASTERIXDB-2371:
------------------------------------------

             Summary: Implement null-related functions
                 Key: ASTERIXDB-2371
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2371
             Project: Apache AsterixDB
          Issue Type: Improvement
          Components: FUN - Functions
            Reporter: Dmitry Lychagin
            Assignee: Dmitry Lychagin


Implement null-related functions: MISSINGIF, NULLIF, NANIF, NEGINFIF, POSINFIF

they accept two arguments

1) if any argument is MISSING then result is MISSING
2) if any argument is NULL then result is NULL
3) if arg1 == arg2 then result MISSING/NULL/NaN/-INF/+INF (corresponding to the function name)
4) otherwise the result is arg1



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)