[
https://issues.apache.org/jira/browse/ASTERIXDB-3492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3492:
---------------------------------
Labels: triaged (was: )
> Not evaluating next tuple in case of skip while column filtering
> ----------------------------------------------------------------
>
> Key: ASTERIXDB-3492
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3492
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: STO - Storage
> Affects Versions: 0.9.10
> Reporter: Ritik Raj
> Assignee: Ritik Raj
> Priority: Critical
> Labels: triaged
> Fix For: 0.9.10
>
>
> We are not evaluating the next tuple in case of skipping a tuple while column
> filtering, leading to inaccurate results.
> Test Case:
> {code:java}
> DROP DATAVERSE test IF EXISTS;
> CREATE DATAVERSE test;
> USE test;
> CREATE DATASET ColumnDataset
> PRIMARY KEY (uid:int) WITH {
> "storage-format": {"format": "column"}
> };
> {code}
> {code:java}
> USE test;
> UPSERT INTO ColumnDataset(
> {"uid": 1, "a": [{"x": "aaaaaaaaaazzzz"}, {"x": "aaaaaaaaaaabzzzz"},
> {"x": "aaaaaaaaaaaaabzzzzzzzz"}]},
> {"uid": 2, "a": [{"x": "aaaaaaaaaazzzz"}, {"x": "aaaaaaaaaaabzzzz"},
> {"x": "aaaaaaaaaaaaabzzzzzzzz"}]}
> );
> {code}
> {code:java}
> USE test;
> DELETE FROM ColumnDataset WHERE uid = 1;{code}
>
> {code:java}
> USE test;
> SELECT VALUE a.x
> FROM ColumnDataset c, c.a a
> WHERE a.x = "aaaaaaaaaaaaabzzzzzzzz"; {code}
>
> gives no result, but should give one output.
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
