[ 
https://issues.apache.org/jira/browse/PHOENIX-1257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14142805#comment-14142805
 ] 

Lars Hofhansl commented on PHOENIX-1257:
----------------------------------------

I also notice incorrect results... I.e. number of rows upserted not being a 
power of two, but shouldn't happen - looks like the same issue, though.

> Strange behavior wirh "upsert into ... select from ..." with sequences
> ----------------------------------------------------------------------
>
>                 Key: PHOENIX-1257
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1257
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Lars Hofhansl
>         Attachments: 1257-test.txt
>
>
> I have the following scenario:
> create sequence keys;
> create table X (pk unsigned_long primary key, val integer);
> upsert into x values (1,1);
> Followed by repeated:
> upsert into x select next value for keys, val from x;
> This works well until 2048 rows are inserted. The next
> upsert into x select next value for keys, val from x;
> That loops forever inserting more and more rows until it is stopped.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to