[
https://issues.apache.org/jira/browse/ASTERIXDB-3264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17766523#comment-17766523
]
ASF subversion and git services commented on ASTERIXDB-3264:
------------------------------------------------------------
Commit 6d9275b51a443ec42a5a907dc3f65dd94be3541b in asterixdb's branch
refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=6d9275b51a ]
[ASTERIXDB-3262][COMP] Enable columnar filters by default
- user model changes: yes
- storage format changes: no
- interface changes: no
Details:
Make the use of columnar filters enabled by default.
- Fix ASTERIXDB-3265: The array filter reader has
its delimiters reversed
- Fix ASTERIXDB-3264: Columnar range-filter doesn't correctly
evaluate equality if a constant is the left operand
Change-Id: I9306db62ff0e991efed30346a8847b9edae9393e
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17781
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Wail Alkowaileet <[email protected]>
Reviewed-by: Hussain Towaileb <[email protected]>
> 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)
