[
https://issues.apache.org/jira/browse/TRAFODION-1700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15174118#comment-15174118
]
ASF GitHub Bot commented on TRAFODION-1700:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/340
> Upsert with omitted default value columns leave the aligned format table in
> corrupted state.
> --------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1700
> URL: https://issues.apache.org/jira/browse/TRAFODION-1700
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: 2.0-incubating
> Reporter: Suresh Subbiah
> Assignee: Selvaganesan Govindarajan
>
> Please use this to reproduce the problem
> CREATE TABLE al_bug
> (
> a LARGEINT GENERATED BY DEFAULT AS IDENTITY
> , b LARGEINT DEFAULT NULL
> , c TIMESTAMP(6) DEFAULT CURRENT
> , d TIMESTAMP(6) DEFAULT CURRENT
> , e SMALLINT DEFAULT NULL SERIALIZED
> , f VARCHAR(10 BYTES) CHARACTER SET UTF8 DEFAULT NULL
> , primary key (a))
> salt using 2 partitions
> attributes aligned format ;
> upsert into al_bug(b,f) select * from (values(1,'a'),(2,'b'),(3,'c')) x ;
> >>select * from al_bug ;
> ..
> A B C D
> E F
> -------------------- -------------------- --------------------------
> -------------------------- ------ ----------
> 1 1 97- 00:00:00.425344
> 00:00:00.000000 1
> 2 2 98- 00:00:00.425344
> 00:00:00.000000 1
> 3 3 99- 00:00:00.425344
> 00:00:00.000000 1
> --- 3 row(s) selected.
> >>
> Columns C, D have wrong values here and likely E & F too.
> If F is declared as VARCHAR(4K) more junk characters can be seen in output.
> These similar table definitions do not seem to have the problem
> create table al_bug (a int default null, b int ) attributes aligned format ;
> create table al_bug3 (a0 largeint generated by default as identity, a
> timestamp default current, e int default null, b varchar(10), primary key(a0)
> ) attributes aligned format ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
