cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sanda (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-4776) Inconsistent use of quotes for CQL 3 reserved words
Date Mon, 08 Oct 2012 01:22:03 GMT
John Sanda created CASSANDRA-4776:
-------------------------------------

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

Mime
View raw message