cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From slebre...@apache.org
Subject git commit: CQL3 documentation fixes (#5878)
Date Wed, 21 Aug 2013 10:15:31 GMT
Updated Branches:
  refs/heads/cassandra-1.2 08d22df07 -> 55fed339c


CQL3 documentation fixes (#5878)


Project: http://git-wip-us.apache.org/repos/asf/cassandra/repo
Commit: http://git-wip-us.apache.org/repos/asf/cassandra/commit/55fed339
Tree: http://git-wip-us.apache.org/repos/asf/cassandra/tree/55fed339
Diff: http://git-wip-us.apache.org/repos/asf/cassandra/diff/55fed339

Branch: refs/heads/cassandra-1.2
Commit: 55fed339cb4243634b062927cb060044aba32b59
Parents: 08d22df
Author: Sylvain Lebresne <sylvain@datastax.com>
Authored: Wed Aug 21 12:15:14 2013 +0200
Committer: Sylvain Lebresne <sylvain@datastax.com>
Committed: Wed Aug 21 12:15:14 2013 +0200

----------------------------------------------------------------------
 doc/cql3/CQL.textile | 24 +++++++++++++++---------
 1 file changed, 15 insertions(+), 9 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cassandra/blob/55fed339/doc/cql3/CQL.textile
----------------------------------------------------------------------
diff --git a/doc/cql3/CQL.textile b/doc/cql3/CQL.textile
index 22248ef..bb9a632 100644
--- a/doc/cql3/CQL.textile
+++ b/doc/cql3/CQL.textile
@@ -468,8 +468,10 @@ bc(syntax)..
                | <identifier> '=' <identifier> '+' <map-literal>
                | <identifier> '[' <term> ']' '=' <term>
 
-<where-clause> ::= <identifier> '=' <term>
-                 | <identifier> IN '(' ( <term> ( ',' <term> )* )? ')'
+<where-clause> ::= <relation> ( AND <relation> )*
+
+<relation> ::= <identifier> '=' <term>
+             | <identifier> IN '(' ( <term> ( ',' <term> )* )? ')'
 
 <option> ::= TIMESTAMP <integer>
            | TTL <integer>
@@ -485,7 +487,7 @@ WHERE movie = 'Serenity';
 
 UPDATE UserActions SET total = total + 2 WHERE user = B70DE1D0-9908-4AE3-BE34-5573E5B09F14
AND action = 'click';
 p. 
-The @UPDATE@ statement writes one or more columns for a given row in a table. The @<where-clause>@
is used to select the row to update and must include all columns composing the @PRIMARY KEY@.
Other columns values are specified through @<assignment>@ after the @SET@ keyword.
+The @UPDATE@ statement writes one or more columns for a given row in a table. The @<where-clause>@
is used to select the row to update and must include all columns composing the @PRIMARY KEY@
(the @IN@ relation is only supported for the last column of the partition key). Other columns
values are specified through @<assignment>@ after the @SET@ keyword.
 
 Note that unlike in SQL, @UPDATE@ does not check the prior existence of the row: the row
is created if none existed before, and updated otherwise. Furthermore, there is no mean to
know which of creation or update happened. In fact, the semantic of @INSERT@ and @UPDATE@
are identical.
 
@@ -514,8 +516,10 @@ bc(syntax)..
 
 <selection> ::= <identifier> ( '[' <term> ']' )?
 
-<where-clause> ::= <identifier> '=' <term>
-                 | <identifier> IN '(' ( <term> ( ',' <term> )* )? ')'
+<where-clause> ::= <relation> ( AND <relation> )*
+
+<relation> ::= <identifier> '=' <term>
+             | <identifier> IN '(' ( <term> ( ',' <term> )* )? ')'
 p. 
 __Sample:__
 
@@ -524,7 +528,7 @@ DELETE FROM NerdMovies USING TIMESTAMP 1240003134 WHERE movie = 'Serenity';
 
 DELETE phone FROM Users WHERE userid IN (C73DE1D3-AF08-40F3-B124-3FF3E5109F22, B70DE1D0-9908-4AE3-BE34-5573E5B09F14);
 p. 
-The @DELETE@ statement deletes columns and rows. If column names are provided directly after
the @DELETE@ keyword, only those columns are deleted from the row indicated by the @<where-clause>@
(the @id[value]@ syntax in @<selection>@ is for collection, please refer to the "collection
section":#collections for more details).  Otherwise whole rows are removed. The @<where-clause>@
allows to specify the key for the row(s) to delete.
+The @DELETE@ statement deletes columns and rows. If column names are provided directly after
the @DELETE@ keyword, only those columns are deleted from the row indicated by the @<where-clause>@
(the @id[value]@ syntax in @<selection>@ is for collection, please refer to the "collection
section":#collections for more details).  Otherwise whole rows are removed. The @<where-clause>@
allows to specify the key for the row(s) to delete (the @IN@ relation is only supported for
the last column of the partition key).
 
 @DELETE@ supports the @TIMESTAMP@ options with the same semantic that in the "@UPDATE@":#updateStmt
statement.
 
@@ -594,11 +598,11 @@ bc(syntax)..
              | TTL '(' <identifier> ')'
              | <function> '(' (<selector> (',' <selector>)*)? ')'
 
-<where-clause> ::= <relation> ( "AND" <relation> )*
+<where-clause> ::= <relation> ( AND <relation> )*
 
-<relation> ::= <identifier> ("=" | "<" | ">" | "<=" | ">=") <term>
+<relation> ::= <identifier> ('=' | '<' | '>' | '<=' | '>=') <term>
              | <identifier> IN '(' ( <term> ( ',' <term>)* )? ')'
-             | TOKEN '(' <identifier> ')' ("=" | "<" | ">" | "<=" | ">=")
(<term> | TOKEN '( <term> ')' )
+             | TOKEN '(' <identifier> ')' ('=' | '<' | '>' | '<=' | '>=')
(<term> | TOKEN '(' <term> ')' )
 
 <order-by> ::= <ordering> ( ',' <odering> )*
 <ordering> ::= <identifer> ( ASC | DESC )?
@@ -659,6 +663,8 @@ When specifying relations, the @TOKEN@ function can be used on the @PARTITION
KE
 bc(sample). 
 SELECT * FROM posts WHERE token(userid) > token('tom') AND token(userid) < token('bob')
 
+Moreover, the @IN@ relation is only allowed on the last column of the partition key and on
the last column of the full primary key.
+
 h4(#selectOrderBy). @<order-by>@
 
 The @ORDER BY@ option allows to select the order of the returned results. It takes as argument
a list of column names along with the order for the column (@ASC@ for ascendant and @DESC@
for descendant, omitting the order being equivalent to @ASC@). Currently the possible orderings
are limited (which depends on the table "@CLUSTERING ORDER@":#createTableOptions):


Mime
View raw message