[
https://issues.apache.org/jira/browse/CASSANDRA-14533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
C. Scott Andreas updated CASSANDRA-14533:
-----------------------------------------
Component/s: (was: Legacy/CQL)
CQL/Interpreter
> Frozen Collections should allow TTL and WRITETIME access
> --------------------------------------------------------
>
> Key: CASSANDRA-14533
> URL: https://issues.apache.org/jira/browse/CASSANDRA-14533
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: Scott Carey
> Priority: Major
>
> 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:
>
> {noformat}
> 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'}{noformat}
>
> It is likewise not possible to get the timestamp on a frozen collection from
> the java client.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
