[
https://issues.apache.org/jira/browse/ASTERIXDB-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon reassigned ASTERIXDB-3510:
------------------------------------
Assignee: Peeyush Gupta
> 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
>
> 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)
