[
https://issues.apache.org/jira/browse/ASTERIXDB-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17784624#comment-17784624
]
ASF subversion and git services commented on ASTERIXDB-3304:
------------------------------------------------------------
Commit b85429f33698ad0e35adfa8291d372f62473d885 in asterixdb's branch
refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=b85429f336 ]
[MULTIPLE ISSUES][COMP] Fix multiple pushdown issues
- user model changes: no
- storage format changes: no
- interface changes: yes
Details:
- ASTERIXDB-3304: Some fields are not projected
- ASTERIXDB-3305: ClassCastException in left outer joins
Change-Id: I826ec12d598ef9fc38ded47f6f29e28ed75a047b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17933
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Wail Alkowaileet <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> Column project-pushdown could miss some field accesses
> ------------------------------------------------------
>
> Key: ASTERIXDB-3304
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3304
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.9
> Reporter: Wail Y. Alkowaileet
> Assignee: Wail Y. Alkowaileet
> Priority: Major
> Fix For: 0.9.9
>
>
> DDL:
> {noformat}
> CREATE COLLECTION TestOpen1
> PRIMARY KEY (c_id:bigint)
> WITH {
> "storage-format": {"format": "column"}
> };
> CREATE COLLECTION TestOpen2
> PRIMARY KEY (c_id:bigint)
> WITH {
> "storage-format": {"format": "column"}
> };
> CREATE INDEX idx_t1_s ON TestOpen1(c_s:string);
> CREATE INDEX idx_t2_s ON TestOpen2(c_s:string);{noformat}
>
> DML:
> {noformat}
> INSERT INTO TestOpen1 ({
> "c_id": 1,
> "c_x": 1,
> "c_s": "hello",
> "c_i64": 2,
> "c_i8": 2,
> "c_d": 2
> });
> INSERT INTO TestOpen2 ({
> "c_id": 105,
> "c_x": 105,
> "c_s": "hello",
> "c_i64": 2.25,
> "c_i8": 10000.25,
> "c_d": 3.5
> }); {noformat}
>
> Query:
> {noformat}
> SELECT t1.c_x c1, t2.c_x c2
> FROM TestOpen1 t1, TestOpen2 t2
> WHERE to_string(t1.c_s) /*+ indexnl */ = t2.c_s
> ORDER BY t1.c_x, t2.c_x;{noformat}
> Field-access *t2.c_s* is not projected from TestOpen2 – making the query to
> return empty result
>
> Also, making any of the two datasets to be in row format throws
> NullPointerException
> Reported by [~peeyushgupta1]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
