[ https://issues.apache.org/jira/browse/CASSANDRA-3612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13216027#comment-13216027 ]
paul cannon commented on CASSANDRA-3612: ---------------------------------------- This particular problem is fixed in my github fork, in the 3612-1.0 and 3612-1.1 branches. https://github.com/thepaul/cassandra/commit/5dc73e765f - 3612-1.0 https://github.com/thepaul/cassandra/commit/eab19b0979 - 3612-1.1 However, it looks like problems of a similar nature still exist in cql3, in the 1.1 series. I'll fix that and include those changes along with this ticket. > 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.0 > 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 > Assignee: paul cannon > Priority: Minor > Labels: cql > Fix For: 1.0.9 > > > 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