Cassandra
  1. Cassandra
  2. CASSANDRA-4910

CQL3 doesn't allow static CF definition with compact storage in C* 1.1

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Fix Version/s: 1.1.7
    • Component/s: None
    • Labels:
      None

      Description

      In Cassandra 1.1, the following CQL3 definition:

      CREATE TABLE user_profiles (
          user_id text PRIMARY KEY,
          first_name text,
          last_name text,
          year_of_birth int
      ) WITH COMPACT STORAGE;
      

      yields:

      Bad Request: COMPACT STORAGE requires at least one column part of the clustering key, none found
      

      This works fine in 1.2 however.

      1. 4910.txt
        2 kB
        Sylvain Lebresne

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Patch Available Patch Available
        45m 22s 1 Sylvain Lebresne 05/Nov/12 09:16
        Patch Available Patch Available Resolved Resolved
        1d 5h 5m 1 Sylvain Lebresne 06/Nov/12 14:21
        Gavin made changes -
        Workflow patch-available, re-open possible [ 12753662 ] reopen-resolved, no closed status, patch-avail, testing [ 12757660 ]
        Gavin made changes -
        Workflow no-reopen-closed, patch-avail [ 12732674 ] patch-available, re-open possible [ 12753662 ]
        Sylvain Lebresne made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Reviewer jbellis
        Resolution Fixed [ 1 ]
        Hide
        Sylvain Lebresne added a comment -

        Committed, thanks

        Show
        Sylvain Lebresne added a comment - Committed, thanks
        Hide
        Jonathan Ellis added a comment -

        +1

        Show
        Jonathan Ellis added a comment - +1
        Sylvain Lebresne made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Sylvain Lebresne made changes -
        Field Original Value New Value
        Attachment 4910.txt [ 12552078 ]
        Hide
        Sylvain Lebresne added a comment -

        Simple fix attached (not sure why we've refused that in the first place).

        Show
        Sylvain Lebresne added a comment - Simple fix attached (not sure why we've refused that in the first place).
        Sylvain Lebresne created issue -

          People

          • Assignee:
            Sylvain Lebresne
            Reporter:
            Sylvain Lebresne
            Reviewer:
            Jonathan Ellis
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development