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

["Sergey Nagaytsev (JIRA)" <ji...@apache.org>]

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

Sergey Nagaytsev commented on CASSANDRA-6055:
---------------------------------------------

> This is irrelevant, CQL is not SQL

No, i disagree, this point is against the very purpose of creating textual language similar to existing one.

Compatibility and interoperability is the key. I use PHP Yii2 framework together with it's DB abstraction, and i HAVE ONLY LIMITED CONTROL over SQL it produces, and to change the SQL i must either subclass or patch it. Now think of the same situation over cartesian product of sets of languages, frameworks and DBAL's ! And what if the DBAL is closed-source ?

For now, Yii2 DBAL works with Cassandra near perfect thanks to language similarity, except for some bugs i do file.

So increasing similarity of CQL to SQL will be for good of everyone - less reworking in all DBAL's and frameworks, more argument points to use Cassandra.

Please, re-open the bug, even with far milestone !
                
> '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
>              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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira