[CASSANDRA-3612] CQL inserting blank key.

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.0.9, 1.1.0
• Component/s: Legacy/CQL
• Labels: cql

Environment

Linux ubuntu 3.0.0-12-generic #20-Ubuntu SMP Fri Oct 7 14:56:25 UTC 2011 x86_64 x86_64 x86_64 GNU/Linux

• Severity: Low
• Assignee: paul cannon
• Reporter: samal

Authors

paul cannon

Reviewers

Pavel Yaskevich

• Created: 11/Dec/11 18:01
• Updated: 16/Apr/19 09:32
• Resolved: 28/Mar/12 17:06

Description

One of our application bug inserted blank key into cluster causing assertion error on key. After checking the root cause, I found it is the bug with CQL and reproducible. Client cassandra-node and cqlsh-1.0.6.
Blank key only work when one column provided.

{}
cqlsh> insert into login (KEY,email)values('','');
cqlsh> select * from login;
u'' | u'email',u''
cqlsh> insert into login (KEY,email,verified)values('','','');
Request did not complete within rpc_timeout.
cqlsh> insert into login (KEY,verified)values('','');
Request did not complete within rpc_timeout.
cqlsh> insert into login (KEY,email)values('','');
cqlsh>
cqlsh> select * from login;
u'' | u'email',u'' | u'uid',None
cqlsh> select * from login;
u'' | u'email',u'' | u'uid',None
cqlsh> select * from login;
u'' | u'email',u'' | u'uid',None
cqlsh>
cqlsh> select * from login;
u'' | u'email',u'' | u'uid',None
u'[e-mail]' | u'email',u'[e-mail]' | u'password',u'388ad1c312a488ee9e12998fe097f2258fa8d5ee' | u'uid',UUID('05ea41dc-241f-11e1-8521-3da59237b189') | u'verified',u'0'
cqlsh> quit;

{/}

http://pastebin.com/HJn5fHhH