You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Justen Walker (JIRA)" <ji...@apache.org> on 2013/01/15 20:50:12 UTC

[jira] [Resolved] (CASSANDRA-5163) cqlsh: INSERT with quoted identifiers result in parse errors.

     [ https://issues.apache.org/jira/browse/CASSANDRA-5163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Justen Walker resolved CASSANDRA-5163.
--------------------------------------

    Resolution: Invalid

Its expected.  CF Create should defined column metadata to be able to use it in insert statements.
                
> cqlsh: INSERT with quoted identifiers result in parse errors.
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-5163
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5163
>             Project: Cassandra
>          Issue Type: Bug
>    Affects Versions: 1.1.8
>         Environment: Ubuntu 12.04.1 x64, Cassandra 1.1.8 x64, Java 1.6
>            Reporter: Justen Walker
>
> Setup Schema:
> {code}
> CREATE KEYSPACE "TestKeyspace" WITH strategy_class = 'SimpleStrategy'
>   AND strategy_options:replication_factor = '1';
> USE "TestKeyspace";
> CREATE TABLE "Identity" (
>   "KEY" text PRIMARY KEY
> ) WITH
>   comment='' AND
>   caching='KEYS_ONLY' AND
>   read_repair_chance=1.000000 AND
>   gc_grace_seconds=864000 AND
>   replicate_on_write='true' AND
>   compaction_strategy_class='SizeTieredCompactionStrategy' AND
>   compression_parameters:sstable_compression='SnappyCompressor';
> {code}
> Repro:
> {code}
> cqlsh> use "TestKeyspace";
> cqlsh:TestKeyspace>  INSERT INTO 'Identity' (KEY,name,type) VALUES ('14e736705f4711e2bcfd0800200c9a66','MyName','MyType');
> Bad Request: line 1:12 no viable alternative at input 'Identity'
> cqlsh:TestKeyspace> INSERT INTO "Identity" (KEY,name,type) VALUES ('14e736705f4711e2bcfd0800200c9a66','MyName','MyType');
> Bad Request: Unknown identifier name
> text could not be lexed at line 1, char 13
> {code}

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