You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Benedict Elliott Smith (Jira)" <ji...@apache.org> on 2022/07/20 16:27:00 UTC
[jira] [Comment Edited] (CASSANDRA-17762) LWT IF col = NULL is inconsistent with SQL NULL
[ https://issues.apache.org/jira/browse/CASSANDRA-17762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17569105#comment-17569105 ]
Benedict Elliott Smith edited comment on CASSANDRA-17762 at 7/20/22 4:26 PM:
-----------------------------------------------------------------------------
I agree this is an issue, but not sure how best to resolve it. Since we're introducing new transaction syntax that will eventually likely deprecate this syntax, it might be easier to leave this as-is and resolve it in the new syntax [~bdeggleston] is cooking up?
Does this also affect {{WHERE}} clauses that use filtering? If so, we probably need a broader solution than that.
was (Author: benedict):
I agree this is an issue, but not sure how best to resolve it. Since we're introducing new transaction syntax that will eventually likely deprecate this syntax, it might be easier to leave this as-is and resolve it in the new syntax [~bdeggleston] is cooking up?
> 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
> Priority: Normal
> Fix For: 4.x
>
>
> 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