[jira] [Commented] (CASSANDRA-6055) 'Bad Request: Invalid null value for partition key part' on SELECT .. WHERE key IN (val,NULL)

["Roman Skvazh (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-6055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13787994#comment-13787994 ] 

Roman Skvazh commented on CASSANDRA-6055:
-----------------------------------------

I agree with Sylvain Lebresne. CQL is not SQL and there is no need for this "hack" (ignore NULL values in queries).

> 'Bad Request: Invalid null value for partition key part' on SELECT .. WHERE key IN (val,NULL)
> ---------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6055
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6055
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: cqlsh, pdo_cassandra
>            Reporter: Sergey Nagaytsev
>            Priority: Minor
>              Labels: cql3
>
> Query: SELECT * FROM user WHERE key IN(uuid,NULL);
> Table:
> CREATE COLUMNFAMILY user (
>      KEY uuid PRIMARY KEY,
>      name text,
>      note text,
>      avatar text,
>      email text,
>      phone text,
>      login text,
>      pw text,
>      st text
> );
> Logs: Nothing, last message hours ago.
> This query is good in SQL and so is generated by DB abstraction library. Fix on applications sides is multiplying of work.



--
This message was sent by Atlassian JIRA
(v6.1#6144)