Dmitry Lychagin created ASTERIXDB-2302:
------------------------------------------
Summary: Incorrect result with non-enforced secondary index
Key: ASTERIXDB-2302
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2302
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Reporter: Dmitry Lychagin
Assignee: Dmitry Lychagin
Incorrect result for query that uses non-enforced secondary index when that
index is created as integer type while the data is of double type
create index idx_i64_on_d on TestOpen(c_d:int64);
c_d is an open field in the TestOpen dataset which contains double values.
Query:
select ...
from TestOpen
where c_d = 3.25
The secondary index gets chosen by the query optimizer, but the plan is
incorrect because it does not convert the probe value (3.25) to an integer
value.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
