[
https://issues.apache.org/jira/browse/ASTERIXDB-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wail Y. Alkowaileet updated ASTERIXDB-3304:
-------------------------------------------
Epic Link: ASTERIXDB-3002
> 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)
