[
https://issues.apache.org/jira/browse/ASTERIXDB-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Lychagin resolved ASTERIXDB-2302.
----------------------------------------
Resolution: Fixed
> 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
> Priority: Major
>
> 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)
