You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "David Capwell (Jira)" <ji...@apache.org> on 2020/10/02 00:40:00 UTC

[jira] [Issue Comment Deleted] (CASSANDRA-16160) Regression in cqlsh with regard to row id display

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

David Capwell updated CASSANDRA-16160:
--------------------------------------
    Comment: was deleted

(was: When you run a query such as

{code}
expand on; 
select * from table_with_clustering_keys where token(partition_key) = 1192326969048244361;
{code}

We print out a header for each row that looks like the following

@ Row 1

In 3.0 all values printed were uniq, but in 4.0 they are no longer unique

{code}
$ grep Row 3.0-rows.results | sort | uniq -c | sort -k1 -h -r | head -n 10
  1 @ Row 999
  1 @ Row 998
  1 @ Row 997
  1 @ Row 996
  1 @ Row 995
  1 @ Row 994
  1 @ Row 993
  1 @ Row 992
  1 @ Row 991
  1 @ Row 990
{code}

{code}
$ grep Row 4.0-rows.results | sort | uniq -c | sort -k1 -h -r | head -n 10
 10 @ Row 9
 10 @ Row 8
 10 @ Row 7
 10 @ Row 6
 10 @ Row 5
 10 @ Row 48
 10 @ Row 47
 10 @ Row 46
 10 @ Row 45
 10 @ Row 44
{code})

> Regression in cqlsh with regard to row id display
> -------------------------------------------------
>
>                 Key: CASSANDRA-16160
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-16160
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tool/cqlsh
>            Reporter: David Capwell
>            Priority: Normal
>
> When you run a query such as
> {code}
> expand on; 
> select * from table_with_clustering_keys where token(partition_key) = 1192326969048244361;
> {code}
> We print out a header for each row that looks like the following
> @ Row 1
> In 3.0 all values printed were uniq, but in 4.0 they are no longer unique
> {code}
> $ grep Row 3.0-rows.results | sort | uniq -c | sort -k1 -h -r | head -n 10
>   1 @ Row 999
>   1 @ Row 998
>   1 @ Row 997
>   1 @ Row 996
>   1 @ Row 995
>   1 @ Row 994
>   1 @ Row 993
>   1 @ Row 992
>   1 @ Row 991
>   1 @ Row 990
> {code}
> {code}
> $ grep Row 4.0-rows.results | sort | uniq -c | sort -k1 -h -r | head -n 10
>  10 @ Row 9
>  10 @ Row 8
>  10 @ Row 7
>  10 @ Row 6
>  10 @ Row 5
>  10 @ Row 48
>  10 @ Row 47
>  10 @ Row 46
>  10 @ Row 45
>  10 @ Row 44
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org