[CASSANDRA-8139] The WRITETIME function returns null for negative timestamp values

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.12, 2.1.2
• Component/s: Legacy/CQL
• Severity: Low
• Assignee: Sylvain Lebresne
• Reporter: Richard Bremner

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Created: 18/Oct/14 08:58
• Updated: 16/Apr/19 09:31
• Resolved: 29/Oct/14 09:50

Description

Insert a column with a negative timestamp value:

INSERT INTO my_table (col1, col2, col3)
VALUES ('val1', 'val2', 'val3') 
USING TIMESTAMP -1413614886750020;

Then attempt to read the writetime:

SELECT WRITETIME(col3) FROM my_table WHERE col1 = 'val1'

The result is null.