[
https://issues.apache.org/jira/browse/CASSANDRA-4776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13471630#comment-13471630
]
Jonathan Ellis commented on CASSANDRA-4776:
-------------------------------------------
# it sounds like you're complaining that the server uses single quotes to
denote the input it couldn't parse. that sounds completely unreleated to how
keywords must be quoted, and a non-problem.
# open to making true/false not require quoting but if it's a pita i'm also
fine with leaving this alone
> Inconsistent use of quotes for CQL 3 reserved words
> ---------------------------------------------------
>
> Key: CASSANDRA-4776
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4776
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 1.1.5
> Environment: Mac OS X, Fedora 16
> Reporter: John Sanda
> Assignee: Aleksey Yeschenko
> Priority: Minor
>
> The docs at http://cassandra.apache.org/doc/cql3/CQL.html#identifiers
> describe using double quotes for an identifier that is a reserved word. The
> following works as expected,
> cqlsh:test> select "columnfamily" from system.schema_columnfamilies;
> I have a table with a boolean column. In order to insert a boolean value, I
> have to enclose it in single quotes. The table looks like,
> CREATE TABLE bool_test (
> id int PRIMARY KEY,
> val boolean
> );
> Here is what happens when I try using double quotes,
> cqlsh:rhq> insert into bool_test (id, val) values (4, "false");
> Bad Request: line 1:43 no viable alternative at input 'false'
> The use of single quotes here seems inconsistent with what is described in
> the docs, and makes things a bit confusing. It would be nice if single or
> double quotes could be used for identifiers that are reserved words. I also
> think it is a bit counter-intuitive to require quotes for true and false
> which are literal values.
--
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
