Wail Y. Alkowaileet created ASTERIXDB-3264:
----------------------------------------------
Summary: 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
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)
