You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/12 19:40:05 UTC
[jira] [Closed] (TRAFODION-343) LP Bug: 1325716 - TIME(1) default
CURRENT_TIME reported wrong values
[ 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)