Jeff Jirsa created CASSANDRA-13711:
--------------------------------------
Summary: Invalid writetime for null columns in cqlsh
Key: CASSANDRA-13711
URL: https://issues.apache.org/jira/browse/CASSANDRA-13711
Project: Cassandra
Issue Type: Bug
Reporter: Jeff Jirsa
Fix For: 3.0.x, 3.11.x, 4.x
>From the user list:
https://lists.apache.org/thread.html/448731c029eee72e499fc6acd44d257d1671193f850a68521c2c6681@%3Cuser.cassandra.apache.org%3E
{code}
(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)
{code}
Data on disk:
{code}
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$
{code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
