[ 
https://issues.apache.org/jira/browse/CASSANDRA-2623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13030747#comment-13030747
 ] 

rday edited comment on CASSANDRA-2623 at 5/9/11 3:16 PM:
---------------------------------------------------------

Unforuntately adding double quotes causes insertions of both quotes in to the 
data set,

create keyspace KEYS with
   placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' and
   replication_factor = 1;
use KEYS;

create column family CF with
  comparator=UTF8Type and
  rows_cached=1.0 and
  memtable_throughput=128 and
  min_compaction_threshold=10 and
  column_metadata =
  [
    {column_name:VERSION, validation_class:LongType},
    {column_name:VALUE, validation_class:UTF8Type}
  ];
  
  
  set CF['key''1'][VERSION] = 'aren''t happy' ; 
  set CF['key''1'][VALUE] = 'aren''t happy' ; 

  list CF

RowKey: key''1
=> (column=VALUE, value=aren''t happy, timestamp=1304952103638000)
=> (column=VERSION, value=1, timestamp=1304952057641000)


Through a thrift java client insert we are able to insert and find single quote 
keys,
But if data is inserted via CLI,  the java thrift single quote lookups do not 
match.

      was (Author: rday):
    Unforuntately adding double quotes causes insertions of both quotes in to 
the data set,
Will add an example.


  
> CLI escaped single quote parsing gives errors
> ---------------------------------------------
>
>                 Key: CASSANDRA-2623
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2623
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Tools
>         Environment: windows vista, linux
>            Reporter: rday
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>              Labels: cli
>             Fix For: 0.7.6, 0.8.1
>
>
> Escaping quotes in cli commands causes parsing errors.
> some examples::::
> No need to create columns etc, it doesn't get through parsing the expression::
> cassandra-cli
> 1. 
> set column['KEY+vals'][VALUE] = 'VAL\'' ;
> Syntax error at position 41: mismatched character '<EOF>' expecting '''
> 2.
> set column['KEY+val\'s'][VALUE] = 'VAL' ;
> Syntax error at position 41: mismatched character '<EOF>' expecting '''
> 3.
> set column['KEY+vals\''][VALUE] = 'VAL\'' ;
> Syntax error at position 38: unexpected "\" for `set 
> column['KEY+vals\''][VALUE] = 'VAL\'' ;`.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to