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

deleted row still can be selected out

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Urgent
    • Resolution: Fixed
    • 2.0.12, 2.1.3
    • None
    • 2.1.2
      java version "1.7.0_55"

    • 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

              slebresne Sylvain Lebresne
              zhaoyan zhaoyan
              Sylvain Lebresne
              Tom Hobbs
              Philip Thompson Philip Thompson
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: