Gábor Auth created CASSANDRA-10910: --------------------------------------
Summary: Materialized view remained rows Key: CASSANDRA-10910 URL: https://issues.apache.org/jira/browse/CASSANDRA-10910 Project: Cassandra Issue Type: Bug Environment: Cassandra 3.0.0 Reporter: Gábor Auth I've created a table and a materialized view. {code} > 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); {code} I've put a value into the table: {code} > 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) {code} I've updated the value without specified the key of the materialized view: {code} > 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) {code} It works as I think... ...but I've updated the key of the materialized view: {code} > 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) > 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) {code} It is a bug? -- This message was sent by Atlassian JIRA (v6.3.4#6332)