Hi,
I did a small test using TTL but I didn't get the result I expected.
I did this in sqlsh:
cqlsh> create TABLE foo.bar ( key int, cluster int, col int, PRIMARY KEY
(key, cluster)) ;
cqlsh> INSERT INTO foo.bar (key, cluster ) VALUES ( 1,1 );
cqlsh> SELECT * FROM foo.bar ;
key | cluster | col
-----+---------+------
1 | 1 | null
(1 rows)
cqlsh> INSERT INTO foo.bar (key, cluster, col ) VALUES ( 1,1,1 ) USING
TTL 10;
cqlsh> SELECT * FROM foo.bar ;
key | cluster | col
-----+---------+-----
1 | 1 | 1
(1 rows)
<wait for TTL to expire>
cqlsh> SELECT * FROM foo.bar ;
key | cluster | col
-----+---------+-----
(0 rows)
Is this really correct?
I expected the result from the last select to be:
key | cluster | col
-----+---------+------
1 | 1 | null
(1 rows)
Regards,
Tommy
