[
https://issues.apache.org/jira/browse/ASTERIXDB-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17885607#comment-17885607
]
Peeyush Gupta commented on ASTERIXDB-3510:
------------------------------------------
Updated the description
> 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)
