incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pierre Chalamet" <pie...@chalamet.net>
Subject RE: Cassandra 1.2
Date Sat, 05 Jan 2013 16:16:04 GMT
Hello,

Removing the extra parenthesis around the primary key definition seems to
work as expected:
CREATE TABLE foo2 (a int, b text, c uuid,   PRIMARY KEY (a, b) );
INSERT INTO foo2 (a, b , c ) VALUES (  1 , 'aze',
'4d481800-4c5f-11e1-82e0-3f484de45426');
INSERT INTO foo2 (a, b , c ) VALUES (  1 , 'ert',
'693f5800-8acb-11e3-82e0-3f484de45426');
INSERT INTO foo2 (a, b , c ) VALUES (  1 , 'opl',
'd4815800-2d8d-11e0-82e0-3f484de45426');

localhost> select * from foo where a=1;
+---+-----+--------------------------------------+
| a | b   | c                                    |
+===+=====+======================================+
| 1 | ert | 693f5800-8acb-11e3-82e0-3f484de45426 |
+---+-----+--------------------------------------+
| 1 | opl | d4815800-2d8d-11e0-82e0-3f484de45426 |
+---+-----+--------------------------------------+

localhost> select * from foo2 where a=1;
+---+-----+--------------------------------------+
| a | b   | c                                    |
+===+=====+======================================+
| 1 | aze | 4d481800-4c5f-11e1-82e0-3f484de45426 |
+---+-----+--------------------------------------+
| 1 | ert | 693f5800-8acb-11e3-82e0-3f484de45426 |
+---+-----+--------------------------------------+
| 1 | opl | d4815800-2d8d-11e0-82e0-3f484de45426 |
+---+-----+--------------------------------------+

Looks like there is something weird happening when creating the table.

- Pierre

-----Original Message-----
From: Kais Ahmed [mailto:kais@neteck-fr.com] 
Sent: Saturday, January 05, 2013 2:30 PM
To: dev@cassandra.apache.org
Subject: Cassandra 1.2

Hi all,

I create a table in cassandra 1.2, and makes two queries, the second query
gives me a false result, is this normal behavior?


----------------------------------------------------------------------------
------------------------------------------
[cqlsh 2.3.0 | Cassandra 1.2.0-SNAPSHOT | CQL spec 3.0.0 | Thrift protocol
19.35.0]

cqlsh:test> CREATE TABLE foo (   a int,   b text,   c uuid,   PRIMARY KEY
((a, b)) );

cqlsh:test> INSERT INTO foo (a, b , c ) VALUES (  1 , 'aze',
'4d481800-4c5f-11e1-82e0-3f484de45426');
cqlsh:test> INSERT INTO foo (a, b , c ) VALUES (  1 , 'ert',
'693f5800-8acb-11e3-82e0-3f484de45426');
cqlsh:test> INSERT INTO foo (a, b , c ) VALUES (  1 , 'opl',
'd4815800-2d8d-11e0-82e0-3f484de45426');

----------------------------------------------------------------------------
-------------------------------------------------------------------------

cqlsh:test> SELECT * FROM foo;

 a | b   | c
---+-----+--------------------------------------
 1 | ert | 693f5800-8acb-11e3-82e0-3f484de45426
 1 | opl | d4815800-2d8d-11e0-82e0-3f484de45426
 1 | aze | 4d481800-4c5f-11e1-82e0-3f484de45426

----------------------------------------------------------------------------
-------------------------------------------------------------------------

cqlsh:test> SELECT * FROM foo where a=1;

 a | b   | c
---+-----+--------------------------------------
 1 | ert | 693f5800-8acb-11e3-82e0-3f484de45426
 1 | opl | d4815800-2d8d-11e0-82e0-3f484de45426


Mime
View raw message