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 <bur...@spinn3r.com> 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> > >