Repository: asterixdb Updated Branches: refs/heads/master 342bd342e -> 8c6e7cdb6
[ASTERIXDB-2050][SQL] Update Docs to Reflect New SQL++ Model - user model changes: no - storage format changes: no - interface changes: no Details: - Update docs to reflect the new enforcement of semicolon after every statement. - Add missing semicolons to SET statements in examples. Change-Id: I31ed7413a6de028fa9d1a0a9d2c6b36ac39ff9c9 Reviewed-on: https://asterix-gerrit.ics.uci.edu/1996 Sonar-Qube: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Contrib: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Reviewed-by: Till Westmann <ti...@apache.org> Project: http://git-wip-us.apache.org/repos/asf/asterixdb/repo Commit: http://git-wip-us.apache.org/repos/asf/asterixdb/commit/8c6e7cdb Tree: http://git-wip-us.apache.org/repos/asf/asterixdb/tree/8c6e7cdb Diff: http://git-wip-us.apache.org/repos/asf/asterixdb/diff/8c6e7cdb Branch: refs/heads/master Commit: 8c6e7cdb66f21cd34901f45ac8fb5768d82964b4 Parents: 342bd34 Author: Murtadha Hubail <mhub...@apache.org> Authored: Fri Sep 8 21:17:47 2017 -0700 Committer: Till Westmann <ti...@apache.org> Committed: Sun Sep 10 15:36:23 2017 -0700 ---------------------------------------------------------------------- asterixdb/asterix-doc/src/main/markdown/sqlpp/5_ddl_head.md | 4 ++-- .../src/main/markdown/sqlpp/appendix_2_parameters.md | 8 ++++---- 2 files changed, 6 insertions(+), 6 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/asterixdb/blob/8c6e7cdb/asterixdb/asterix-doc/src/main/markdown/sqlpp/5_ddl_head.md ---------------------------------------------------------------------- diff --git a/asterixdb/asterix-doc/src/main/markdown/sqlpp/5_ddl_head.md b/asterixdb/asterix-doc/src/main/markdown/sqlpp/5_ddl_head.md index 99954f7..658190b 100644 --- a/asterixdb/asterix-doc/src/main/markdown/sqlpp/5_ddl_head.md +++ b/asterixdb/asterix-doc/src/main/markdown/sqlpp/5_ddl_head.md @@ -19,7 +19,7 @@ # <a id="DDL_and_DML_statements">5. DDL and DML statements</a> - Statement ::= ( SingleStatement ( ";" )? )* <EOF> + Statement ::= ( ( SingleStatement )? ( ";" )+ )* <EOF> SingleStatement ::= DatabaseDeclaration | FunctionDeclaration | CreateStatement @@ -28,7 +28,7 @@ | SetStatement | InsertStatement | DeleteStatement - | Query ";" + | Query In addition to queries, an implementation of SQL++ needs to support statements for data definition and manipulation purposes as well as controlling the context to be used in evaluating SQL++ expressions. http://git-wip-us.apache.org/repos/asf/asterixdb/blob/8c6e7cdb/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_parameters.md ---------------------------------------------------------------------- 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 9d42b00..1b392fe 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 @@ -44,7 +44,7 @@ There are three cases of the value *p* for compiler.parallelism: ##### Example - SET `compiler.parallelism` "16" + SET `compiler.parallelism` "16"; SELECT u.name AS uname, m.message AS message FROM GleambookUsers u JOIN GleambookMessages m ON m.authorId = u.id; @@ -71,7 +71,7 @@ If there is no user-provided suffix, "B" is the default suffix. See the followin ##### Example - SET `compiler.groupmemory` "64MB" + SET `compiler.groupmemory` "64MB"; SELECT msg.authorId, COUNT(*) FROM GleambookMessages msg @@ -79,7 +79,7 @@ If there is no user-provided suffix, "B" is the default suffix. See the followin ##### Example - SET `compiler.sortmemory` "67108864" + SET `compiler.sortmemory` "67108864"; SELECT VALUE user FROM GleambookUsers AS user @@ -87,7 +87,7 @@ If there is no user-provided suffix, "B" is the default suffix. See the followin ##### Example - SET `compiler.joinmemory` "132000KB" + SET `compiler.joinmemory` "132000KB"; SELECT u.name AS uname, m.message AS message FROM GleambookUsers u JOIN GleambookMessages m ON m.authorId = u.id;