[
https://issues.apache.org/jira/browse/ASTERIXDB-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16378067#comment-16378067
]
ASF subversion and git services commented on ASTERIXDB-2302:
------------------------------------------------------------
Commit b8bf7aa92786127a97d049a764ff76c28a92d94e in asterixdb's branch
refs/heads/master from [~dlychagin-cb]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=b8bf7aa ]
[ASTERIXDB-2302][COMP] Incorrect result with non-enforced index
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
- Incorrect result returned when a non-enforced index is created
as integer type, but probed with double value
Change-Id: I236c4c92d82bc3292193b2eb0f9b771042b3ca1a
Reviewed-on: https://asterix-gerrit.ics.uci.edu/2425
Sonar-Qube: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Reviewed-by: Taewoo Kim <wangs...@gmail.com>
> 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)
