[ https://issues.apache.org/jira/browse/ASTERIXDB-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yingyi Bu reassigned ASTERIXDB-1558: ------------------------------------ Assignee: Dmitry Lychagin (was: Yingyi Bu) > Possible minor glitch in UNKNOWN value related predicates/handling > ------------------------------------------------------------------ > > Key: ASTERIXDB-1558 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-1558 > Project: Apache AsterixDB > Issue Type: Bug > Components: *DB - AsterixDB, AQL - Translator AQL > Reporter: Michael J. Carey > Assignee: Dmitry Lychagin > Priority: Minor > Labels: soon > > The following evaluates to TRUE: > { > 'project': 'AsterixDB', > 'members': [ 'vinayakb', 'dtabass', 'chenli', 'tsotras' ] > }.member IS MISSING; > As, desirably, does: > { > 'project': 'AsterixDB', > 'members': [ 'vinayakb', 'dtabass', 'chenli', 'tsotras' ] > }.member IS UNKNOWN; > But the following evaluates to NULL (and it seems to me that FALSE would be > the proper expected result): > { > 'project': 'AsterixDB', > 'members': [ 'vinayakb', 'dtabass', 'chenli', 'tsotras' ] > }.member IS NULL; > Of course, I could be MISSING something here, as a SQL++ newbie.... -- This message was sent by Atlassian JIRA (v6.4.14#64029)