Till Westmann has submitted this change and it was merged. Change subject: [NO ISSUE] Small documentation fixes ......................................................................
[NO ISSUE] Small documentation fixes Change-Id: Ib7c040cf90f48f848a16e2729fa2e75d654b565d Reviewed-on: https://asterix-gerrit.ics.uci.edu/2013 Reviewed-by: Xikui Wang <[email protected]> Sonar-Qube: Jenkins <[email protected]> Tested-by: Jenkins <[email protected]> Contrib: Jenkins <[email protected]> Integration-Tests: Jenkins <[email protected]> --- M asterixdb/asterix-doc/src/main/markdown/sqlpp/3_query.md M asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_parameters.md 2 files changed, 8 insertions(+), 5 deletions(-) Approvals: Anon. E. Moose #1000171: Xikui Wang: Looks good to me, approved Jenkins: Verified; No violations found; ; Verified diff --git a/asterixdb/asterix-doc/src/main/markdown/sqlpp/3_query.md b/asterixdb/asterix-doc/src/main/markdown/sqlpp/3_query.md index 409ca38..5d94ea4 100644 --- a/asterixdb/asterix-doc/src/main/markdown/sqlpp/3_query.md +++ b/asterixdb/asterix-doc/src/main/markdown/sqlpp/3_query.md @@ -38,7 +38,7 @@ SelectClause ::= <SELECT> ( <ALL> | <DISTINCT> )? ( SelectRegular | SelectValue ) SelectRegular ::= Projection ( "," Projection )* - SelectValue ::= ( <VALUE> | <ELEMENT> | <RAW> ) Expression + SelectValue ::= ( <VALUE> | <ELEMENT> | <RAW> ) Expression Projection ::= ( Expression ( <AS> )? Identifier | "*" ) FromClause ::= <FROM> FromTerm ( "," FromTerm )* @@ -57,13 +57,16 @@ WhereClause ::= <WHERE> Expression - GroupbyClause ::= <GROUP> <BY> ( Expression ( (<AS>)? Variable )? ( "," Expression ( (<AS>)? Variable )? )* + GroupbyClause ::= <GROUP> <BY> Expression ( ( (<AS>)? Variable )? + ( "," Expression ( (<AS>)? Variable )? )* ) ( <GROUP> <AS> Variable - ("(" Variable <AS> VariableReference ("," Variable <AS> VariableReference )* ")")? + ("(" Variable <AS> VariableReference + ("," Variable <AS> VariableReference )* ")")? )? HavingClause ::= <HAVING> Expression - OrderbyClause ::= <ORDER> <BY> Expression ( <ASC> | <DESC> )? ( "," Expression ( <ASC> | <DESC> )? )* + OrderbyClause ::= <ORDER> <BY> Expression ( <ASC> | <DESC> )? + ( "," Expression ( <ASC> | <DESC> )? )* LimitClause ::= <LIMIT> Expression ( <OFFSET> Expression )? In this section, we will make use of two stored collections of objects (datasets), `GleambookUsers` and `GleambookMessages`, in a series of running examples to explain `SELECT` queries. The contents of the example collections are as follows: diff --git a/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_parameters.md b/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_parameters.md index 1b392fe..3976937 100644 --- a/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_parameters.md +++ b/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_parameters.md @@ -19,7 +19,7 @@ The SET statement can be used to override some cluster-wide configuration parameters for a specific request: - SET <IDENTIFIER> <STRING_LITERAL> + SET <IDENTIFIER> <STRING_LITERAL> As parameter identifiers are qualified names (containing a '.') they have to be escaped using backticks (\`\`). Note that changing query parameters will not affect query correctness but only impact performance -- To view, visit https://asterix-gerrit.ics.uci.edu/2013 To unsubscribe, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-MessageType: merged Gerrit-Change-Id: Ib7c040cf90f48f848a16e2729fa2e75d654b565d Gerrit-PatchSet: 4 Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Owner: Till Westmann <[email protected]> Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins <[email protected]> Gerrit-Reviewer: Till Westmann <[email protected]> Gerrit-Reviewer: Xikui Wang <[email protected]>
