[CASSANDRA-7081] select writetime(colname) returns 0 for static columns

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.8
• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: Nicolas Favre-Felix

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Created: 24/Apr/14 04:48
• Updated: 16/Apr/19 09:31
• Resolved: 02/May/14 10:47

Description

Selecting the write time for a static column returns 0 in Cassandra 2.0 (c3550fe) and an expected timestamp in 2.1 (trunk, acdbbb9). Would it be possible to include this timestamp in a 2.0 release too?

> CREATE TABLE test (partition_key text, cluster_key text, data text, st text static, PRIMARY KEY(partition_key, cluster_key));
> INSERT INTO test (partition_key, cluster_key, data, st) VALUES ( 'PK', 'CK', 'DATA', 'ST');
> SELECT writetime(st), writetime(data) FROM test where partition_key='PK';

 writetime(st) | writetime(data)
---------------+------------------
             0 | 1398314681729000

(1 rows)