cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nimi Wariboko Jr <n...@channelmeter.com>
Subject IF NOT EXISTS with multiple static columns confusion
Date Wed, 24 Feb 2016 00:15:40 GMT
I have a table with 2 static columns, and I write to either one of them, if
I then write to the other one using IF NOT EXISTS, it fails even though it
has never been written too before. Is it the case that all static columns
share the same "written too" marker?

Given a table like so:

CREATE TABLE test (
  id timeuuid,
  foo int static,
  bar int static,
  baz int,
  baq int
  PRIMARY KEY (id, baz)
)

I'm seeing some confusing behavior see the statements below -

"""
INSERT INTO cmpayments.report_payments (id, foo) VALUES (NOW(), 1) IF NOT
EXISTS; // succeeds
TRUNCATE test;
INSERT INTO cmpayments.report_payments (id, baq) VALUES
(99c30000-b01a-11e5-b170-0242ac110002, 1);
UPDATE cmpayments.report_payments SET foo = 1 WHERE
id=99c30000-b01a-11e5-b170-0242ac110002 IF foo=null; // fails, even though
foo=null
TRUNCATE test;
INSERT INTO cmpayments.report_payments (id, bar) VALUES
(99c30000-b01a-11e5-b170-0242ac110002, 1); // succeeds
INSERT INTO cmpayments.report_payments (id, foo) VALUES (NOW(), 1) IF NOT
EXISTS; // fails, even though foo=null, and has never been written too
"""

Nimi

Mime
View raw message