You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Selvaganesan Govindarajan (JIRA)" <ji...@apache.org> on 2016/03/01 19:14:18 UTC
[jira] [Resolved] (TRAFODION-1847) Upsert with omitted timestamp
columns having current_timestamp as default in a non-aligned format table
returns wrong value for this column
[ https://issues.apache.org/jira/browse/TRAFODION-1847?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Selvaganesan Govindarajan resolved TRAFODION-1847.
--------------------------------------------------
Resolution: Fixed
See https://github.com/apache/incubator-trafodion/pull/340 for details
> Upsert with omitted timestamp columns having current_timestamp as default in a non-aligned format table returns wrong value for this column
> -------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1847
> URL: https://issues.apache.org/jira/browse/TRAFODION-1847
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp, sql-exe
> Affects Versions: 1.3-incubating
> Reporter: Selvaganesan Govindarajan
> Assignee: Selvaganesan Govindarajan
> Fix For: 2.0-incubating
>
>
> >>CREATE TABLE TRAFODION.SCH.HF_BUG
> (
> A LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
> SERIALIZED
> , B CHAR(10) CHARACTER SET ISO88591 COLLATE
> DEFAULT DEFAULT NULL SERIALIZED
> , C TIMESTAMP(6) DEFAULT CURRENT NOT
> SERIALIZED
> , D INT DEFAULT NULL SERIALIZED
> , E INT DEFAULT 3 SERIALIZED
> , PRIMARY KEY (A ASC)
> )
> ;
> upsert into sch.hf_bug (a,b) values (4,'a') ;
> select * from sch.hf_bug ;
> >>upsert into sch.hf_bug (a,b) values (4,'a') ;
> --- 1 row(s) inserted.
> >>select * from hf_bug ;
> A B C D E
> -------------------- ---------- -------------------------- ----------- -----------
> 4 a 0001-01-01 12:00:00.000000 ? 3
> --- 1 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)