You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jonathan Ellis (JIRA)" <ji...@apache.org> on 2013/01/07 16:44:13 UTC
[jira] [Commented] (CASSANDRA-5122) Select on composite partition
keys are not validated correctly
[ https://issues.apache.org/jira/browse/CASSANDRA-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13545968#comment-13545968 ]
Jonathan Ellis commented on CASSANDRA-5122:
-------------------------------------------
+1
> Select on composite partition keys are not validated correctly
> --------------------------------------------------------------
>
> Key: CASSANDRA-5122
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5122
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.2.0
> Reporter: Sylvain Lebresne
> Assignee: Sylvain Lebresne
> Priority: Minor
> Fix For: 1.2.1
>
> Attachments: 5122.txt
>
>
> From Kais Ahmed on the mailing list:
> {noformat}
> ----------------------------------------------------------------------------------------------------------------------
> [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
> {noformat}
> The last request should be invalid (since we don't have a good way to do it, at least not with a random partitioner).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira