[jira] [Created] (TRAFODION-2901) using sequence to do upsert get wrong number of rows after several times

["liu ming (JIRA)" <ji...@apache.org>]

liu ming created TRAFODION-2901:
-----------------------------------

             Summary: 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: liu ming


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)