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

Wrong values seen when updating a view for a table that has an index

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.15.0, 4.14.1, 4.14.3
    • Fix Version/s: 5.1.0, 4.16.0
    • Component/s: None

      Description

      CREATE TABLE IF NOT EXISTS TEST (ID INTEGER NOT NULL PRIMARY KEY, HOST VARCHAR(10));
      CREATE INDEX I ON TEST(HOST);
      
      -- create updatable view (equality condition in where clause)
       CREATE VIEW V1 (col1 INTEGER) AS SELECT * FROM TEST WHERE ID=15;
       UPSERT INTO V1(ID, HOST, col1) VALUES (15, 'this', 7);
      
      SELECT * FROM TEST;
      -- Wrong results, but correct results when using the NO_INDEX hint
      

        Attachments

        1. PHOENIX-5580.4.x.v1.patch
          21 kB
          Sandeep Guggilam
        2. PHOENIX-5580.4.x.v2.patch
          23 kB
          Sandeep Guggilam
        3. PHOENIX-5580.4.x.v3.patch
          23 kB
          Sandeep Guggilam
        4. PHOENIX-5580.master.v1.patch
          23 kB
          Sandeep Guggilam

          Activity

            People

            • Assignee:
              sandeep.guggilam Sandeep Guggilam
              Reporter:
              swaroopa Swaroopa Kadam
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 2.5h
                2.5h