Phoenix wrong range query result

Hi guys,

I have one big problem with Phoenix is some time, range query like: >, <, <=, >= return missing one or more result,

>>> REPROCEDURE ERROR CASE:
CREATE TABLE IF NOT EXISTS device3 (id CHAR(50) NOT NULL PRIMARY KEY, manufacture CHAR(50), brand CHAR(50), model CHAR(50), os CHAR(50), os_version CHAR(50), resolution CHAR(50), language CHAR(50), carrier CHAR(50), country CHAR(50), day_time INTEGER, time INTEGER, hour_time INTEGER, status INTEGER);

UPSERT INTO device3(id, hour_time, day_time) values ('1',1403974800,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('2',1403978400,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('3',1403982000,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('4',1403985600,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('5',1403989200,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('6',1403992800,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('7',1403996400,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('8',1404000000,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('9',1404003600,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('10',1404007200,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('11',1404010800,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('12',1404014400,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('13',1404018000,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('14',1404021600,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('15',1404025200,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('16',1404028800,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('17',1404032400,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('18',1404036000,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('19',1404039600,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('20',1404043200,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('21',1404046800,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('22',1404050400,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('23',1404054000,1403974800);
UPSERT INTO device3(id, hour_time, day_time) values ('24',1404057600,1403974800);

SELECT count(1) AS total, hour_time FROM device3 where hour_time >=1403974800 and hour_time < 1404061199 GROUP BY hour_time ORDER BY hour_time
----------------------+

----------------------+

----------------------+

select distinct hour_time from device3 where day_time = 1403974800 order by hour_time;
------------

------------

------------

SELECT count(1) AS total, hour_time FROM device3 where day_time =1403974800 GROUP BY hour_time ORDER BY hour_time
----------------------+

----------------------+

----------------------+

Before create index, everything is OK!
CREATE INDEX IDX_DEVICE3_HOUR_TIME ON device3 (hour_time DESC);
CREATE INDEX IDX_DEVICE3_DAY_TIME ON device3 (day_time DESC);

Here is very strange order in IDX_DEVICE3_HOUR_TIME index, queries return missing value after create index!
select * from IDX_DEVICE3_HOUR_TIME;
-----------------------------------------------------+

-----------------------------------------------------+

-----------------------------------------------------+

WRONG QUERY RESULT HERE ! (Missing 1404000000 value)
SELECT count(1) AS total, hour_time FROM device3 where hour_time >=1403974800 and hour_time < 1404061199 GROUP BY hour_time ORDER BY hour_time;
----------------------+

----------------------+

----------------------+

This kind of bug resolved in a lot of topic, i don't understand why it still apper:
http://mail-archives.apache.org/mod_mbox/phoenix-dev/201403.mbox/%3CJIRA.12700068.1394495218035.81228.1394954374732@arcas%3E
https://groups.google.com/forum/#!topic/phoenix-hbase-user/mZxSFxpqjS4
http://mail-archives.apache.org/mod_mbox/phoenix-user/201404.mbox/%3C1398727966.67421.YahooMailNeo@web165003.mail.bf1.yahoo.com%3E