Changeset: ba0dc001d223 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ba0dc001d223
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/scripts/51_sys_schema_extension.sql
Branch: grouping-analytics
Log Message:
New keywords added
diffs (48 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2381,6 +2381,9 @@ sql_update_default(Client c, mvc *sql, c
"update sys._tables set system = true where schema_id =
(select id from sys.schemas where name = 'sys')"
" and name = 'queue';\n");
+ pos += snprintf(buf + pos, bufsize - pos,
+ "insert into sys.keywords values ('CUBE'),
('GROUPING'), ('ROLLUP'), ('SETS');\n");
+
pos += snprintf(buf + pos, bufsize - pos, "set schema \"%s\";\n",
prev_schema);
pos += snprintf(buf + pos, bufsize - pos, "commit;\n");
assert(pos < bufsize);
diff --git a/sql/scripts/51_sys_schema_extension.sql
b/sql/scripts/51_sys_schema_extension.sql
--- a/sql/scripts/51_sys_schema_extension.sql
+++ b/sql/scripts/51_sys_schema_extension.sql
@@ -52,6 +52,7 @@ INSERT INTO sys.keywords (keyword) VALUE
('CORRESPONDING'),
('CREATE'),
('CROSS'),
+ ('CUBE'),
('CURRENT'),
('CURRENT_DATE'),
('CURRENT_ROLE'),
@@ -94,6 +95,7 @@ INSERT INTO sys.keywords (keyword) VALUE
('GLOBAL'),
('GRANT'),
('GROUP'),
+ ('GROUPING'),
('HAVING'),
('HOUR'),
('HUGEINT'),
@@ -170,6 +172,7 @@ INSERT INTO sys.keywords (keyword) VALUE
('REVOKE'),
('RIGHT'),
('ROLLBACK'),
+ ('ROLLUP'),
('ROWS'),
('SAMPLE'),
('SAVEPOINT'),
@@ -180,6 +183,7 @@ INSERT INTO sys.keywords (keyword) VALUE
('SERIALIZABLE'),
('SESSION_USER'),
('SET'),
+ ('SETS'),
('SIMPLE'),
('SMALLINT'),
('SOME'),
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
