[
https://issues.apache.org/jira/browse/TRAFODION-2901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16492216#comment-16492216
]
ASF GitHub Bot commented on TRAFODION-2901:
-------------------------------------------
GitHub user Guhaiyan opened a pull request:
https://github.com/apache/trafodion/pull/1581
[TRAFODION-2901] Self-reference Holloween problem fix
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/Guhaiyan/traffork_ghy jira2901
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1581.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1581
----
commit c8c5bce5baf23c131aa622c6ca6672daa0eb2318
Author: Guhaiyan <haiyan.gu@...>
Date: 2018-05-28T01:40:27Z
[TRAFODION-2901] Self-reference Holloween problem fix
----
> 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
> Priority: Major
>
> 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
(v7.6.3#76005)
