[ https://issues.apache.org/jira/browse/CASSANDRA-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-2593: -------------------------------------- Component/s: API Affects Version/s: (was: 0.8.0) 0.8 beta 1 Fix Version/s: 0.8.0 Assignee: Pavel Yaskevich > CQL: Errors when running unqualified "select column" statement (no where > clause) > --------------------------------------------------------------------------------- > > Key: CASSANDRA-2593 > URL: https://issues.apache.org/jira/browse/CASSANDRA-2593 > Project: Cassandra > Issue Type: Bug > Components: API > Affects Versions: 0.8 beta 1 > Reporter: Cathy Daw > Assignee: Pavel Yaskevich > Priority: Minor > Labels: cql > Fix For: 0.8.0 > > > *Seed Data* > {code} > CREATE KEYSPACE cqldb with strategy_class = > 'org.apache.cassandra.locator.SimpleStrategy' and > strategy_options:replication_factor=2; > USE cqldb; > CREATE COLUMNFAMILY users (KEY varchar PRIMARY KEY, password varchar, gender > varchar, session_token varchar, state varchar, birth_year bigint); > INSERT INTO users (KEY, password) VALUES ('user0', 'ch@ngem3'); > INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user1', > 'ch@ngem3a', 'f', 'TX', '1968'); > INSERT INTO users (KEY, password) VALUES ('user2', 'ch@ngem3b'); > INSERT INTO users (KEY, password) VALUES ('user3', 'ch@ngem3c'); > {code} > *Query #1 - select varchar column* > {code} > cqlsh> select state from users; > u'user1' | u'state',u'TX' > Exception: 'NoneType' object has no attribute 'decode' > cqlsh> select birth_year from users where KEY='user1'; > u'user1' | u'birth_year',1968 > {code} > *Query #2 - select bigint column* > {code} > cqlsh> select birth_year from users; > Exception: unpack requires a string argument of length 8 > cqlsh> select state from users where KEY='user1'; > u'user1' | u'state',u'TX' > {code} > *A simple 'SELECT *' with no WHERE clause works fine* > {code} > cqlsh> select * from users; > u'user1' | u'birth_year',1968 | u'gender',u'f' | u'password',u'ch@ngem3a' | > u'state',u'TX' > u'user0' | u'password',u'ch@ngem3' > u'user3' | u'password',u'ch@ngem3c' > u'user2' | u'password',u'ch@ngem3b' > {code} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira