Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1257

Upserted data seen by SELECT in UPSERT SELECT execution

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 4.2.0, 3.2.0
    • None
    • None

    Description

      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.

      Attachments

        1. 1257-test.txt
          3 kB
          Lars Hofhansl
        2. 1257-WIP.txt
          7 kB
          Lars Hofhansl
        3. PHOENIX-1257.patch
          10 kB
          James R. Taylor

        Issue Links

          Activity

            People

              jamestaylor James R. Taylor
              larsh Lars Hofhansl
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: