Jonathan Ellis created CASSANDRA-4955:
-----------------------------------------

             Summary: some confusion around KEY pseudocolumn from Thrift tables
                 Key: CASSANDRA-4955
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4955
             Project: Cassandra
          Issue Type: Bug
            Reporter: Jonathan Ellis
            Assignee: Aleksey Yeschenko
            Priority: Minor
             Fix For: 1.2.0


Inserting into the schema created by cassandra-stress.  cqlsh {{DESCRIBE 
TABLE}} says

{code}
CREATE TABLE "Standard1" (
  "KEY" blob PRIMARY KEY,
  "C0" blob,
  "C1" blob,
  "C2" blob,
  "C3" blob,
  "C4" blob
) WITH COMPACT STORAGE AND
  comment='' AND
  caching='KEYS_ONLY' AND
  read_repair_chance=0.100000 AND
  dclocal_read_repair_chance=0.000000 AND
  gc_grace_seconds=864000 AND
  replicate_on_write='true';
{code}

but that casing doesn't actually work:

{noformat}
cqlsh:Keyspace1> insert into "Standard1" ("KEY", "C0", "C1", "C2", "C3", "C4") 
values ('FF', '00', '11', '22', '33', '44');
Bad Request: Unknown identifier KEY
{noformat}

lowercase does work:

{noformat}
cqlsh:Keyspace1> insert into "Standard1" ("key", "C0", "C1", "C2", "C3", "C4") 
values ('FF', '00', '11', '22', '33', '44');
{noformat}


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

Reply via email to