[CASSANDRA-17425] Add new CQL function maxWritetime

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 5.0-alpha1, 5.0
• Component/s: CQL/Syntax
• Change Category: Semantic
• Complexity: Normal
• Platform: All

Source Control Link

https://github.com/apache/cassandra/commit/26dd119679605bf61ad3caa24a70509e5be5aac9

Test and Documentation Plan

ci; unit test

• Assignee: Yifan Cai
• Reporter: Yifan Cai

Authors

Yifan Cai

Reviewers

Andres de la Peña, Francisco Guerrero

• Created: 09/Mar/22 00:56
• Updated: 12/Sep/23 13:03
• Resolved: 18/May/22 18:58

Description

The function "writetime" does not support multi-cell types, e.g. collections and UDT. It would be useful to enable querying the latest modified timestamp of a column value.

I'd like to propose to add a new function named "maxWritetime", which returns the largest timestamp amongst the cells. When being applied to the single cell types, it returns the same result as "writetime".

Issue Links

• Testing discovered: CASSANDRA-17628 CQL writetime and ttl functions should be forbidden for multicell columns
• links to: PR trunk