[
https://issues.apache.org/jira/browse/CASSANDRA-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Cathy Daw updated CASSANDRA-2593:
---------------------------------
Description:
*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}
was:
*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}
> 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 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
