Lars Hofhansl created PHOENIX-1257:
--------------------------------------

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


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