[ https://issues.apache.org/jira/browse/CASSANDRA-6401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13832746#comment-13832746 ]
Jeremiah Jordan commented on CASSANDRA-6401: -------------------------------------------- On case in CQL: http://www.datastax.com/documentation/cql/3.1/webhelp/index.html#cql/cql_reference/cql_lexicon_c.html#reference_ds_b4h_gx5_yj > "Clustering order by" property does not support when the column name is > written in "uppercase" > ----------------------------------------------------------------------------------------------- > > Key: CASSANDRA-6401 > URL: https://issues.apache.org/jira/browse/CASSANDRA-6401 > Project: Cassandra > Issue Type: Bug > Components: Core > Environment: Windows 7 64 bit > Reporter: DIKSHA KUSHWAH > > Database Version : CASSANDRA 2.0.1 > 1. Connect cassandra 2.0.1 and execute following query:- > CREATE TABLE "test"."cat" ( > "cache" text, > "num" int, > PRIMARY KEY("cache","num") > ) WITH > CLUSTERING ORDER BY (num DESC); > 2. Now execute following query:- > > CREATE TABLE "DOG" ( > "CACHE" text, > "NUM" int, > PRIMARY KEY("CACHE","NUM") > ) WITH > CLUSTERING ORDER BY (NUM DESC); > 3. When we create table "cat",it is successfully created but when we create > table "DOG" it gives error "Missing CLUSTERING ORDER for column NUM" because > Table "DOG" column name "NUM" is in upper case and Table "CAT" column name > "num" is in lower case. > 4. Cassandra supports when we create a Table with column names in upper case > without "CLUSTERING ORDER BY " property then it should also support this > property with upper case column names. -- This message was sent by Atlassian JIRA (v6.1#6144)