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