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

Updatable view should check view condition upon upsert

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0, 4.0.0
    • Labels:
      None

      Description

      Updating a row can make it disappear from the view:

      create table X (X varchar primary key, Y varchar);
      create view X1 as select * from X where Y = '1';
      upsert into X1 values('1', '1');
      // now the row with key '1' is visible through the view
      upsert into X1 values('1', '2');
      // row with key '1' is no longer visible
      upsert into X1 values('2', '2');
      // the new row never shows up in the view

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lhofhansl Lars Hofhansl
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: