[
https://issues.apache.org/jira/browse/ASTERIXDB-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15401368#comment-15401368
]
Yingyi Bu commented on ASTERIXDB-1558:
--------------------------------------
[~dtabass], the first query result is as expected:
According to the third table at
https://cwiki.apache.org/confluence/display/ASTERIXDB/Missing+Information+in+Data+Model,
MISSING IS NULL should return MISSING, however, in the final result
serialization, a scalar MISSING or a MISSING in an array is serialized as
"null" (because JSON only has null...).
Therefore, [ 'a', 'b', NULL,'c' ][5] IS NULL should have its result to be
"null" -- which is actually MISSING. The second query looks to be a bug. I'll
take a look.
Best,
Yingyi
> 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)
