[TRAFODION-2071] [3rd party tool] Squirrel return wrong value for interval data

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: any
• Component/s: client-jdbc-t4
• Environment: Centos6.7 hbase1.0 CDH5.4.8
• Assignee: mashengchen
• Reporter: Gao, Rui-Xian
• Created: 17/Jun/16 09:49
• Updated: 28/Jul/16 06:20

Description

create table ht(h10s4 interval hour(10) to second(4)) no partition;
insert into ht values(-interval '1111111111:12:00.1234'hour(10) to second(4));

From trafci –
>>select * from ht;

H10S4
----------------------

-1111111111:12:00.1234

— 1 row(s) selected.

From Squirrel –
select will return <Other>
checking with content button, it shows <UnknownType (112)>