Peeyush Gupta created ASTERIXDB-3510:
----------------------------------------
Summary: 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
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 > 2 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)
