Gao, Rui-Xian created TRAFODION-2071:
----------------------------------------

             Summary: [3rd party tool] Squirrel return wrong value for interval 
data
                 Key: TRAFODION-2071
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2071
             Project: Apache Trafodion
          Issue Type: Bug
          Components: client-jdbc-t4
    Affects Versions: any
         Environment: Centos6.7 hbase1.0 CDH5.4.8
            Reporter: Gao, Rui-Xian
            Assignee: Kevin Xu


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)>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to