Michaël Figuière created CASSANDRA-5878:
-------------------------------------------

             Summary: Fix CQL3 documentation 
                 Key: CASSANDRA-5878
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5878
             Project: Cassandra
          Issue Type: Task
         Environment: Cassandra 2.0rc1
            Reporter: Michaël Figuière
            Priority: Trivial


A couple of fixes are required in the CQL3 documentation:


*{{UPDATE}} and {{DELETE}} statements allow {{AND}} in {{WHERE}} clauses*

{code}
<where-clause> ::= <identifier> '=' <term>
                 | <identifier> IN '(' ( <term> ( ',' <term> )* )? ')'
{code}

should be:

{code}
<where-clause> ::= <relation> ( "AND" <relation> )*

<relation> ::= <identifier> '=' <term>
             | <identifier> IN '(' ( <term> ( ',' <term>)* )? ')'
{code}

*{{UPDATE}} and {{DELETE}} statements support {{IN}} only on the last column of 
the partition key*

The documentation should specify this limitation in the way {{IN}} can be used. 
It's currently explained only in cqlsh.

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

Reply via email to