cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Williams (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-2898) Escape characters in CQL
Date Fri, 29 Jul 2011 16:54:09 GMT

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

Brandon Williams commented on CASSANDRA-2898:
---------------------------------------------

I don't see the problem:
{noformat}
cqlsh> create columnfamily foo (KEY text primary key);
cqlsh> update foo set 'fmd:' = 'foo' where key = 'test';
cqlsh> select * from foo where key = 'test';
  KEY | fmd: |
 test |  foo |

cqlsh> 
cqlsh> select 'fmd:' from foo where key = 'test';
 fmd: |
  foo |

cqlsh> update foo set 'fmd;' = 'foo' where key = 'test';
cqlsh> select 'fmd:'..'fmd;' from foo where key = 'test';
 fmd: | fmd; |
  foo |  foo |

cqlsh>
{noformat}

> Escape characters in CQL
> ------------------------
>
>                 Key: CASSANDRA-2898
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2898
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Drivers
>            Reporter: Blake Visin
>            Assignee: Brandon Williams
>              Labels: cql
>
> When trying to get all the columns named "fmd:" in cqlsh you can not escape : or ;
> As per Jonathan Ellis:
> You can escape quotes but I don't think you can escape semicolons.
> Try:
> sqlsh> select 'fmd:'..'fmd;' from feeds;

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

        

Mime
View raw message