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: [email protected]
For additional commands, e-mail: [email protected]
