[ https://issues.apache.org/jira/browse/CASSANDRA-13711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jeff Jirsa updated CASSANDRA-13711: ----------------------------------- Status: Patch Available (was: In Progress) > Invalid writetime for null columns in cqlsh > ------------------------------------------- > > Key: CASSANDRA-13711 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13711 > Project: Cassandra > Issue Type: Bug > Components: CQL > Reporter: Jeff Jirsa > Assignee: 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: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org