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

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Gu Haiyan
• Reporter: liu ming
• Created: 11/Jan/18 02:21
• Updated: 22/Jun/18 00:21

Description

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

Issue Links

• links to: GitHub Pull Request #1581