[CASSANDRA-10910] Materialized view remained rows

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.3, 3.3
• Component/s: Feature/Materialized Views, Legacy/Coordination

Environment

Cassandra 3.0.0

• Severity: Normal
• Assignee: Carl Yeksigian
• Reporter: Gábor Auth

Authors

Carl Yeksigian

Reviewers

T Jake Luciani

• Created: 21/Dec/15 12:40
• Updated: 16/Apr/19 09:30
• Resolved: 19/Feb/16 21:04

Description

I've created a table and a materialized view.

> CREATE TABLE test (id text PRIMARY KEY, key text, value int);
> CREATE MATERIALIZED VIEW test_view AS SELECT * FROM test WHERE key IS NOT NULL PRIMARY KEY(key, id);

I've put a value into the table:

> update test set key='key', value=1 where id='id';
> select * from test; select * from test_view ;

 id | key | value
----+-----+-------
 id | key |     1

(1 rows)

 key | id | value
-----+----+-------
 key | id |     1

(1 rows)

I've updated the value without specified the key of the materialized view:

> update test set value=2 where id='id';
> select * from test; select * from test_view ;

 id | key | value
----+-----+-------
 id | key |     2

(1 rows)

 key | id | value
-----+----+-------
 key | id |     2

(1 rows)

It works as I think...

...but I've updated the key of the materialized view:

> update test set key='newKey' where id='id';
> select * from test; select * from test_view ;

 id | key    | value
----+--------+-------
 id | newKey |     2

(1 rows)

 key    | id | value
--------+----+-------
    key | id |     2
 newKey | id |     2

(2 rows)

...I've updated the value of the row:

> update test set key='newKey', value=3 where id='id';
> select * from test; select * from test_view ;

 id | key    | value
----+--------+-------
 id | newKey |     3

(1 rows)

 key    | id | value
--------+----+-------
    key | id |     2
 newKey | id |     3

(2 rows)

...I've deleted the row by the id key:

> delete from test where id='id';
> select * from test; select * from test_view ;

 id | key | value
----+-----+-------

(0 rows)

 key | id | value
-----+----+-------
 key | id |     2

(1 rows)

Is it a bug?