[ 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)