You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Lars Hofhansl (JIRA)" <ji...@apache.org> on 2014/10/11 07:26:33 UTC

[jira] [Resolved] (PHOENIX-1257) Upserted data seen by SELECT in UPSERT SELECT execution

     [ https://issues.apache.org/jira/browse/PHOENIX-1257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lars Hofhansl resolved PHOENIX-1257.
------------------------------------
       Resolution: Fixed
    Fix Version/s: 3.2
                   4.2

> Upserted data seen by SELECT in UPSERT SELECT execution
> -------------------------------------------------------
>
>                 Key: PHOENIX-1257
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1257
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Lars Hofhansl
>            Assignee: James Taylor
>            Priority: Critical
>             Fix For: 4.2, 3.2
>
>         Attachments: 1257-WIP.txt, 1257-test.txt, PHOENIX-1257.patch
>
>
> 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)