[
https://issues.apache.org/jira/browse/CASSANDRA-12360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15404386#comment-15404386
]
Jeremy Hanna edited comment on CASSANDRA-12360 at 8/2/16 5:00 PM:
------------------------------------------------------------------
{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.
was (Author: jeromatron):
{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)
