asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yingyi Bu (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (ASTERIXDB-1558) Possible minor glitch in UNKNOWN value related predicates/handling
Date Sun, 31 Jul 2016 22:07:20 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15401368#comment-15401368
] 

Yingyi Bu edited comment on ASTERIXDB-1558 at 7/31/16 10:07 PM:
----------------------------------------------------------------

[~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 last query looks to be a bug. I'll take a look.

Best,
Yingyi


was (Author: buyingyi):
[~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)

Mime
View raw message