Wail Y. Alkowaileet created ASTERIXDB-3304:
----------------------------------------------
Summary: 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
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)
