Changeset: df52fe8fef31 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=df52fe8fef31
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/scripts/51_sys_schema_extension.sql
Branch: default
Log Message:
Added missing keywords to sys.keywords table
diffs (271 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
@@ -2521,7 +2521,14 @@ sql_update_default(Client c, mvc *sql, c
pos += snprintf(buf + pos, bufsize - pos,
"ALTER TABLE sys.keywords SET READ WRITE;\n"
- "insert into sys.keywords values ('CUBE'),
('DEALLOCATE'), ('GROUPING'), ('ROLLUP'), ('SETS');\n");
+ "insert into sys.keywords values
('ANALYZE'),('AT'),('AUTHORIZATION'),('CACHE'),('CENTURY'),('COLUMN'),('CLIENT'),"
+
"('CUBE'),('CYCLE'),('DATA'),('DATE'),('DEBUG'),('DECADE'),('DEALLOCATE'),('DIAGNOSTICS'),('DISTINCT'),"
+
"('DOW'),('DOY'),('EXEC'),('EXECUTE'),('EXPLAIN'),('FIRST'),('FWF'),('GROUPING'),('GROUPS'),('INCREMENT'),"
+
"('INTERVAL'),('KEY'),('LANGUAGE'),('LARGE'),('LAST'),('LEVEL'),('LOADER'),('MATCH'),('MATCHED'),('MAXVALUE'),"
+
"('MINVALUE'),('NAME'),('NULLS'),('OBJECT'),('OPTIONS'),('PASSWORD'),('PLAN'),('PRECISION'),('PREP'),('PREPARE'),"
+
"('QUARTER'),('RELEASE'),('REPLACE'),('ROLLUP'),('SCHEMA'),('SEED'),('SERVER'),('SESSION'),('SETS'),('SIZE'),"
+
"('TABLE'),('TEMP'),('TEMPORARY'),('TEXT'),('TIME'),('TIMESTAMP'),('TRACE'),('TYPE'),('UNIONJOIN'),('WEEK'),"
+ "('YEAR'),('ZONE');\n");
pos += snprintf(buf + pos, bufsize - pos, "commit;\n");
pos += snprintf(buf + pos, bufsize - pos, "set schema \"%s\";\n",
prev_schema);
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
@@ -17,11 +17,14 @@ INSERT INTO sys.keywords (keyword) VALUE
('ALL'),
('ALTER'),
('ALWAYS'),
+ ('ANALYZE'),
('AND'),
('ANY'),
('ASC'),
('ASYMMETRIC'),
+ ('AT'),
('ATOMIC'),
+ ('AUTHORIZATION'),
('AUTO_INCREMENT'),
('BEFORE'),
('BEGIN'),
@@ -32,16 +35,20 @@ INSERT INTO sys.keywords (keyword) VALUE
('BINARY'),
('BLOB'),
('BY'),
+ ('CACHE'),
('CALL'),
('CASCADE'),
('CASE'),
('CAST'),
+ ('CENTURY'),
('CHAIN'),
('CHAR'),
('CHARACTER'),
('CHECK'),
+ ('CLIENT'),
('CLOB'),
('COALESCE'),
+ ('COLUMN'),
('COMMENT'),
('COMMIT'),
('COMMITTED'),
@@ -59,16 +66,25 @@ INSERT INTO sys.keywords (keyword) VALUE
('CURRENT_TIME'),
('CURRENT_TIMESTAMP'),
('CURRENT_USER'),
+ ('CYCLE'),
+ ('DATA'),
+ ('DATE'),
('DAY'),
('DEALLOCATE'),
+ ('DEBUG'),
('DEC'),
+ ('DECADE'),
('DECIMAL'),
('DECLARE'),
('DEFAULT'),
('DELETE'),
('DELIMITERS'),
('DESC'),
+ ('DIAGNOSTICS'),
+ ('DISTINCT'),
('DO'),
+ ('DOW'),
+ ('DOY'),
('DOUBLE'),
('DROP'),
('EACH'),
@@ -81,22 +97,28 @@ INSERT INTO sys.keywords (keyword) VALUE
('EVERY'),
('EXCEPT'),
('EXCLUDE'),
+ ('EXEC'),
+ ('EXECUTE'),
('EXISTS'),
+ ('EXPLAIN'),
('EXTERNAL'),
('EXTRACT'),
('FALSE'),
('FLOAT'),
+ ('FIRST'),
('FOLLOWING'),
('FOR'),
('FOREIGN'),
('FROM'),
('FULL'),
('FUNCTION'),
+ ('FWF'),
('GENERATED'),
('GLOBAL'),
('GRANT'),
('GROUP'),
('GROUPING'),
+ ('GROUPS'),
('HAVING'),
('HOUR'),
('HUGEINT'),
@@ -104,27 +126,40 @@ INSERT INTO sys.keywords (keyword) VALUE
('IF'),
('ILIKE'),
('IN'),
+ ('INCREMENT'),
('INDEX'),
('INNER'),
('INSERT'),
('INT'),
('INTEGER'),
('INTERSECT'),
+ ('INTERVAL'),
('INTO'),
('IS'),
('ISOLATION'),
('JOIN'),
+ ('KEY'),
+ ('LANGUAGE'),
+ ('LARGE'),
+ ('LAST'),
('LEFT'),
+ ('LEVEL'),
('LIKE'),
('LIMIT'),
+ ('LOADER'),
('LOCAL'),
('LOCALTIME'),
('LOCALTIMESTAMP'),
('LOCKED'),
+ ('MATCH'),
+ ('MATCHED'),
+ ('MAXVALUE'),
('MEDIUMINT'),
('MERGE'),
('MINUTE'),
+ ('MINVALUE'),
('MONTH'),
+ ('NAME'),
('NATURAL'),
('NEW'),
('NEXT'),
@@ -134,14 +169,17 @@ INSERT INTO sys.keywords (keyword) VALUE
('NOT'),
('NOW'),
('NULL'),
+ ('NULLS'),
('NULLIF'),
('NUMERIC'),
+ ('OBJECT'),
('OF'),
('OFFSET'),
('OLD'),
('ON'),
('ONLY'),
('OPTION'),
+ ('OPTIONS'),
('OR'),
('ORDER'),
('OTHERS'),
@@ -149,22 +187,30 @@ INSERT INTO sys.keywords (keyword) VALUE
('OVER'),
('PARTIAL'),
('PARTITION'),
+ ('PASSWORD'),
+ ('PLAN'),
('POSITION'),
('PRECEDING'),
+ ('PRECISION'),
+ ('PREP'),
+ ('PREPARE'),
('PRESERVE'),
('PRIMARY'),
('PRIVILEGES'),
('PROCEDURE'),
('PUBLIC'),
+ ('QUARTER'),
('RANGE'),
('READ'),
('REAL'),
('RECORDS'),
('REFERENCES'),
('REFERENCING'),
+ ('RELEASE'),
('REMOTE'),
('RENAME'),
('REPEATABLE'),
+ ('REPLACE'),
('REPLICA'),
('RESTART'),
('RESTRICT'),
@@ -177,15 +223,20 @@ INSERT INTO sys.keywords (keyword) VALUE
('ROWS'),
('SAMPLE'),
('SAVEPOINT'),
+ ('SCHEMA'),
('SECOND'),
+ ('SEED'),
('SELECT'),
('SEQUENCE'),
('SERIAL'),
('SERIALIZABLE'),
+ ('SERVER'),
+ ('SESSION'),
('SESSION_USER'),
('SET'),
('SETS'),
('SIMPLE'),
+ ('SIZE'),
('SMALLINT'),
('SOME'),
('SPLIT_PART'),
@@ -197,18 +248,27 @@ INSERT INTO sys.keywords (keyword) VALUE
('STRING'),
('SUBSTRING'),
('SYMMETRIC'),
+ ('TABLE'),
+ ('TEMP'),
+ ('TEMPORARY'),
+ ('TEXT'),
('THEN'),
('TIES'),
+ ('TIME'),
+ ('TIMESTAMP'),
('TINYINT'),
('TO'),
+ ('TRACE'),
('TRANSACTION'),
('TRIGGER'),
('TRUNCATE'),
('TRUE'),
+ ('TYPE'),
('UNBOUNDED'),
('UNCOMMITTED'),
('UNENCRYPTED'),
('UNION'),
+ ('UNIONJOIN'),
('UNIQUE'),
('UPDATE'),
('USER'),
@@ -217,6 +277,7 @@ INSERT INTO sys.keywords (keyword) VALUE
('VARCHAR'),
('VARYING'),
('VIEW'),
+ ('WEEK'),
('WHEN'),
('WHERE'),
('WHILE'),
@@ -237,7 +298,9 @@ INSERT INTO sys.keywords (keyword) VALUE
('XMLQUERY'),
('XMLSCHEMA'),
('XMLTEXT'),
- ('XMLVALIDATE');
+ ('XMLVALIDATE'),
+ ('YEAR'),
+ ('ZONE');
ALTER TABLE sys.keywords SET READ ONLY;
GRANT SELECT ON sys.keywords TO PUBLIC;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
