Details
-
Bug
-
Status: Open
-
Normal
-
Resolution: Unresolved
-
None
-
Correctness
-
Normal
-
Normal
-
User Report
-
All
-
None
Description
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.
Attachments
Issue Links
- is related to
-
CASSANDRA-17719 CEP-15: Multi-Partition Transaction CQL Support (Alpha)
- Resolved
- relates to
-
CASSANDRA-10715 Allow filtering on NULL
- In Progress