[PHOENIX-2845] Timestamp ignores nanos in literal expressions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.7.0
• Fix Version/s: 4.8.0
• Assignee: Sergey Soldatov
• Reporter: Sergey Soldatov
• Created: 21/Apr/16 00:33
• Updated: 11/Aug/16 08:28
• Resolved: 05/May/16 06:18

Description

Phoenix strips nanos in Timestamp. Simple test case:

create table x (id bigint primary key, t timestamp);
upsert into x values (1, TIMESTAMP'2015-01-01 00:00:00.123456');
upsert into x values (2, TIMESTAMP'2015-01-01 00:00:00.123457');
upsert into x values (3, TIMESTAMP'2015-01-01 00:00:00.123999');

HBase scan:

hbase(main):007:0> scan 'X'
ROW COLUMN+CELL
 \x80\x00\x00\x00\x00\x00\x00\x01 column=0:T, timestamp=1460646668779, value=\x80\x00\x01J\xA2\xCA\xB0{\x00\x00\x00\x00
 \x80\x00\x00\x00\x00\x00\x00\x02 column=0:T, timestamp=1460646673369, value=\x80\x00\x01J\xA2\xCA\xB0{\x00\x00\x00\x00
 \x80\x00\x00\x00\x00\x00\x00\x03 column=0:T, timestamp=1460646680294, value=\x80\x00\x01J\xA2\xCA\xB0{\x00\x00\x00\x00

Issue Links

• breaks: PHOENIX-2962 Compilation issue on 4.x-HBase-1.1