[ https://issues.apache.org/jira/browse/CASSANDRA-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13028293#comment-13028293 ]
Jonathan Ellis commented on CASSANDRA-2593: ------------------------------------------- bq. The thing is that when you do "select name from users" and only few of the rows have a "name" column, cqlsh will output all other keys as empty. Right. (And this part, at least, *is* intuitive to someone coming from SQL: if I have a null column, I still want to see the row included.) > 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 beta 2 > > Attachments: CASSANDRA-2593.patch > > > *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 state from users where KEY='user1'; > u'user1' | u'state',u'TX' > {code} > *Query #2 - select bigint column* > {code} > cqlsh> select birth_year from users; > Exception: unpack requires a string argument of length 8 > cqlsh> select birth_year from users where KEY='user1'; > u'user1' | u'birth_year',1968 > {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