Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-4362

cqlsh can't display reversed type values properly

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Not A Problem
    • Fix Version/s: 1.2.0
    • Component/s: Legacy/Tools
    • Labels:
    • Severity:
      Low

      Description

      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 ...

        Attachments

          Activity

            People

            • Assignee:
              aleksey Aleksey Yeschenko
              Reporter:
              liqusha Ahmet AKYOL
              Authors:
              Aleksey Yeschenko
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: