cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremy Hanna (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-12360) Unable to parse negative dates
Date Tue, 02 Aug 2016 17:00:24 GMT

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

Jeremy Hanna commented on CASSANDRA-12360:
------------------------------------------

{code}
[cqlsh:jeremy> create table jeremy.testdate (d date primary key);
cqlsh:jeremy> INSERT INTO testdate (d) VALUES ('-0407-12-27T00:00:00Z');
InvalidRequest: Error from server: code=2200 [Invalid query] message="Unable to coerce '-0407-12-27T00:00:00Z'
to a formatted date (long)"
{code}

The {{date}} type should be able to go to negative values to accommodate BC years but it looks
like we have a bug.

> Unable to parse negative dates
> ------------------------------
>
>                 Key: CASSANDRA-12360
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12360
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Bryn Cooke
>
> {code}
> cqlsh:date_test> DESC test;
> CREATE TABLE date_test.test (
>     date timestamp PRIMARY KEY
> ) ...
> cqlsh:date_test> INSERT INTO test (date) VALUES ('-0407-12-27T00:00:00Z');
> InvalidRequest: Error from server: code=2200 [Invalid query] message="Unable to coerce
'-0407-12-27T00:00:00Z' to a formatted date (long)"
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message