RE: Problem inserting set when query contains IF NOT EXISTS.

2014-01-13 Thread Huang, Roger 
Validimir,
Thanks what version of Cassandra?
-Roger


From: Vladimir Prudnikov [mailto:v.prudni...@gmail.com]
Sent: Monday, January 13, 2014 11:57 AM
To: user
Subject: Problem inserting set when query contains IF NOT EXISTS.

Hi all,
I've spend a lot of time finding a bug in system, but it turns out that the 
problem is in Cassandra.

Here is how to reproduce.

=
CREATE KEYSPACE IF NOT EXISTS test_set WITH REPLICATION = { 'class' : 
'SimpleStrategy', 'replication_factor' : 1 };
USE test_set;

CREATE TABLE IF NOT EXISTS user (
key timeuuid PRIMARY KEY,
username text,
email text,
first_name text,
last_name text,
features settext,
) WITH caching='all';

INSERT INTO user(key,username,email,first_name,last_name,features) VALUES 
(now(),'ainsttp0ess2kiphu2pe1bbrle','l3b7brn6jp9e8s0mmsr7ae5...@mmcm4jf9a9g9b95c053ksbsi18.commailto:l3b7brn6jp9e8s0mmsr7ae5...@mmcm4jf9a9g9b95c053ksbsi18.com','gqh9ekmv6vc9nf1ce8eo3rjcdd','fmg92158br9ddivoj59417q514',{'i6v8i4a5gpnris5chjibllqf0','480m4c1obiq61ilii1g7rm0v17','50kovlifrtrtqihnvmbefaeacl'})
 IF NOT EXISTS;

select * from user;
==

The problem here is that user.features is null instead of set of 3 strings.
If you remove `IF NOT EXISTS` it executes correctly and set of string will be 
inserted.

I don't see any problem with the queries, seems to be the problem with C*.

--
Vladimir Prudnikov

Re: Problem inserting set when query contains IF NOT EXISTS.

2014-01-13 Thread Vladimir Prudnikov 
Sorry, I thought I was running the latest version, but it was on this
instance...

[cqlsh 4.1.0 | Cassandra 2.0.1-SNAPSHOT | CQL spec 3.1.1 | Thrift protocol
19.37.0]

I tried with 2.0.4 and it works just fine.


On Mon, Jan 13, 2014 at 9:07 PM, Huang, Roger rohu...@visa.com wrote:

  Validimir,

 Thanks what version of Cassandra?

 -Roger





 *From:* Vladimir Prudnikov [mailto:v.prudni...@gmail.com]
 *Sent:* Monday, January 13, 2014 11:57 AM
 *To:* user
 *Subject:* Problem inserting set when query contains IF NOT EXISTS.



 Hi all,

 I've spend a lot of time finding a bug in system, but it turns out that
 the problem is in Cassandra.



 Here is how to reproduce.



 =

 CREATE KEYSPACE IF NOT EXISTS test_set WITH REPLICATION = { 'class' :
 'SimpleStrategy', 'replication_factor' : 1 };

 USE test_set;



 CREATE TABLE IF NOT EXISTS user (

 key timeuuid PRIMARY KEY,

 username text,

 email text,

 first_name text,

 last_name text,

 features settext,

 ) WITH caching='all';



 INSERT INTO user(key,username,email,first_name,last_name,features) VALUES
 (now(),'ainsttp0ess2kiphu2pe1bbrle','
 l3b7brn6jp9e8s0mmsr7ae5...@mmcm4jf9a9g9b95c053ksbsi18.com','gqh9ekmv6vc9nf1ce8eo3rjcdd','fmg92158br9ddivoj59417q514',{'i6v8i4a5gpnris5chjibllqf0','480m4c1obiq61ilii1g7rm0v17','50kovlifrtrtqihnvmbefaeacl'})
 IF NOT EXISTS;



 select * from user;

 ==



 The problem here is that user.features is null instead of set of 3 strings.

 If you remove `IF NOT EXISTS` it executes correctly and set of string will
 be inserted.



 I don't see any problem with the queries, seems to be the problem with C*.



 --
 Vladimir Prudnikov




-- 
Vladimir Prudnikov