Updated Branches: refs/heads/cassandra-2.0 2e0279f89 -> c4f6be8c4
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-2.0 Commit: 55fed339cb4243634b062927cb060044aba32b59 Parents: 08d22df Author: Sylvain Lebresne <sylv...@datastax.com> Authored: Wed Aug 21 12:15:14 2013 +0200 Committer: Sylvain Lebresne <sylv...@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):