Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-4968

CQL3 Descrepancies

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Low
    • Resolution: Fixed
    • 1.2.0 beta 3
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            tjake T Jake Luciani
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: