MonetDB: rename-sql - Updated documentation for rename statements.

[Pedro Ferreira]

Changeset: 98652fbc203a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=98652fbc203a
Modified Files:
        clients/mapiclient/mhelp.c
        sql/server/sql_parser.y
Branch: rename-sql
Log Message:

Updated documentation for rename statements.

Also added missing tokens in token2string.


diffs (50 lines):

diff --git a/clients/mapiclient/mhelp.c b/clients/mapiclient/mhelp.c
--- a/clients/mapiclient/mhelp.c
+++ b/clients/mapiclient/mhelp.c
@@ -41,7 +41,7 @@ typedef struct {
        const char *comments;
 } SQLhelp;
 
-#define NUMBER_MAJOR_COMMANDS 74 // The number of major commands to show in 
case of no query
+#define NUMBER_MAJOR_COMMANDS 75 // The number of major commands to show in 
case of no query
 
 SQLhelp sqlhelp[] = {
        // major commands
@@ -52,9 +52,11 @@ SQLhelp sqlhelp[] = {
         "ALTER TABLE qname ALTER [ COLUMN ] ident SET [NOT] NULL\n"
         "ALTER TABLE qname ALTER [ COLUMN ] ident DROP DEFAULT\n"
         "ALTER TABLE qname ALTER [ COLUMN ] ident SET STORAGE {string | 
NULL}\n"
+        "ALTER TABLE qname ALTER [ COLUMN ] ident RENAME TO ident\n"
         "ALTER TABLE qname DROP [ COLUMN ] ident [ RESTRICT | CASCADE ]\n"
         "ALTER TABLE qname DROP CONSTRAINT ident [ RESTRICT | CASCADE ]\n"
-        "ALTER TABLE qname SET { { READ | INSERT } ONLY | READ WRITE }",
+        "ALTER TABLE qname SET { { READ | INSERT } ONLY | READ WRITE }\n"
+        "ALTER TABLE qname RENAME TO ident",
         "column_def,table_constraint",
         "See also https://www.monetdb.org/Documentation/SQLreference/Alter"},
        {"ALTER MERGE TABLE",
@@ -64,6 +66,11 @@ SQLhelp sqlhelp[] = {
         "ALTER TABLE qname SET TABLE qname AS PARTITION opt_partition_spec",
         "opt_partition_spec",
         "See also 
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DataPartitioning"},
+       {"ALTER SCHEMA",
+        "",
+        "ALTER SCHEMA ident RENAME TO ident",
+        NULL,
+        "See also https://www.monetdb.org/Documentation/SQLreference/Alter"},
        {"ALTER SEQUENCE",
         "",
         "ALTER SEQUENCE ident [ AS datatype] [ RESTART [WITH start]] 
[INCREMENT BY increment]\n"
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -6488,6 +6488,9 @@ char *token2string(int token)
        SQL(PARTITION_RANGE);
        SQL(PARTITION_COLUMN);
        SQL(PARTITION_EXPRESSION);
+       SQL(RENAME_SCHEMA);
+       SQL(RENAME_TABLE);
+       SQL(RENAME_COLUMN);
        }
        return "unknown";       /* just needed for broken compilers ! */
 }
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list