You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Vladimir Prudnikov <v....@gmail.com> on 2014/01/13 18:56:55 UTC

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 set<text>,
) WITH caching='all';

INSERT INTO user(key,username,email,first_name,last_name,features) VALUES
(now(),'ainsttp0ess2kiphu2pe1bbrle','
l3b7brn6jp9e8s0mmsr7ae55t4@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.

Posted by Vladimir Prudnikov <v....@gmail.com>.
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 <ro...@visa.com> wrote:

>  Validimir,
>
> Thanks what version of Cassandra?
>
> -Roger
>
>
>
>
>
> *From:* Vladimir Prudnikov [mailto:v.prudnikov@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 set<text>,
>
> ) WITH caching='all';
>
>
>
> INSERT INTO user(key,username,email,first_name,last_name,features) VALUES
> (now(),'ainsttp0ess2kiphu2pe1bbrle','
> l3b7brn6jp9e8s0mmsr7ae55t4@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

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

Posted by "Huang, Roger" <ro...@visa.com>.
Validimir,
Thanks what version of Cassandra?
-Roger


From: Vladimir Prudnikov [mailto:v.prudnikov@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 set<text>,
) WITH caching='all';

INSERT INTO user(key,username,email,first_name,last_name,features) VALUES (now(),'ainsttp0ess2kiphu2pe1bbrle','l3b7brn6jp9e8s0mmsr7ae55t4@mmcm4jf9a9g9b95c053ksbsi18.com<ma...@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