[CASSANDRA-17681] CQL function writetime should not be allowed to apply on UDT columns

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Component/s: CQL/Semantics
• Bug Category: Correctness - API / Semantic Implementation
• Severity: Low
• Complexity: Low Hanging Fruit
• Discovered By: Code Inspection
• Platform: All
• Assignee: Unassigned
• Reporter: Yifan Cai
• Created: 03/Jun/22 22:02
• Updated: 13/Jul/22 16:33
• Resolved: 13/Jul/22 16:33

Description

The CQL function writetime is disallowed to be applied to multi-cell columns, since no meaningful writetime can be determined from the cells.

Inspecting the code (i.e. WritetimeOrTTL#newSelectorFactory), it only check whether the column type is collection, ignoring the case of UDT. See the example below.
It should be fixed.

[cqlsh 6.1.0 | Cassandra 4.2-SNAPSHOT | CQL spec 3.4.5 | Native protocol v5]
cqlsh> CREATE TYPE test.my_udt (a int, b int);
cqlsh> CREATE TABLE test.tbl_wt (k int primary key, t test.my_udt);
cqlsh> INSERT INTO test.tbl_wt (k, t) VALUES (1, { a: 1, b: 1 } );
cqlsh> SELECT writetime(t) FROM test.tbl_wt WHERE k = 1;

writetime(t)
--------------
-1

(1 rows)

Issue Links

• Blocked: CASSANDRA-17628 CQL writetime and ttl functions should be forbidden for multicell columns