[jira] [Created] (CASSANDRA-14071) Materialized view on table with TTL issue

["Silviu Butnariu (JIRA)" <ji...@apache.org>]

Silviu Butnariu created CASSANDRA-14071:
-------------------------------------------

             Summary: Materialized view on table with TTL issue
                 Key: CASSANDRA-14071
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-14071
             Project: Cassandra
          Issue Type: Bug
          Components: Coordination, Materialized Views
         Environment: Cassandra 3
            Reporter: Silviu Butnariu


Materialized views that cluster by a column that is not part of table's PK and are created from tables that have *default_time_to_live* seem to malfunction.

Having this table
{code:java}
CREATE TABLE sbutnariu.test_bug (
    field1 smallint,
    field2 smallint,
    date timestamp,
    PRIMARY KEY ((field1), field2)
) WITH default_time_to_live = 1000;
{code}

and the materialized view
{code:java}
CREATE MATERIALIZED VIEW sbutnariu.test_bug_by_date AS SELECT * FROM sbutnariu.test_bug WHERE field1 IS NOT NULL AND field2 IS NOT NULL AND date IS NOT NULL PRIMARY KEY ((field1), date, field2) WITH CLUSTERING ORDER BY (date desc, field2 asc);
{code}

After inserting 3 rows with same PK (should upsert), the materialized view will have 3 rows.
{code:java}
insert into sbutnariu.test_bug(field1, field2, date) values (1, 2, toTimestamp(now()));
insert into sbutnariu.test_bug(field1, field2, date) values (1, 2, toTimestamp(now()));
insert into sbutnariu.test_bug(field1, field2, date) values (1, 2, toTimestamp(now()));

select * from sbutnariu.test_bug; /*1 row*/
select * from sbutnariu.test_bug_by_date;/*3 rows*/
{code}

If I remove the ttl and try again, it works as expected:
{code:java}
truncate sbutnariu.test_bug;
alter table sbutnariu.test_bug with default_time_to_live = 0;

select * from sbutnariu.test_bug; /*1 row*/
select * from sbutnariu.test_bug_by_date;/*1 row*/
{code}

I've tested on versions 3.0.14 and 3.0.15. The bug was introduced in 3.0.15, as in 3.0.14 it works as expected.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org