Tested on cassandra 2.0.8:
I did some minor testing on timestamp field. It seems that you can give an
empty string as a value. Honestly I have no clue what should I think of
that. I kind of understand that you can give a string with seconds since
epoch and null of course. But empty string?
cqlsh does not really care but for example beta ruby driver throws a nasty
exception if timestamp contains a value like that. I don't know if it is a
more of a cassandra or datastax ruby driver issue...
Opinions?
Cheers,
Hannu
cqlsh:temperatures> update users set deleted_at='1' where
username='hkroger';
cqlsh:temperatures> select deleted_at from users where username = 'hkroger';
deleted_at
--------------------------
1970-01-01 02:00:00+0200
(1 rows)
cqlsh:temperatures> update users set deleted_at='' where username='hkroger';
cqlsh:temperatures> select deleted_at from users where username = 'hkroger';
deleted_at
------------
(1 rows)
cqlsh:temperatures> update users set deleted_at=null where
username='hkroger';
cqlsh:temperatures> select deleted_at from users where username = 'hkroger';
deleted_at
------------
null
(1 rows)
