Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-3612

CQL inserting blank key.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Low
    • Resolution: Fixed
    • Fix Version/s: 1.0.9, 1.1.0
    • Component/s: Legacy/CQL
    • Labels:
    • 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

      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'samalgorai@gmail.com' | u'email',u'samalgorai@gmail.com' | u'password',u'388ad1c312a488ee9e12998fe097f2258fa8d5ee' | u'uid',UUID('05ea41dc-241f-11e1-8521-3da59237b189') | u'verified',u'0'
      cqlsh> quit;

      {/}

      http://pastebin.com/HJn5fHhH

        Attachments

          Activity

            People

            • Assignee:
              thepaul paul cannon
              Reporter:
              samal_ samal
              Authors:
              paul cannon
              Reviewers:
              Pavel Yaskevich
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: