cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Lebresne (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4362) cqlsh can't display reversed type values properly
Date Wed, 20 Jun 2012 17:50:42 GMT

    [ 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

        

Mime
View raw message