[ 
https://issues.apache.org/jira/browse/CASSANDRA-8139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14178673#comment-14178673
 ] 

Tyler Hobbs commented on CASSANDRA-8139:
----------------------------------------

bq. 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.

At least for the v3 protocol, we explicitly disallow negative timestamps.  See 
the discussion on CASSANDRA-6855 (and this commit in particular: 
https://github.com/pcmanus/cassandra/commit/d9a584efa94b9c3deb35746985a45573f16bb9bd).

> 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
>            Assignee: Sylvain Lebresne
>            Priority: Minor
>             Fix For: 2.0.12
>
>         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)

Reply via email to