[
https://issues.apache.org/jira/browse/PHOENIX-1257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14145614#comment-14145614
]
Jeffrey Zhong commented on PHOENIX-1257:
----------------------------------------
Do you mean bump up the timestamp of TableRef there? The issue before is that
we use same connection firstly upsert some values and then the following query
doesn't return anything back. If the suggestion can work in that case, it'll be
great.
> 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
> Priority: Critical
> Attachments: 1257-WIP.txt, 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)
