You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Kishan Karunaratne (JIRA)" <ji...@apache.org> on 2015/11/16 22:36:10 UTC
[jira] [Created] (CASSANDRA-10715) Filtering on NULL returns
ReadFailure exception
Kishan Karunaratne created CASSANDRA-10715:
----------------------------------------------
Summary: Filtering on NULL returns ReadFailure exception
Key: CASSANDRA-10715
URL: https://issues.apache.org/jira/browse/CASSANDRA-10715
Project: Cassandra
Issue Type: Bug
Environment: C* 3.0.0 | cqlsh | C# driver 3.0.0beta2
Reporter: Kishan Karunaratne
This is an issue I first noticed through the C# driver, but I was able to repro on cqlsh, leading me to believe this is a Cassandra bug.
Given the following schema:
{noformat}
CREATE TABLE "TestKeySpace_4928dc892922"."coolMovies" (
unique_movie_title text,
movie_maker text,
director text,
list list<text>,
"mainGuy" text,
"yearMade" int,
PRIMARY KEY ((unique_movie_title, movie_maker), director)
) WITH CLUSTERING ORDER BY (director ASC)
{noformat}
Executing a SELECT with FILTERING on a non-PK column, using a NULL as the argument:
{noformat}
SELECT "mainGuy", "movie_maker", "unique_movie_title", "list", "director", "yearMade" FROM "coolMovies" WHERE "mainGuy" = null ALLOW FILTERING
{noformat}
returns a ReadFailure exception:
{noformat}
cqlsh:TestKeySpace_4c8f2cf8d5cc> SELECT "mainGuy", "movie_maker", "unique_movie_title", "list", "director", "yearMade" FROM "coolMovies" WHERE "mainGuy" = null ALLOW FILTERING;
←[0;1;31mTraceback (most recent call last):
File "C:\Users\Kishan\.ccm\repository\3.0.0\bin\\cqlsh.py", line 1216, in perform_simple_statement
result = future.result()
File "C:\Users\Kishan\.ccm\repository\3.0.0\bin\..\lib\cassandra-driver-internal-only-3.0.0a3.post0-3f15725.zip\cassandra-driver-3.0.0a3.post0-3f15725\cassandra\cluster.py", line 3118, in result
raise self._final_exception
ReadFailure: code=1300 [Replica(s) failed to execute read] message="Operation failed - received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 'cons
istency': 'ONE'}
←[0m
{noformat}
In C* < 3.0.0 (such as 2.2.3), this same query correctly returns:
{noformat}
cqlsh:TestKeySpace_3231cd551e49> SELECT "mainGuy", "movie_maker", "unique_movie_title", "list", "director", "yearMade" FROM "coolMovies" WHERE "mainGuy" = null ALLOW FILTERING;
←[0;1;31mInvalidRequest: code=2200 [Invalid query] message="Unsupported null value for indexed column mainGuy"←[0m
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)