[PHOENIX-5580] Wrong values seen when updating a view for a table that has an index

• 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
• Labels: indexing phoenix-hardening
• Assignee: Sandeep Guggilam
• Reporter: Swaroopa Kadam
• Created: 21/Nov/19 01:26
• Updated: 01/Aug/23 15:03
• Resolved: 05/May/20 02:09

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

Issue Links

• links to: GitHub Pull Request #768