[jira] [Created] (ASTERIXDB-3312) Query fails on standalone collection with composite nested primary key with column storage

["Wail Y. Alkowaileet (Jira)" <ji...@apache.org>]

Wail Y. Alkowaileet created ASTERIXDB-3312:
----------------------------------------------

             Summary: Query fails on standalone collection with composite nested primary key with column storage
                 Key: ASTERIXDB-3312
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3312
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: STO - Storage
    Affects Versions: 0.9.9
            Reporter: Wail Y. Alkowaileet
            Assignee: Wail Y. Alkowaileet
             Fix For: 0.9.9


Following are the set of statements to reproduce the issue.
{noformat}create collection users if not exists primary key (my_id: int, address.city:string, name.first: string, name.last:string) WITH {"storage-format": {"format": "column"}};

INSERT INTO users([
{"my_id": 1, "address":{"city": "C1"}, "name":{"first": "F1", "last": "L1"}},
{"my_id": 2, "address":{"city": "C2"}, "name":{"first": "F2", "last": "L1"}},
{"my_id": 3, "address":{"city": "C3"}, "name":{"first": "F1", "last": "L2"}}
]);

select address, name
from test.users d
where d.my_id=2
order by name.first;{noformat}
As reported by [~peeyushgupta1] 

The issue here is that the columnar LSM cursor will try to match the predicate with all the primary keys (PKs). However, as in the query above, the number of PKs are greater than the predicate (d.my_id = 2). Hence, we get IndexOutOfBoundException.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)