Details
-
Bug
-
Status: Resolved
-
Low
-
Resolution: Fixed
-
None
-
None
-
Low
Description
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
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)
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.