cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Lebresne (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8139) The WRITETIME function returns null for negative timestamp values
Date Mon, 20 Oct 2014 08:49:33 GMT

    [ 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)

Mime
View raw message