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

deleted row still can be selected out

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Urgent
    • Resolution: Fixed
    • Fix Version/s: 2.0.12, 2.1.3
    • Component/s: None
    • Labels:
    • Environment:

      2.1.2
      java version "1.7.0_55"

    • Severity:
      Critical

      Description

      first

      CREATE  KEYSPACE space1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};
      CREATE  TABLE space1.table3(a int, b int, c text,primary key(a,b));
      CREATE  KEYSPACE space2 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};

      second

      CREATE  TABLE space2.table1(a int, b int, c int, primary key(a,b));
      CREATE  TABLE space2.table2(a int, b int, c int, primary key(a,b));
      INSERT INTO space1.table3(a,b,c) VALUES(1,1,'1');
      drop table space2.table1;
      DELETE FROM space1.table3 where a=1 and b=1;
      drop table space2.table2;
      select * from space1.table3 where a=1 and b=1;

      you will find that the row (a=1 and b=1) in space1.table3 is not deleted.

        Attachments

        1. 8558.txt
          4 kB
          Sylvain Lebresne
        2. 8558-v2_2.0.txt
          4 kB
          Sylvain Lebresne
        3. 8558-v2_2.1.txt
          16 kB
          Sylvain Lebresne

          Issue Links

            Activity

              People

              • Assignee:
                slebresne Sylvain Lebresne
                Reporter:
                zhaoyan zhaoyan
                Authors:
                Sylvain Lebresne
                Reviewers:
                Tyler Hobbs
                Tester:
                Philip Thompson
              • Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: