[
https://issues.apache.org/jira/browse/CASSANDRA-8139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Bremner updated CASSANDRA-8139:
---------------------------------------
Description:
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*.
was:
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 appears to have been introduced by this commit:
https://github.com/apache/cassandra/commit/65b9093
> 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
>
> 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)
