[ https://issues.apache.org/jira/browse/CASSANDRA-3036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13086673#comment-13086673 ]
Hudson commented on CASSANDRA-3036: ----------------------------------- Integrated in Cassandra-0.8 #284 (See [https://builds.apache.org/job/Cassandra-0.8/284/]) Validate that column names in column_metadata does not equal to key_alias on create/update of the ColumnFamily and CQL 'ALTER' statement. patch by Pavel Yaskevich; reviewed by Jonathan Ellis for CASSANDRA-3036 xedin : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1158939 Files : * /cassandra/branches/cassandra-0.8/test/system/test_cql.py * /cassandra/branches/cassandra-0.8/test/unit/org/apache/cassandra/thrift/ThriftValidationTest.java * /cassandra/branches/cassandra-0.8/CHANGES.txt * /cassandra/branches/cassandra-0.8/src/java/org/apache/cassandra/thrift/ThriftValidation.java * /cassandra/branches/cassandra-0.8/src/java/org/apache/cassandra/cql/CreateColumnFamilyStatement.java * /cassandra/branches/cassandra-0.8/src/java/org/apache/cassandra/cql/QueryProcessor.java * /cassandra/branches/cassandra-0.8/src/java/org/apache/cassandra/cql/AlterTableStatement.java > Vague primary key references in CQL > ----------------------------------- > > Key: CASSANDRA-3036 > URL: https://issues.apache.org/jira/browse/CASSANDRA-3036 > Project: Cassandra > Issue Type: Bug > Components: API > Affects Versions: 0.8.1 > Reporter: Kelley Reynolds > Assignee: Pavel Yaskevich > Priority: Minor > Labels: core, cql > Fix For: 0.8.5 > > Attachments: CASSANDRA-3036-v2.patch, CASSANDRA-3036.patch > > > create columnfamily wonk (id 'utf8' primary key, id int) > update wonk set id=1 where id='test' > create index wonk_id on wonk (id) > This does what you would expect but then the results are unclear when using > 'id' in a where clause. > "select * from wonk where id=1" returns nothing and "select * from wonk where > id='test'" works fine. > Perhaps secondary indexes should not be allowed on columns that have the same > name as the key_alias? At least a warning or something should be thrown to > indicate you've just made a useless index. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira