Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Sat, 17 Nov 2012 17:32:12 +0000 (UTC)
From: "Jonathan Ellis (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <529829971.127798.1353173532392.JavaMail.jiratomcat@arcas>
In-Reply-To: <1923201126.125711.1353100872314.JavaMail.jiratomcat@arcas>
Subject: [jira] [Commented] (CASSANDRA-4968) CQL3 Descrepancies
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-4968?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13499472#comment-13499472 ] 

Jonathan Ellis commented on CASSANDRA-4968:
-------------------------------------------

ORDER BY change is a bug fix.  leaving classtype implicit implies to SQL users that kt is the primary ordering/clustering which is incorrect.

Ninja-fixed compaction_strategy in 2806dedd9c412d3be6ae6979a86b155497284263.

Created CASSANDRA-4970 to deal with cqlsh bug.
                
> CQL3 Descrepancies
> ------------------
>
>                 Key: CASSANDRA-4968
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4968
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 1.2.0 beta 2
>            Reporter: T Jake Luciani
>            Priority: Minor
>             Fix For: 1.2.0 rc1
>
>
> I upgraded an environment from 1.1.6 to 1.2 beta
> We found the following differences between cql3 versions:
> The CLUSTERING ORDER BY requires all columns be specified in 1.2 whereas 1.1 defaulted to ASC
> {code}
> CREATE TABLE table1(
>    col1 text,
>    classtype ascii,
>    kt bigint,
>    id uuid,
>    PRIMARY KEY (col1,classtype,kt)
> ) WITH COMPACT STORAGE
> AND CLUSTERING ORDER BY(classtype ASC, kt DESC)
> {code}
> 1.1 didn't require classtype in the ORDER BY, 1.2 does.
> ----------
> In docs/cql3.textile there is mention of 'compaction_strategy' CREATE option but the actual option is 'compaction'
> ----------
> cqlsh for some reason renders all bytes fields as strings in 1.2 whereas in 1.1 they were hex.

--
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