Changeset: 1b6d82219d56 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1b6d82219d56
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/scripts/51_sys_schema_extension.sql
Branch: default
Log Message:
Add more missing keywords into sys.keywords table. This fixes bug #7093
diffs (68 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
@@ -2402,7 +2402,7 @@ sql_update_default(Client c, mvc *sql, c
pos += snprintf(buf + pos, bufsize - pos,
"ALTER TABLE sys.keywords SET READ
WRITE;\n"
"DELETE FROM sys.keywords where keyword
= 'STREAM';\n"
- "INSERT INTO sys.keywords VALUES
('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN');\n"
+ "INSERT INTO sys.keywords VALUES
('BIG'), ('LITTLE'), ('NATIVE'), ('ENDIAN'), ('CURRENT_SCHEMA'),
('CURRENT_TIMEZONE'), ('IMPRINTS'), ('ORDERED'), ('PATH'), ('ROLE'), ('ROW'),
('VALUE');\n"
"ALTER TABLE sys.table_types SET READ
WRITE;\n"
"DELETE FROM sys.table_types where
table_type_id = 4;\n"
"ALTER TABLE sys.function_types SET
READ WRITE;\n"
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
@@ -64,8 +64,10 @@ INSERT INTO sys.keywords (keyword) VALUE
('CURRENT'),
('CURRENT_DATE'),
('CURRENT_ROLE'),
+ ('CURRENT_SCHEMA'),
('CURRENT_TIME'),
('CURRENT_TIMESTAMP'),
+ ('CURRENT_TIMEZONE'),
('CURRENT_USER'),
('CYCLE'),
('DATA'),
@@ -128,6 +130,7 @@ INSERT INTO sys.keywords (keyword) VALUE
('IDENTITY'),
('IF'),
('ILIKE'),
+ ('IMPRINTS'),
('IN'),
('INCREMENT'),
('INDEX'),
@@ -186,12 +189,14 @@ INSERT INTO sys.keywords (keyword) VALUE
('OPTIONS'),
('OR'),
('ORDER'),
+ ('ORDERED'),
('OTHERS'),
('OUTER'),
('OVER'),
('PARTIAL'),
('PARTITION'),
('PASSWORD'),
+ ('PATH'),
('PLAN'),
('POSITION'),
('PRECEDING'),
@@ -222,8 +227,10 @@ INSERT INTO sys.keywords (keyword) VALUE
('RETURNS'),
('REVOKE'),
('RIGHT'),
+ ('ROLE'),
('ROLLBACK'),
('ROLLUP'),
+ ('ROW'),
('ROWS'),
('SAMPLE'),
('SAVEPOINT'),
@@ -276,6 +283,7 @@ INSERT INTO sys.keywords (keyword) VALUE
('UPDATE'),
('USER'),
('USING'),
+ ('VALUE'),
('VALUES'),
('VARCHAR'),
('VARYING'),
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
