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

The WRITETIME function returns null for negative timestamp values

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 2.0.12, 2.1.2
    • Legacy/CQL
    • None
    • Low

    Description

      Insert a column with a negative timestamp value:

      INSERT INTO my_table (col1, col2, col3)
VALUES ('val1', 'val2', 'val3') 
USING TIMESTAMP -1413614886750020;

      Then attempt to read the writetime:

      SELECT WRITETIME(col3) FROM my_table WHERE col1 = 'val1'

      The result is null.

      Attachments

        1. 8139-2.1.txt
          8 kB
          Sylvain Lebresne
        2. 8139.txt
          3 kB
          Sylvain Lebresne

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            slebresne Sylvain Lebresne Assign to me
            richardb Richard Bremner
            Sylvain Lebresne
            Tom Hobbs
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment