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

Reply via email to