You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2012/06/20 19:50:42 UTC

[jira] [Commented] (CASSANDRA-4362) cqlsh can't display reversed type values properly

    [ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397685#comment-13397685 ] 

Sylvain Lebresne commented on CASSANDRA-4362:
---------------------------------------------

That's likely because cqlsh don't know about ReversedType. However, I'm not sure we should fix cqlsh, but maybe rather not send the ReversedType bits. After all for CQL3, the reversed part is a server side optimization, clients shouldn't have to care about it.
                
> cqlsh can't display reversed type values properly
> -------------------------------------------------
>
>                 Key: CASSANDRA-4362
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4362
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 1.1.1
>            Reporter: Ahmet AKYOL
>            Priority: Minor
>              Labels: cqlsh
>
> Here is table and data:
> CREATE TABLE t1 (
>   a int,
>   b bigint,
>   c varchar,
>   d varchar,
>   PRIMARY KEY (a,b,c)
> ) WITH CLUSTERING ORDER BY (b DESC, c DESC);
> INSERT INTO db.t1 (a,b,c,d)  VALUES (1,10,'u1','s1');
> INSERT INTO db.t1 (a,b,c,d)  VALUES (1,15,'u1','d1');
> INSERT INTO db.t1 (a,b,c,d)  VALUES (1,21,'u3','ghfgh f1g');
> INSERT INTO db.t1 (a,b,c,d)  VALUES (1,31,'u2','1gh');
> INSERT INTO db.t1 (a,b,c,d)  VALUES (1,41,'u3','fgh1');
> And here's the query
> cqlsh:db> SELECT * FROM t1;
>  a | b                                | c  | d
> ---+----------------------------------+----+-----------
>  1 |    \x00\x00\x00\x00\x00\x00\x00) | u3 |      fgh1
>  1 | \x00\x00\x00\x00\x00\x00\x00\x1f | u2 |       1gh
>  1 | \x00\x00\x00\x00\x00\x00\x00\x15 | u3 | ghfgh f1g
>  1 | \x00\x00\x00\x00\x00\x00\x00\x0f | u1 |        d1
>  1 |   \x00\x00\x00\x00\x00\x00\x00\n | u1 |        s1
> As you can see, cqlsh can't display reversed type values properly ...

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira