[jira] [Updated] (ASTERIXDB-3492) Not evaluating next tuple in case of skip while column filtering

["Ian Maxon (Jira)" <ji...@apache.org>]

     [ 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)