[ https://issues.apache.org/jira/browse/CASSANDRA-10000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14908493#comment-14908493 ]
Paulo Motta commented on CASSANDRA-10000: ----------------------------------------- bq. I will go ahead and open up another ticket, and probably code a patch for it myself. sounds good, I'm happy to review it. you can reuse CASSANDRA-10397 if you haven't created a new ticket yet, otherwise I will close that as a duplicate of the new ticket. > Dates before 1970-01-01 are not formatted correctly on cqlsh\Windows > -------------------------------------------------------------------- > > Key: CASSANDRA-10000 > URL: https://issues.apache.org/jira/browse/CASSANDRA-10000 > Project: Cassandra > Issue Type: Bug > Environment: windows > Reporter: Paulo Motta > Assignee: Paulo Motta > Priority: Minor > Labels: cqlsh, windows > Fix For: 2.1.9, 2.2.1, 3.0 beta 1 > > > The following test fails on Windows: > {code:none} > def test_past_and_future_dates(self): > self.cluster.populate(1) > self.cluster.start(wait_for_binary_proto=True) > node1, = self.cluster.nodelist() > node1.run_cqlsh(cmds=""" > CREATE KEYSPACE simple WITH replication = {'class': > 'SimpleStrategy', 'replication_factor': 1}; > use simple; > create TABLE simpledate (id int PRIMARY KEY , value timestamp ) ; > insert into simpledate (id, value) VALUES (1, > '2143-04-19T11:21:01+0000'); > insert into simpledate (id, value) VALUES (2, > '1943-04-19T11:21:01+0000')""") > session = self.patient_cql_connection(node1) > rows = session.execute("select id, value from simple.simpledate") > output, err = self.run_cqlsh(node1, 'use simple; SELECT * FROM > simpledate') > self.assertIn("2143-04", output) > self.assertIn("1943-04", output) > {code} > With the following message: > {noformat} > AssertionError: '1943-04' not found in "\r\n id | > value\r\n----+-------------------------------------------\r\n 1 | > 2143-04-19 08:21:01.-0300\r\n 2 | datetime.datetime(1943, 4, 19, 11, > 21, 1)\r\n\r\n(2 rows)\r\nFailed to format value datetime.datetime(1943, 4, > 19, 11, 21, 1) : (22, 'Invalid argument')\r\n" > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)