[CASSANDRA-14533] Frozen Collections should allow TTL and WRITETIME access

• Type: Bug
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Component/s: CQL/Interpreter
• Severity: Normal
• Assignee: Unassigned
• Reporter: Scott Carey
• Created: 20/Jun/18 16:39
• Updated: 16/Apr/19 09:29

Description

It is clear why we can not simply access ttl and writetime of normal collections, as the collection itself is made up of multiple cells  (see CASSANDRA-8877)

 

But frozen collections should allow it, since they are just one cell with the whole collection stored in a simple blob.

 

Right now, I get an error message whether it is frozen or not:

 

cqlsh:testing> create table stuff (id int primary key, blah text, stuff frozen<set<text>>);

cqlsh:testing> insert into stuff (id, blah, stuff) VALUES (1, 'blargh', { 'setstuff' });

cqlsh:testing> select id, blah, writetime(blah) from stuff;

id | blah | writetime(blah)
----+--------+------------------
1 | blargh | 1529512132503886

(1 rows)

cqlsh:testing> select id, stuff, writetime(stuff) from stuff;
InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot use selection function writeTime on collections"

cqlsh:testing> select id, stuff from stuff;

id | stuff
----+--------------
1 | {'setstuff'}

 

It is likewise not possible to get the timestamp on a frozen collection from the java client.