[ASTERIXDB-2372] Providing a float value predicate to an integer primary index does not work as expected.

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.9.4
• Fix Version/s: 0.9.4.2
• Assignee: Dmitry Lychagin
• Reporter: Taewoo Kim
• Created: 26/Apr/18 05:53
• Updated: 10/Apr/19 18:26

Description

If we have an integer primary index and feed a float value predicate that is not an integer such as 1.3, the search result is not correct.

 

The DDL and DML

drop dataverse test if exists;
create dataverse test;
use test;

create type MyRecord as closed {
  id: int64
};

create dataset MyData(MyRecord) primary key id;

insert into MyData({"id":1});
insert into MyData({"id":2});

select * from MyData where id = 1.3;

 

The result should be empty. But, it returns 1 and 2 as the result.