cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-13711) Invalid writetime for null columns in cqlsh
Date Fri, 28 Jul 2017 11:50:02 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-13711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Aleksey Yeschenko updated CASSANDRA-13711:
------------------------------------------
    Reviewer: Aleksey Yeschenko

> 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org


Mime
View raw message