CQL inserting blank key. ------------------------ Key: CASSANDRA-3612 URL: https://issues.apache.org/jira/browse/CASSANDRA-3612 Project: Cassandra Issue Type: Bug Components: API Affects Versions: 1.0.5 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 Reporter: samal Priority: Trivial
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'samalgo...@gmail.com' | u'email',u'samalgo...@gmail.com' | u'password',u'388ad1c312a488ee9e12998fe097f2258fa8d5ee' | u'uid',UUID('05ea41dc-241f-11e1-8521-3da59237b189') | u'verified',u'0' cqlsh> quit; {/} http://pastebin.com/HJn5fHhH -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira