Re: Inconsistent null handling between WHERE and IF clauses

2025-03-25 Thread Benedict
The transaction syntax is sufficiently different it’s perhaps ok to define our null behaviour differently. Perhaps eventually deprecating LWTs can be our migration story for consistent null handling, if it’s the only place that treats nulls this way today. We should clearly document this though

Re: Inconsistent null handling between WHERE and IF clauses

2025-03-25 Thread David Capwell
SAI does not support null either. One main motivation for this thread is for accords IF clause; should it act more like where or CAS IF? I’m of the stance it would be hard to reject null as we might not know it’s null till we do and LET clause, so null in operation becomes false is my stance S

Inconsistent null handling between WHERE and IF clauses

2025-03-25 Thread David Capwell
In fuzz testing I have found some differences between `WHERE` and `IF` clauses that want to get feedback from the broader community. If you try to query with a `null` we will reject it ``` @Test public void test() throws IOException { try (Cluster cluster = Cluster.build(1).start())