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