[CASSANDRA-13711] Invalid writetime for null columns in cqlsh

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.15, 3.11.1, 4.0-alpha1, 4.0
• Component/s: Legacy/CQL
• Severity: Normal
• Assignee: Jeff Jirsa
• Reporter: Jeff Jirsa

Authors

Jeff Jirsa

Reviewers

Aleksey Yeschenko

• Created: 20/Jul/17 15:45
• Updated: 15/May/20 08:06
• Resolved: 31/Jul/17 22:32

Description

From the user list:

https://lists.apache.org/thread.html/448731c029eee72e499fc6acd44d257d1671193f850a68521c2c6681@%3Cuser.cassandra.apache.org%3E

(oss-ccm) MacBook-Pro:~ jjirsa$ ccm create test -n 1 -s -v 3.0.10
Current cluster is now: test
(oss-ccm) MacBook-Pro:~ jjirsa$ ccm node1 cqlsh
Connected to test at 127.0.0.1:9042.
[cqlsh 5.0.1 | Cassandra 3.0.10 | CQL spec 3.4.0 | Native protocol v4]
Use HELP for help.
cqlsh> CREATE KEYSPACE test WITH replication = {'class':'SimpleStrategy', 'replication_factor': 1};
cqlsh> CREATE TABLE test.t ( a text primary key, b text );
cqlsh> insert into test.t(a) values('z');
cqlsh> insert into test.t(a) values('w');
cqlsh> insert into test.t(a) values('e');
cqlsh> insert into test.t(a) values('r');
cqlsh> insert into test.t(a) values('t');
cqlsh> select a,b, writetime (b) from test.t;

a | b | writetime(b)
---+------+--------------
z | null | null
e | null | null
r | null | null
w | null | null
t | null | null

(5 rows)
cqlsh>
cqlsh> insert into test.t(a,b) values('t','x');
cqlsh> insert into test.t(a) values('b');
cqlsh> select a,b, writetime (b) from test.t;

 a | b    | writetime(b)
---+------+------------------
 z | null |             null
 e | null |             null
 r | null |             null
 w | null |             null
 t |    x | 1500565131354883
 b | null | 1500565131354883

(6 rows)

Data on disk:

MacBook-Pro:~ jjirsa$ ~/.ccm/repository/3.0.14/tools/bin/sstabledump /Users/jjirsa/.ccm/test/node1/data0/test/t-bed196006d0511e7904be9daad294861/mc-1-big-Data.db
[
  {
    "partition" : {
      "key" : [ "z" ],
      "position" : 0
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 20,
        "liveness_info" : { "tstamp" : "2017-07-20T04:41:54.818118Z" },
        "cells" : [ ]
      }
    ]
  },
  {
    "partition" : {
      "key" : [ "e" ],
      "position" : 21
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 44,
        "liveness_info" : { "tstamp" : "2017-07-20T04:42:04.288547Z" },
        "cells" : [ ]
      }
    ]
  },
  {
    "partition" : {
      "key" : [ "r" ],
      "position" : 45
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 68,
        "liveness_info" : { "tstamp" : "2017-07-20T04:42:08.991417Z" },
        "cells" : [ ]
      }
    ]
  },
  {
    "partition" : {
      "key" : [ "w" ],
      "position" : 69
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 92,
        "liveness_info" : { "tstamp" : "2017-07-20T04:41:59.005382Z" },
        "cells" : [ ]
      }
    ]
  },
  {
    "partition" : {
      "key" : [ "t" ],
      "position" : 93
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 120,
        "liveness_info" : { "tstamp" : "2017-07-20T15:38:51.354883Z" },
        "cells" : [
          { "name" : "b", "value" : "x" }
        ]
      }
    ]
  },
  {
    "partition" : {
      "key" : [ "b" ],
      "position" : 121
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 146,
        "liveness_info" : { "tstamp" : "2017-07-20T15:39:03.631297Z" },
        "cells" : [ ]
      }
    ]
  }
]MacBook-Pro:~ jjirsa$

Issue Links

• is related to: CASSANDRA-13764 SelectTest.testMixedTTLOnColumnsWide is flaky