[CASSANDRA-10161] Composite case-sensitive primary key: first item is not quoted in DESCRIBE TABLE

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.1.11
• Component/s: Legacy/Tools
• Labels: cqlsh
• Severity: Low
• Assignee: Carl Yeksigian
• Reporter: Julien Moreau

Authors

Carl Yeksigian

Reviewers

T Jake Luciani

• Created: 24/Aug/15 10:21
• Updated: 16/Apr/19 09:30
• Resolved: 07/Oct/15 14:16

Description

A table is created with case-sensitive composite primary key:

CREATE TABLE foo (
 "Key1" text,
 "Key2" text,
 "Value" text
 PRIMARY KEY ("Key1", "Key2")
);

In the result of DESCRIBE TABLE foo;:

CREATE TABLE foo (
 "Key1" text,
 "Key2" text,
 "Value" text
 PRIMARY KEY (Key1, "Key2")
);

Key1 is not quoted.
When trying to re-create the table with this description, there is an error:

InvalidRequest: code=2200 [Invalid query] message="Unknown definition key1 referenced in PRIMARY KEY"