Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-17762

LWT IF col = NULL is inconsistent with SQL NULL

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Normal
    • Resolution: Unresolved
    • 5.x
    • CQL/Semantics
    • 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

          Activity

            People

              Unassigned Unassigned
              avi.kivity Avi Kivity
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: