Just tested with C* 2.1.1
cqlsh:test> CREATE TABLE simple(id int PRIMARY KEY, val text);
cqlsh:test> INSERT INTO simple (id) VALUES (1);
cqlsh:test> SELECT * FROM simple ;
id | val
----+------
1 | null
(1 rows)
cqlsh:test> UPDATE simple SET val = 'new val' WHERE id=1 *IF val = null*;
[applied]
-----------
True
cqlsh:test> SELECT * FROM simple ;
id | val
----+---------
1 | new val
(1 rows)
On Tue, Nov 18, 2014 at 12:12 AM, Kevin Burton <[email protected]> wrote:
>
> "you can still do IF on UPDATE though… but it’s not possible to do IF
>> mycolumn IS NULL" --> If mycolumn = null should work
>>
>>
> Alas.. it doesn’t :-/
>
> --
>
> Founder/CEO Spinn3r.com
> Location: *San Francisco, CA*
> blog: http://burtonator.wordpress.com
> … or check out my Google+ profile
> <https://plus.google.com/102718274791889610666/posts>
> <http://spinn3r.com>
>
>
