You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2018/01/11 03:01:00 UTC
[jira] [Assigned] (TRAFODION-2901) using sequence to do upsert get
wrong number of rows after several times
[ https://issues.apache.org/jira/browse/TRAFODION-2901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liu ming reassigned TRAFODION-2901:
-----------------------------------
Assignee: Gu Haiyan (was: liu ming)
> using sequence to do upsert get wrong number of rows after several times
> ------------------------------------------------------------------------
>
> Key: TRAFODION-2901
> URL: https://issues.apache.org/jira/browse/TRAFODION-2901
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: liu ming
> Assignee: Gu Haiyan
>
> create table test_seq
> (id LARGEINT not null
> ) primary key(id)
> SALT USING 48 PARTITIONS
> ATTRIBUTES ALIGNED FORMAT
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> MEMSTORE_FLUSH_SIZE = '1073741824'
> );
> create sequence seq1;
> upsert into test_seq select seqnum(seq1, next) from dual;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> upsert into test_seq select seqnum(seq1, next) from test_seq;
> --- 130 row(s) inserted.
> Should be 128 rows
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)