[PHOENIX-2137] Range query on DECIMAL DESC sometimes incorrect

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.5.1
• Assignee: James R. Taylor
• Reporter: James R. Taylor
• Created: 22/Jul/15 17:44
• Updated: 21/Nov/15 02:17
• Resolved: 13/Aug/15 06:02

Description

The following scenario is not working correctly:

create table t (k1 bigint not null, k2 decimal, constraint pk primary key (k1,k2 desc));
upsert into t values(1,1.01);
upsert into t values(2,1.001);
select * from t where k2>1.0; -- No rows, but should be both rows
select * from t where k1 in (1,2) and k2>1.0; -- Same problem

The following queries do return the correct results:

select * from t where k2>1.0001;
select * from t where k1 in (1,2) and k2>1.0001;

Note also that without the DESC declaration of k2, everything works fine.