[
https://issues.apache.org/jira/browse/ASTERIXDB-3311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17787000#comment-17787000
]
ASF subversion and git services commented on ASTERIXDB-3311:
------------------------------------------------------------
Commit e9aed32bfb64bf0e6549ae7751660050399754de in asterixdb's branch
refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=e9aed32bfb ]
[MULTIPLE ISSUES][COMP][STO] Columnar compiler and cursor fixes
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Fixes both ASTERIXDB-3311 and ASTERIXDB-3312
Change-Id: I0415bf4876ffe0e5bc6b5fa4c60aee7f9f6afce2
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17956
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Wail Alkowaileet <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> Outer join query fails with column storage
> ------------------------------------------
>
> Key: ASTERIXDB-3311
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3311
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler, STO - Storage
> Affects Versions: 0.9.9
> Reporter: Wail Y. Alkowaileet
> Assignee: Wail Y. Alkowaileet
> Priority: Major
> Fix For: 0.9.9
>
>
> Following are the set of statements to reproduce the issue
> {noformat}create dataset ds1 primary key (id:int) WITH {"storage-format":
> {"format": "column"}};
> create dataset ds2 primary key (id:int) WITH {"storage-format": {"format":
> "column"}};
> insert into ds1 ({"id": 1, "a": 1, "b": 1 });
> insert into ds1 ({"id": 2, "a": 1, "b": 2 });
> insert into ds1 ({"id": 3, "a": 2, "b": 3 });
> insert into ds1 ({"id": 4, "a": 2, "b": 4 });
> insert into ds1 ({"id": 5, "a": 3, "b": 5 });
> insert into ds1 ({"id": 6, "a": 3, "b": 6 });
> insert into ds1 ({"id": 7, "a": 4, "b": 7 });
> insert into ds2 ({"id": 100, "x": 2, "y": 100 });
> insert into ds2 ({"id": 101, "x": 2, "y": 101 });
> insert into ds2 ({"id": 102, "x": 3, "y": 102 });
> create index idx_x on ds2(x:int);
> select ds1.b, ds2.y
> from ds1 left outer join ds2 on to_bigint(ds1.a) /* +indexnl */ = ds2.x
> order by ds1.b, ds2.y;{noformat}
> As reported by [~peeyushgupta1]
>
> There are two issues here:
> 1- The compiler doesn't push field accesses to left-outer-unnest-map leading
> to arrayCopy failing.
> 2- Columnar LSM cursors cannot read the same tuple twice. With index nested
> loop joins, this could happen. As a result, the tuple projector should return
> the previously assembled record without advancing the column readers.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
