[
https://issues.apache.org/jira/browse/ASTERIXDB-2307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin resolved ASTERIXDB-2307.
----------------------------------------
Resolution: Fixed
> Incorrect result of quantified expression when condition returns NULL/MISSING
> -----------------------------------------------------------------------------
>
> Key: ASTERIXDB-2307
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2307
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Dmitry Lychagin
> Assignee: Dmitry Lychagin
> Priority: Minor
>
> Input data:
> { "custid": "C1",
> "name": "James",
> "rating": 750
> },
> { "custid": "C2",
> "name": "Mary",
> "rating": 690
> },
> { "custid": "C3",
> "name": "John"
> },
> { "custid": "C4",
> "name": "Patricia",
> "rating": null
> },
> { "custid": "C5",
> "name": "Robert",
> "rating": 750
> },
> { "custid": "C6",
> "name": "Jennifer",
> "rating": 640
> }
>
> Query:
> SELECT VALUE COUNT(c1.name)
> FROM customers AS c1
> WHERE EVERY r IN
> (SELECT VALUE c2.rating FROM customers AS c2)
> SATISFIES c1.rating >= r
> Result: 4, which is incorrect because for some customers the 'rating' field
> is either missing or null, therefore the quantified expression can never
> succeed. The correct result should be 0
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
