You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@cassandra.apache.org by "Avi Kivity (Jira)" <ji...@apache.org> on 2022/07/20 12:10:00 UTC

[jira] [Created] (CASSANDRA-17762) LWT IF col = NULL is inconsistent with SQL NULL

Avi Kivity created CASSANDRA-17762:
--------------------------------------

             Summary: LWT IF col = NULL is inconsistent with SQL NULL
                 Key: CASSANDRA-17762
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-17762
             Project: Cassandra
          Issue Type: Bug
          Components: CQL/Semantics
            Reporter: Avi Kivity


In SQL, any comparison with NULL is NULL, which is interpreted as FALSE in a condition. To test for NULLness, you use IS NULL or IS NOT NULL.

But LWT uses IF col = NULL as a NULLness test. This is likely to confuse people coming from SQL and hamper attempts to extend the dialect.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org