[ https://issues.apache.org/jira/browse/TRAFODION-343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-343. ------------------------------------ > LP Bug: 1325716 - TIME(1) default CURRENT_TIME reported wrong values > -------------------------------------------------------------------- > > Key: TRAFODION-343 > URL: https://issues.apache.org/jira/browse/TRAFODION-343 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Reporter: Apache Trafodion > Assignee: liu ming > Priority: Critical > Fix For: 1.0 (pre-incubation) > > > expected default CURRENT_TIME ti01 returned -34.07.06. > not as expected 19:55:28.6 > SQL>create table a05table ( > int1 integer no default not null > , vch2 CHAR VARYING(8) > , dt00 DATE > , tidf TIME default CURRENT_TIME > , tsdf TIMESTAMP(0) default CURRENT_TIMESTAMP > , dt01 DATE default CURRENT_DATE > , ti01 TIME(1) default CURRENT_TIME > , ts01 TIMESTAMP(1) default CURRENT_TIMESTAMP > , primary key (int1 asc) not droppable > ) > store by primary key > ; > --- SQL operation complete. > SQL>insert into a05table (int1, vch2) values (1,'row_1'); > --- 1 row(s) inserted. > SQL>insert into a05table (int1, tsdf ) values > (13, timestamp '1997-01-31:13:13:13'); > --- 1 row(s) inserted. > SQL>select * from a05table order by int1; > INT1 VCH2 DT00 TIDF TSDF DT01 TI01 > TS01 > ----------- -------- ---------- -------- ------------------- ---------- > ---------- --------------------- > 1 row_1 NULL 19:55:27 2014-06-02 19:55:27 2014-06-02 > -34:07:06. 2014-06-02 19:55:27.6 > 13 NULL NULL 19:55:28 1997-01-31 13:13:13 2014-06-02 > 19:55:28.6 2014-06-02 19:55:28.6 > --- 2 row(s) selected. > SQL>select int1, dt01, ti01, ts01 from a05table order by int1; > INT1 DT01 TI01 TS01 > ----------- ---------- ---------- --------------------- > 1 2014-06-02 -34:07:06. 2014-06-02 19:55:27.6 > 13 2014-06-02 19:55:28.6 2014-06-02 19:55:28.6 > --- 2 row(s) selected. > SQL>insert into a05table (int1, dt01) values > (20, date '2005-03-31'); > --- 1 row(s) inserted. > SQL>select int1, dt01, ti01, ts01 from a05table order by int1; > INT1 DT01 TI01 TS01 > ----------- ---------- ---------- --------------------- > 1 2014-06-02 -34:07:06. 2014-06-02 19:55:27.6 > 13 2014-06-02 19:55:28.6 2014-06-02 19:55:28.6 > 20 2005-03-31 -34:07:06. 2014-06-02 19:55:28.6 > --- 3 row(s) selected. > SQL>exit; > -- test script > log a09log clear; > drop schema debug_addt105 cascade; > create schema debug_addt105; > set schema debug_addt105; > drop table a05table; > -- table start with 2 fixed length field > create table a05table ( > int1 integer no default not null > , vch2 CHAR VARYING(8) > , dt00 DATE > , tidf TIME default CURRENT_TIME > , tsdf TIMESTAMP(0) default CURRENT_TIMESTAMP > , dt01 DATE default CURRENT_DATE > , ti01 TIME(1) default CURRENT_TIME > , ts01 TIMESTAMP(1) default CURRENT_TIMESTAMP > , primary key (int1 asc) not droppable > ) > store by primary key > ; > insert into a05table (int1, vch2) values (1,'row_1'); > insert into a05table (int1, tsdf ) values > (13, timestamp '1997-01-31:13:13:13'); > select * from a05table order by int1; > select int1, dt01, ti01, ts01 from a05table order by int1; > insert into a05table (int1, dt01) values > (20, date '2005-03-31'); > select int1, dt01, ti01, ts01 from a05table order by int1; > exit; > > GIT 0530 build. Also failed on 0601 build. > Assigned to LaunchPad User James Capps -- This message was sent by Atlassian JIRA (v6.3.4#6332)