Michael J. Carey created ASTERIXDB-1558:
-------------------------------------------

             Summary: 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: AsterixDB, Translator - AQL
            Reporter: Michael J. Carey
            Assignee: Yingyi Bu
            Priority: Minor


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.3.4#6332)

Reply via email to