Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-10000

Dates before 1970-01-01 are not formatted correctly on cqlsh\Windows

    XMLWordPrintableJSON

    Details

    • Severity:
      Low

      Description

      The following test fails on Windows:

          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)
      

      With the following message:

      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"
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pauloricardomg Paulo Motta
                Reporter:
                pauloricardomg Paulo Motta
                Authors:
                Paulo Motta
                Reviewers:
                Tom Hobbs
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: