[ https://issues.apache.org/jira/browse/CASSANDRA-4362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398603#comment-13398603 ]
paul cannon commented on CASSANDRA-4362: ---------------------------------------- As a workaround, you can tell cqlsh explicitly to treat the b column as bigint: {noformat} ASSUME t1(b) VALUES ARE bigint; {noformat} That will last until the end of the session. (You might need the patch from CASSANDRA-4352). > 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