[ https://issues.apache.org/jira/browse/ASTERIXDB-2371?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16455477#comment-16455477 ]
ASF subversion and git services commented on ASTERIXDB-2371: ------------------------------------------------------------ Commit b25c15f758308c50c387786b368ce6808484bcb6 in asterixdb's branch refs/heads/master from [~dlychagin-cb] [ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=b25c15f ] [ASTERIXDB-2371][FUN] Implement conditional functions - user model changes: yes - storage format changes: no - interface changes: no Details: - Implement the following conditional functions: null_if(), missing_if(), nan_if(), posinf_if(), neginf_if() Change-Id: I5399cae1a225b1881d67b87541e46a9d4fe158ec Reviewed-on: https://asterix-gerrit.ics.uci.edu/2616 Sonar-Qube: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Reviewed-by: Till Westmann <ti...@apache.org> > 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 > Priority: Minor > > 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)