git commit: CQL3 documentation fixes (#5878)
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 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
[1/2] git commit: CQL3 documentation fixes (#5878)
Updated Branches: refs/heads/cassandra-2.0.0 7a300c2a5 - cd4718245 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.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 ( ','
[1/3] git commit: CQL3 documentation fixes (#5878)
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
[1/4] git commit: CQL3 documentation fixes (#5878)
Updated Branches: refs/heads/trunk 1bb1ffbc0 - 896e1722d 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/trunk 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 ::=