[CASSANDRA-8215] Empty IN Clause still returns data

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Fix Version/s: 2.2.0 beta 1
• Severity: Normal
• Since Version: 2.2.0 beta 1
• Assignee: Benjamin Lerer
• Reporter: Philip Thompson

Authors

Benjamin Lerer

• Tester: Philip Thompson
• Created: 29/Oct/14 19:06
• Updated: 16/Apr/19 09:31
• Resolved: 05/Dec/14 09:18

Description

The dtest cql_tests.py:TestCQL.empty_in_test is failing on trunk HEAD but not on 2.1-HEAD.

The test uses the following table:

 CREATE TABLE test (k1 int, k2 int, v int, PRIMARY KEY (k1, k2)) 

then performs a number of inserts.

The test then asserts that

 SELECT v FROM test WHERE k1 = 0 AND k2 IN () 

returns no data, however it is returning everywhere k1 = 0.

Issue Links

• duplicates: CASSANDRA-8419 NPE in SelectStatement
• is blocked by: CASSANDRA-8419 NPE in SelectStatement