[
https://issues.apache.org/jira/browse/ASTERIXDB-3264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wail Y. Alkowaileet resolved ASTERIXDB-3264.
--------------------------------------------
Resolution: Fixed
> Columnar range-filter doesn't correctly evaluate equality if a constant is
> the left operand
> -------------------------------------------------------------------------------------------
>
> Key: ASTERIXDB-3264
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3264
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.9
> Reporter: Wail Y. Alkowaileet
> Assignee: Wail Y. Alkowaileet
> Priority: Major
> Fix For: 0.9.9
>
>
> Range-filter doesn't correctly translate EQ in columnar range-filter if the
> left operand is a constant:
> {noformat}SELECT VALUE C.dates
> FROM YelpCheckin C
> WHERE "-0y3MZU2oYP8r1ruDP1bfQ" = C.business_id; {noformat}
>
> The output filter:
> {noformat}Filter: "-0y3MZU2oYP8r1ruDP1bfQ" > min($$root.business_id)
> {noformat}
> This is incorrect. The correct filter should be:
> {noformat}Filter: "-0y3MZU2oYP8r1ruDP1bfQ" >= min($$root.business_id) &&
> "-0y3MZU2oYP8r1ruDP1bfQ" <= max($$root.business_id) {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
