[jira] [Created] (CASSANDRA-12829) DELETE query with an empty IN clause can delete more than expected

["Jason T. Bradshaw (JIRA)" <ji...@apache.org>]

Jason T. Bradshaw created CASSANDRA-12829:
---------------------------------------------

             Summary: DELETE query with an empty IN clause can delete more than expected
                 Key: CASSANDRA-12829
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12829
             Project: Cassandra
          Issue Type: Bug
          Components: CQL
         Environment: Arch Linux x64, kernel 4.7.6, Cassandra 3.9 downloaded from the website
            Reporter: Jason T. Bradshaw


When deleting from a table with a certain structure and using an *in* clause with an empty list, the *in* clause with an empty list can be ignored, resulting in deleting more than is expected.

*Setup:*
{code}
cqlsh> create table test (a text, b text, id uuid, primary key ((a, b), id));
cqlsh> insert into test (a, b, id) values ('a', 'b', 00000000-0000-0000-0000-000000000000);
cqlsh> insert into test (a, b, id) values ('b', 'c', 00000000-0000-0000-0000-000000000000);
cqlsh> insert into test (a, b, id) values ('a', 'c', 00000000-0000-0000-0000-000000000000);
cqlsh> select * from test;

 a | b | id
---+---+--------------------------------------
 a | c | 00000000-0000-0000-0000-000000000000
 b | c | 00000000-0000-0000-0000-000000000000
 a | b | 00000000-0000-0000-0000-000000000000

(3 rows)
{code}

*Expected:*
{code}
cqlsh> delete from test where a = 'a' and b in ('a', 'b', 'c') and id in ();
cqlsh> select * from test;

 a | b | id
---+---+--------------------------------------
 a | c | 00000000-0000-0000-0000-000000000000
 b | c | 00000000-0000-0000-0000-000000000000
 a | b | 00000000-0000-0000-0000-000000000000

(3 rows)
{code}

*Actual:*
{code}
cqlsh> delete from test where a = 'a' and b in ('a', 'b', 'c') and id in ();
cqlsh> select * from test;

 a | b | id
---+---+--------------------------------------
 b | c | 00000000-0000-0000-0000-000000000000

(1 rows)
{code}

Instead of deleting nothing, as the final empty *in* clause would imply, it instead deletes everything that matches the first two clauses, acting as if the following query had been issued instead:

{code}
cqlsh> delete from test where a = 'a' and b in ('a', 'b', 'c');
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)