[
https://issues.apache.org/jira/browse/ASTERIXDB-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17887968#comment-17887968
]
ASF subversion and git services commented on ASTERIXDB-3510:
------------------------------------------------------------
Commit e602a40b0a7f6b3e6f67e3f29c95721deeda266b in asterixdb's branch
refs/heads/master from Peeyush Gupta
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=e602a40b0a ]
[ASTERIXDB-3510][COMP] Incorrectly removing expressions from AND clause in
column filters
- user model changes: no
- storage format changes: no
- interface changes: yes
Details:
While creating columnar filters we were removing expression from AND clause if
they can not
be pushed down. However, this is not correct if AND is not at the root e.g., in
case of
NOT(expr1 AND expr2 AND expr3) where expr3 can not be pushed down, we can not
create a column
filter by just removing expr3 from the AND clause i.e., NOT(expr1 AND expr2)
and checking it later.
Ext-ref: MB-63602
Change-Id: I797acdbb90bd28bbe2a07f654ca6f15f835db0d7
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18909
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> Incorrect results for query with column based collections
> ---------------------------------------------------------
>
> Key: ASTERIXDB-3510
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3510
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Peeyush Gupta
> Assignee: Peeyush Gupta
> Priority: Major
> Labels: triaged
>
> Following are the steps to reproduce the issue
> {code:java}
> DROP DATAVERSE test IF EXISTS;
> CREATE DATAVERSE test;
> USE test;
> CREATE DATASET simple_table PRIMARY KEY (primary_key_id:string) WITH {
> "storage-format" : {"format" : "column"}
> };{code}
> {code:java}
> UPSERT INTO simple_table ([{"primary_key_id":"1", "int_value":10}]);{code}
> {code:java}
> SELECT * FROM simple_table WHERE NOT ((primary_key_id is NULL AND int_value
> =10))
> {code}
> The above query returns 0 rows but should return 1 row
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
