[
https://issues.apache.org/jira/browse/CASSANDRA-8139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14176726#comment-14176726
]
Sylvain Lebresne commented on CASSANDRA-8139:
---------------------------------------------
Honestly, if you're inserting negative timestamp, you're doing it wrong.
That said, it's true technically that we don't forbid negative timestamps so I
suppose we should either start forbidding them or fix this, and it's probably
easier to just fix this so attaching a simple patch.
> The WRITETIME function returns null for negative timestamp values
> -----------------------------------------------------------------
>
> Key: CASSANDRA-8139
> URL: https://issues.apache.org/jira/browse/CASSANDRA-8139
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Reporter: Richard Bremner
> Priority: Minor
> Attachments: 8139.txt
>
>
> Insert a column with a negative timestamp value:
> {code}
> INSERT INTO my_table (col1, col2, col3)
> VALUES ('val1', 'val2', 'val3')
> USING TIMESTAMP -1413614886750020;
> {code}
> Then attempt to read the *writetime*:
> {code}
> SELECT WRITETIME(col3) FROM my_table WHERE col1 = 'val1'
> {code}
> The result is *null*.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
