[CASSANDRA-3311] cqlsh: Error running "select *" vs "select all columns"

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Legacy/CQL

Environment

Server: BDP/main
CQLSH: 1.0.5

• Severity: Normal
• Assignee: Pavel Yaskevich
• Reporter: Cathy Daw

Authors

Pavel Yaskevich

Reviewers

Jonathan Ellis

• Created: 04/Oct/11 21:08
• Updated: 16/Apr/19 09:32
• Resolved: 05/Oct/11 00:36

Description

• Install cql 1.0.5 from http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/downloads/detail?name=cql-1.0.5.tar.gz&can=2&q=

• Query using "select *"

  cqlsh> select * from users;
  Exception: 'utf8' codec can't decode byte 0xb4 in position 7: unexpected code byte
  

• Query selecting all columns

   select KEY, password, gender, session_token, state, birth_year from users;
     KEY |  password | gender | session_token | state | birth_year |
   user1 | ch@ngem3a |      f |          None |    TX |       1968 |
  

• Test Data

  CREATE KEYSPACE ks1 with 
    strategy_class =  
      'org.apache.cassandra.locator.SimpleStrategy' 
    and strategy_options:replication_factor=1;
    
  use ks1;
  
  CREATE COLUMNFAMILY users (
    KEY varchar PRIMARY KEY, password varchar, gender varchar,
    session_token varchar, state varchar, birth_year bigint);
    
  INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user1', 'ch@ngem3a', 'f', 'TX', '1968');