From c29ba98189190288c2251c6073c13c6234479e5c Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 14 May 2019 09:56:40 +0200 Subject: Update SQL keywords list to SQL:2016 Per previous convention (see ace397e9d24eddc56e7dffa921f506117b602d78), drop SQL:2008 and only keep the latest two standards and SQL-92. Note: SQL:2016-2 lists a large number of non-reserved keywords that are really just information_schema column names related to new features. Those kinds of thing have not previously been listed as keywords, and this was apparently done here by mistake, since these keywords have been removed again in post-2016 working drafts. So in order to avoid bloating the keywords table unnecessarily, I have omitted these erroneous keywords here. --- doc/src/sgml/generate-keywords-table.pl | 2 +- doc/src/sgml/keywords/sql2008-02-nonreserved.txt | 218 -------------- doc/src/sgml/keywords/sql2008-02-reserved.txt | 307 ------------------- doc/src/sgml/keywords/sql2008-09-nonreserved.txt | 23 -- doc/src/sgml/keywords/sql2008-09-reserved.txt | 13 - doc/src/sgml/keywords/sql2008-14-nonreserved.txt | 29 -- doc/src/sgml/keywords/sql2008-14-reserved.txt | 20 -- doc/src/sgml/keywords/sql2016-02-nonreserved.txt | 248 +++++++++++++++ doc/src/sgml/keywords/sql2016-02-reserved.txt | 367 +++++++++++++++++++++++ doc/src/sgml/keywords/sql2016-09-nonreserved.txt | 23 ++ doc/src/sgml/keywords/sql2016-09-reserved.txt | 13 + doc/src/sgml/keywords/sql2016-14-nonreserved.txt | 27 ++ doc/src/sgml/keywords/sql2016-14-reserved.txt | 20 ++ 13 files changed, 699 insertions(+), 611 deletions(-) delete mode 100644 doc/src/sgml/keywords/sql2008-02-nonreserved.txt delete mode 100644 doc/src/sgml/keywords/sql2008-02-reserved.txt delete mode 100644 doc/src/sgml/keywords/sql2008-09-nonreserved.txt delete mode 100644 doc/src/sgml/keywords/sql2008-09-reserved.txt delete mode 100644 doc/src/sgml/keywords/sql2008-14-nonreserved.txt delete mode 100644 doc/src/sgml/keywords/sql2008-14-reserved.txt create mode 100644 doc/src/sgml/keywords/sql2016-02-nonreserved.txt create mode 100644 doc/src/sgml/keywords/sql2016-02-reserved.txt create mode 100644 doc/src/sgml/keywords/sql2016-09-nonreserved.txt create mode 100644 doc/src/sgml/keywords/sql2016-09-reserved.txt create mode 100644 doc/src/sgml/keywords/sql2016-14-nonreserved.txt create mode 100644 doc/src/sgml/keywords/sql2016-14-reserved.txt (limited to 'doc/src') diff --git a/doc/src/sgml/generate-keywords-table.pl b/doc/src/sgml/generate-keywords-table.pl index 611c22bdd3e..e948d5fb5e9 100644 --- a/doc/src/sgml/generate-keywords-table.pl +++ b/doc/src/sgml/generate-keywords-table.pl @@ -6,7 +6,7 @@ use strict; use warnings; -my @sql_versions = reverse sort ('1992', '2008', '2011'); +my @sql_versions = reverse sort ('1992', '2011', '2016'); my $srcdir = $ARGV[0]; diff --git a/doc/src/sgml/keywords/sql2008-02-nonreserved.txt b/doc/src/sgml/keywords/sql2008-02-nonreserved.txt deleted file mode 100644 index 9c30628355f..00000000000 --- a/doc/src/sgml/keywords/sql2008-02-nonreserved.txt +++ /dev/null @@ -1,218 +0,0 @@ -A -ABSOLUTE -ACTION -ADA -ADD -ADMIN -AFTER -ALWAYS -ASC -ASSERTION -ASSIGNMENT -ATTRIBUTE -ATTRIBUTES -BEFORE -BERNOULLI -BREADTH -C -CASCADE -CATALOG -CATALOG_NAME -CHAIN -CHARACTER_SET_CATALOG -CHARACTER_SET_NAME -CHARACTER_SET_SCHEMA -CHARACTERISTICS -CHARACTERS -CLASS_ORIGIN -COBOL -COLLATION -COLLATION_CATALOG -COLLATION_NAME -COLLATION_SCHEMA -COLUMN_NAME -COMMAND_FUNCTION -COMMAND_FUNCTION_CODE -COMMITTED -CONDITION_NUMBER -CONNECTION -CONNECTION_NAME -CONSTRAINT_CATALOG -CONSTRAINT_NAME -CONSTRAINT_SCHEMA -CONSTRAINTS -CONSTRUCTOR -CONTAINS -CONTINUE -CURSOR_NAME -DATA -DATETIME_INTERVAL_CODE -DATETIME_INTERVAL_PRECISION -DEFAULTS -DEFERRABLE -DEFERRED -DEFINED -DEFINER -DEGREE -DEPTH -DERIVED -DESC -DESCRIPTOR -DIAGNOSTICS -DISPATCH -DOMAIN -DYNAMIC_FUNCTION -DYNAMIC_FUNCTION_CODE -EQUALS -EXCLUDE -EXCLUDING -FINAL -FIRST -FLAG -FOLLOWING -FORTRAN -FOUND -G -GENERAL -GENERATED -GO -GOTO -GRANTED -HIERARCHY -IGNORE -IMMEDIATE -IMPLEMENTATION -INCLUDING -INCREMENT -INITIALLY -INPUT -INSTANCE -INSTANTIABLE -INSTEAD -INVOKER -ISOLATION -K -KEY -KEY_MEMBER -KEY_TYPE -LAST -LENGTH -LEVEL -LOCATOR -M -MAP -MATCHED -MAXVALUE -MESSAGE_LENGTH -MESSAGE_OCTET_LENGTH -MESSAGE_TEXT -MINVALUE -MORE -MUMPS -NAME -NAMES -NESTING -NEXT -NFC -NFD -NFKC -NFKD -NORMALIZED -NULLABLE -NULLS -NUMBER -OBJECT -OCTETS -OPTION -OPTIONS -ORDERING -ORDINALITY -OTHERS -OUTPUT -OVERRIDING -P -PAD -PARAMETER_MODE -PARAMETER_NAME -PARAMETER_ORDINAL_POSITION -PARAMETER_SPECIFIC_CATALOG -PARAMETER_SPECIFIC_NAME -PARAMETER_SPECIFIC_SCHEMA -PARTIAL -PASCAL -PATH -PLACING -PLI -PRECEDING -PRESERVE -PRIOR -PRIVILEGES -PUBLIC -READ -RELATIVE -REPEATABLE -RESPECT -RESTART -RESTRICT -RETURNED_CARDINALITY -RETURNED_LENGTH -RETURNED_OCTET_LENGTH -RETURNED_SQLSTATE -ROLE -ROUTINE -ROUTINE_CATALOG -ROUTINE_NAME -ROUTINE_SCHEMA -ROW_COUNT -SCALE -SCHEMA -SCHEMA_NAME -SCOPE_CATALOG -SCOPE_NAME -SCOPE_SCHEMA -SECTION -SECURITY -SELF -SEQUENCE -SERIALIZABLE -SERVER_NAME -SESSION -SETS -SIMPLE -SIZE -SOURCE -SPACE -SPECIFIC_NAME -STATE -STATEMENT -STRUCTURE -STYLE -SUBCLASS_ORIGIN -T -TABLE_NAME -TEMPORARY -TIES -TOP_LEVEL_COUNT -TRANSACTION -TRANSACTION_ACTIVE -TRANSACTIONS_COMMITTED -TRANSACTIONS_ROLLED_BACK -TRANSFORM -TRANSFORMS -TRIGGER_CATALOG -TRIGGER_NAME -TRIGGER_SCHEMA -TYPE -UNBOUNDED -UNCOMMITTED -UNDER -UNNAMED -USAGE -USER_DEFINED_TYPE_CATALOG -USER_DEFINED_TYPE_CODE -USER_DEFINED_TYPE_NAME -USER_DEFINED_TYPE_SCHEMA -VIEW -WORK -WRITE -ZONE diff --git a/doc/src/sgml/keywords/sql2008-02-reserved.txt b/doc/src/sgml/keywords/sql2008-02-reserved.txt deleted file mode 100644 index b4a2c64af99..00000000000 --- a/doc/src/sgml/keywords/sql2008-02-reserved.txt +++ /dev/null @@ -1,307 +0,0 @@ -ABS -ALL -ALLOCATE -ALTER -AND -ANY -ARE -ARRAY -ARRAY_AGG -AS -ASENSITIVE -ASYMMETRIC -AT -ATOMIC -AUTHORIZATION -AVG -BEGIN -BETWEEN -BIGINT -BINARY -BLOB -BOOLEAN -BOTH -BY -CALL -CALLED -CARDINALITY -CASCADED -CASE -CAST -CEIL -CEILING -CHAR -CHAR_LENGTH -CHARACTER -CHARACTER_LENGTH -CHECK -CLOB -CLOSE -COALESCE -COLLATE -COLLECT -COLUMN -COMMIT -CONDITION -CONNECT -CONSTRAINT -CONVERT -CORR -CORRESPONDING -COUNT -COVAR_POP -COVAR_SAMP -CREATE -CROSS -CUBE -CUME_DIST -CURRENT -CURRENT_CATALOG -CURRENT_DATE -CURRENT_DEFAULT_TRANSFORM_GROUP -CURRENT_PATH -CURRENT_ROLE -CURRENT_SCHEMA -CURRENT_TIME -CURRENT_TIMESTAMP -CURRENT_TRANSFORM_GROUP_FOR_TYPE -CURRENT_USER -CURSOR -CYCLE -DATE -DAY -DEALLOCATE -DEC -DECIMAL -DECLARE -DEFAULT -DELETE -DENSE_RANK -DEREF -DESCRIBE -DETERMINISTIC -DISCONNECT -DISTINCT -DOUBLE -DROP -DYNAMIC -EACH -ELEMENT -ELSE -END -END-EXEC -ESCAPE -EVERY -EXCEPT -EXEC -EXECUTE -EXISTS -EXP -EXTERNAL -EXTRACT -FALSE -FETCH -FILTER -FIRST_VALUE -FLOAT -FLOOR -FOR -FOREIGN -FREE -FROM -FULL -FUNCTION -FUSION -GET -GLOBAL -GRANT -GROUP -GROUPING -HAVING -HOLD -HOUR -IDENTITY -IN -INDICATOR -INNER -INOUT -INSENSITIVE -INSERT -INT -INTEGER -INTERSECT -INTERSECTION -INTERVAL -INTO -IS -JOIN -LAG -LANGUAGE -LARGE -LAST_VALUE -LATERAL -LEAD -LEADING -LEFT -LIKE -LIKE_REGEX -LN -LOCAL -LOCALTIME -LOCALTIMESTAMP -LOWER -MATCH -MAX -MAX_CARDINALITY -MEMBER -MERGE -METHOD -MIN -MINUTE -MOD -MODIFIES -MODULE -MONTH -MULTISET -NATIONAL -NATURAL -NCHAR -NCLOB -NEW -NO -NONE -NORMALIZE -NOT -NTH_VALUE -NTILE -NULL -NULLIF -NUMERIC -OCTET_LENGTH -OCCURRENCES_REGEX -OF -OFFSET -OLD -ON -ONLY -OPEN -OR -ORDER -OUT -OUTER -OVER -OVERLAPS -OVERLAY -PARAMETER -PARTITION -PERCENT_RANK -PERCENTILE_CONT -PERCENTILE_DISC -POSITION -POSITION_REGEX -POWER -PRECISION -PREPARE -PRIMARY -PROCEDURE -RANGE -RANK -READS -REAL -RECURSIVE -REF -REFERENCES -REFERENCING -REGR_AVGX -REGR_AVGY -REGR_COUNT -REGR_INTERCEPT -REGR_R2 -REGR_SLOPE -REGR_SXX -REGR_SXY -REGR_SYY -RELEASE -RESULT -RETURN -RETURNS -REVOKE -RIGHT -ROLLBACK -ROLLUP -ROW -ROW_NUMBER -ROWS -SAVEPOINT -SCOPE -SCROLL -SEARCH -SECOND -SELECT -SENSITIVE -SESSION_USER -SET -SIMILAR -SMALLINT -SOME -SPECIFIC -SPECIFICTYPE -SQL -SQLEXCEPTION -SQLSTATE -SQLWARNING -SQRT -START -STATIC -STDDEV_POP -STDDEV_SAMP -SUBMULTISET -SUBSTRING -SUBSTRING_REGEX -SUM -SYMMETRIC -SYSTEM -SYSTEM_USER -TABLE -TABLESAMPLE -THEN -TIME -TIMESTAMP -TIMEZONE_HOUR -TIMEZONE_MINUTE -TO -TRAILING -TRANSLATE -TRANSLATE_REGEX -TRANSLATION -TREAT -TRIGGER -TRUNCATE -TRIM -TRIM_ARRAY -TRUE -UESCAPE -UNION -UNIQUE -UNKNOWN -UNNEST -UPDATE -UPPER -USER -USING -VALUE -VALUES -VAR_POP -VAR_SAMP -VARBINARY -VARCHAR -VARYING -WHEN -WHENEVER -WHERE -WIDTH_BUCKET -WINDOW -WITH -WITHIN -WITHOUT -YEAR diff --git a/doc/src/sgml/keywords/sql2008-09-nonreserved.txt b/doc/src/sgml/keywords/sql2008-09-nonreserved.txt deleted file mode 100644 index b360f0ce861..00000000000 --- a/doc/src/sgml/keywords/sql2008-09-nonreserved.txt +++ /dev/null @@ -1,23 +0,0 @@ -BLOCKED -CONTROL -DB -FILE -FS -INTEGRITY -LIBRARY -LIMIT -LINK -MAPPING -OFF -PASSTHROUGH -PERMISSION -RECOVERY -REQUIRING -RESTORE -SELECTIVE -SERVER -TOKEN -UNLINK -VERSION -WRAPPER -YES diff --git a/doc/src/sgml/keywords/sql2008-09-reserved.txt b/doc/src/sgml/keywords/sql2008-09-reserved.txt deleted file mode 100644 index 02054857667..00000000000 --- a/doc/src/sgml/keywords/sql2008-09-reserved.txt +++ /dev/null @@ -1,13 +0,0 @@ -DATALINK -DLNEWCOPY -DLPREVIOUSCOPY -DLURLCOMPLETE -DLURLCOMPLETEWRITE -DLURLCOMPLETEONLY -DLURLPATH -DLURLPATHWRITE -DLURLPATHONLY -DLURLSCHEME -DLURLSERVER -DLVALUE -IMPORT diff --git a/doc/src/sgml/keywords/sql2008-14-nonreserved.txt b/doc/src/sgml/keywords/sql2008-14-nonreserved.txt deleted file mode 100644 index 317f651f0ee..00000000000 --- a/doc/src/sgml/keywords/sql2008-14-nonreserved.txt +++ /dev/null @@ -1,29 +0,0 @@ -ABSENT -ACCORDING -BASE64 -BOM -COLUMNS -CONTENT -DOCUMENT -EMPTY -ENCODING -HEX -ID -INDENT -LOCATION -NAMESPACE -NIL -PASSING -PATH -PRESERVE -RETURNING -SEQUENCE -STANDALONE -STRIP -UNTYPED -URI -VALID -VERSION -WHITESPACE -XMLSCHEMA -XMLDECLARATION diff --git a/doc/src/sgml/keywords/sql2008-14-reserved.txt b/doc/src/sgml/keywords/sql2008-14-reserved.txt deleted file mode 100644 index cf8052946f9..00000000000 --- a/doc/src/sgml/keywords/sql2008-14-reserved.txt +++ /dev/null @@ -1,20 +0,0 @@ -XML -XMLAGG -XMLATTRIBUTES -XMLBINARY -XMLCAST -XMLCOMMENT -XMLCONCAT -XMLDOCUMENT -XMLELEMENT -XMLEXISTS -XMLFOREST -XMLITERATE -XMLNAMESPACES -XMLPARSE -XMLPI -XMLQUERY -XMLSERIALIZE -XMLTABLE -XMLTEXT -XMLVALIDATE diff --git a/doc/src/sgml/keywords/sql2016-02-nonreserved.txt b/doc/src/sgml/keywords/sql2016-02-nonreserved.txt new file mode 100644 index 00000000000..f39e52e475d --- /dev/null +++ b/doc/src/sgml/keywords/sql2016-02-nonreserved.txt @@ -0,0 +1,248 @@ +A +ABSOLUTE +ACTION +ADA +ADD +ADMIN +AFTER +ALWAYS +ASC +ASSERTION +ASSIGNMENT +ATTRIBUTE +ATTRIBUTES +BEFORE +BERNOULLI +BREADTH +C +CASCADE +CATALOG +CATALOG_NAME +CHAIN +CHAINING +CHARACTER_SET_CATALOG +CHARACTER_SET_NAME +CHARACTER_SET_SCHEMA +CHARACTERISTICS +CHARACTERS +CLASS_ORIGIN +COBOL +COLLATION +COLLATION_CATALOG +COLLATION_NAME +COLLATION_SCHEMA +COLUMNS +COLUMN_NAME +COMMAND_FUNCTION +COMMAND_FUNCTION_CODE +COMMITTED +CONDITIONAL +CONDITION_NUMBER +CONNECTION +CONNECTION_NAME +CONSTRAINT_CATALOG +CONSTRAINT_NAME +CONSTRAINT_SCHEMA +CONSTRAINTS +CONSTRUCTOR +CONTINUE +CURSOR_NAME +DATA +DATETIME_INTERVAL_CODE +DATETIME_INTERVAL_PRECISION +DEFAULTS +DEFERRABLE +DEFERRED +DEFINED +DEFINER +DEGREE +DEPTH +DERIVED +DESC +DESCRIPTOR +DIAGNOSTICS +DISPATCH +DOMAIN +DYNAMIC_FUNCTION +DYNAMIC_FUNCTION_CODE +ENCODING +ENFORCED +ERROR +EXCLUDE +EXCLUDING +EXPRESSION +FINAL +FINISH +FIRST +FLAG +FOLLOWING +FORMAT +FORTRAN +FOUND +FULFILL +G +GENERAL +GENERATED +GO +GOTO +GRANTED +HIERARCHY +IGNORE +IMMEDIATE +IMMEDIATELY +IMPLEMENTATION +INCLUDING +INCREMENT +INITIALLY +INPUT +INSTANCE +INSTANTIABLE +INSTEAD +INVOKER +ISOLATION +JSON +K +KEEP +KEY +KEYS +KEY_MEMBER +KEY_TYPE +LAST +LENGTH +LEVEL +LOCATOR +M +MAP +MATCHED +MAXVALUE +MESSAGE_LENGTH +MESSAGE_OCTET_LENGTH +MESSAGE_TEXT +MINVALUE +MORE +MUMPS +NAME +NAMES +NESTED +NESTING +NEXT +NFC +NFD +NFKC +NFKD +NORMALIZED +NULLABLE +NULLS +NUMBER +OBJECT +OCTETS +OPTION +OPTIONS +ORDERING +ORDINALITY +OTHERS +OUTPUT +OVERFLOW +OVERRIDING +P +PAD +PARAMETER_MODE +PARAMETER_NAME +PARAMETER_ORDINAL_POSITION +PARAMETER_SPECIFIC_CATALOG +PARAMETER_SPECIFIC_NAME +PARAMETER_SPECIFIC_SCHEMA +PARTIAL +PASCAL +PASS +PASSING +PAST +PATH +PLACING +PLAN +PLI +PRECEDING +PRESERVE +PRIOR +PRIVATE +PRIVILEGES +PRUNE +PUBLIC +QUOTES +READ +RELATIVE +REPEATABLE +RESPECT +RESTART +RESTRICT +RETURNED_CARDINALITY +RETURNED_LENGTH +RETURNED_OCTET_LENGTH +RETURNED_SQLSTATE +RETURNING +ROLE +ROUTINE +ROUTINE_CATALOG +ROUTINE_NAME +ROUTINE_SCHEMA +ROW_COUNT +SCALAR +SCALE +SCHEMA +SCHEMA_NAME +SCOPE_CATALOG +SCOPE_NAME +SCOPE_SCHEMA +SECTION +SECURITY +SELF +SEQUENCE +SERIALIZABLE +SERVER_NAME +SESSION +SETS +SIMPLE +SIZE +SOURCE +SPACE +SPECIFIC_NAME +STATE +STATEMENT +STRING +STRUCTURE +STYLE +SUBCLASS_ORIGIN +T +TABLE_NAME +TEMPORARY +THROUGH +TIES +TOP_LEVEL_COUNT +TRANSACTION +TRANSACTION_ACTIVE +TRANSACTIONS_COMMITTED +TRANSACTIONS_ROLLED_BACK +TRANSFORM +TRANSFORMS +TRIGGER_CATALOG +TRIGGER_NAME +TRIGGER_SCHEMA +TYPE +UNBOUNDED +UNCOMMITTED +UNCONDITIONAL +UNDER +UNNAMED +USAGE +USER_DEFINED_TYPE_CATALOG +USER_DEFINED_TYPE_CODE +USER_DEFINED_TYPE_NAME +USER_DEFINED_TYPE_SCHEMA +UTF16 +UTF32 +UTF8 +VIEW +WORK +WRAPPER +WRITE +ZONE diff --git a/doc/src/sgml/keywords/sql2016-02-reserved.txt b/doc/src/sgml/keywords/sql2016-02-reserved.txt new file mode 100644 index 00000000000..ae110123881 --- /dev/null +++ b/doc/src/sgml/keywords/sql2016-02-reserved.txt @@ -0,0 +1,367 @@ +ABS +ACOS +ALL +ALLOCATE +ALTER +AND +ANY +ARE +ARRAY +ARRAY_AGG +ARRAY_MAX_CARDINALITY +AS +ASENSITIVE +ASIN +ASYMMETRIC +AT +ATAN +ATOMIC +AUTHORIZATION +AVG +BEGIN +BEGIN_FRAME +BEGIN_PARTITION +BETWEEN +BIGINT +BINARY +BLOB +BOOLEAN +BOTH +BY +CALL +CALLED +CARDINALITY +CASCADED +CASE +CAST +CEIL +CEILING +CHAR +CHAR_LENGTH +CHARACTER +CHARACTER_LENGTH +CHECK +CLASSIFIER +CLOB +CLOSE +COALESCE +COLLATE +COLLECT +COLUMN +COMMIT +CONDITION +CONNECT +CONSTRAINT +CONTAINS +CONVERT +COPY +CORR +CORRESPONDING +COS +COSH +COUNT +COVAR_POP +COVAR_SAMP +CREATE +CROSS +CUBE +CUME_DIST +CURRENT +CURRENT_CATALOG +CURRENT_DATE +CURRENT_DEFAULT_TRANSFORM_GROUP +CURRENT_PATH +CURRENT_ROLE +CURRENT_ROW +CURRENT_SCHEMA +CURRENT_TIME +CURRENT_TIMESTAMP +CURRENT_TRANSFORM_GROUP_FOR_TYPE +CURRENT_USER +CURSOR +CYCLE +DATE +DAY +DEALLOCATE +DEC +DECIMAL +DECFLOAT +DECLARE +DEFAULT +DEFINE +DELETE +DENSE_RANK +DEREF +DESCRIBE +DETERMINISTIC +DISCONNECT +DISTINCT +DOUBLE +DROP +DYNAMIC +EACH +ELEMENT +ELSE +EMPTY +END +END_FRAME +END_PARTITION +END-EXEC +EQUALS +ESCAPE +EVERY +EXCEPT +EXEC +EXECUTE +EXISTS +EXP +EXTERNAL +EXTRACT +FALSE +FETCH +FILTER +FIRST_VALUE +FLOAT +FLOOR +FOR +FOREIGN +FRAME_ROW +FREE +FROM +FULL +FUNCTION +FUSION +GET +GLOBAL +GRANT +GROUP +GROUPING +GROUPS +HAVING +HOLD +HOUR +IDENTITY +IN +INDICATOR +INITIAL +INNER +INOUT +INSENSITIVE +INSERT +INT +INTEGER +INTERSECT +INTERSECTION +INTERVAL +INTO +IS +JOIN +JSON_ARRAY +JSON_ARRAYAGG +JSON_EXISTS +JSON_OBJECT +JSON_OBJECTAGG +JSON_QUERY +JSON_TABLE +JSON_TABLE_PRIMITIVE +JSON_VALUE +LAG +LANGUAGE +LARGE +LAST_VALUE +LATERAL +LEAD +LEADING +LEFT +LIKE +LIKE_REGEX +LISTAGG +LN +LOCAL +LOCALTIME +LOCALTIMESTAMP +LOG +LOG10 +LOWER +MATCH +MATCH_NUMBER +MATCH_RECOGNIZE +MATCHES +MAX +MEASURES +MEMBER +MERGE +METHOD +MIN +MINUTE +MOD +MODIFIES +MODULE +MONTH +MULTISET +NATIONAL +NATURAL +NCHAR +NCLOB +NEW +NO +NONE +NORMALIZE +NOT +NTH_VALUE +NTILE +NULL +NULLIF +NUMERIC +OCTET_LENGTH +OCCURRENCES_REGEX +OF +OFFSET +OLD +OMIT +ON +ONE +ONLY +OPEN +OR +ORDER +OUT +OUTER +OVER +OVERLAPS +OVERLAY +PARAMETER +PARTITION +PATTERN +PER +PERCENT +PERCENT_RANK +PERCENTILE_CONT +PERCENTILE_DISC +PERIOD +PERMUTE +PORTION +POSITION +POSITION_REGEX +POWER +PRECEDES +PRECISION +PREPARE +PRIMARY +PROCEDURE +PTF +RANGE +RANK +READS +REAL +RECURSIVE +REF +REFERENCES +REFERENCING +REGR_AVGX +REGR_AVGY +REGR_COUNT +REGR_INTERCEPT +REGR_R2 +REGR_SLOPE +REGR_SXX +REGR_SXY +REGR_SYY +RELEASE +RESULT +RETURN +RETURNS +REVOKE +RIGHT +ROLLBACK +ROLLUP +ROW +ROW_NUMBER +ROWS +RUNNING +SAVEPOINT +SCOPE +SCROLL +SEARCH +SECOND +SEEK +SELECT +SENSITIVE +SESSION_USER +SET +SHOW +SIMILAR +SIN +SINH +SKIP +SMALLINT +SOME +SPECIFIC +SPECIFICTYPE +SQL +SQLEXCEPTION +SQLSTATE +SQLWARNING +SQRT +START +STATIC +STDDEV_POP +STDDEV_SAMP +SUBMULTISET +SUBSET +SUBSTRING +SUBSTRING_REGEX +SUCCEEDS +SUM +SYMMETRIC +SYSTEM +SYSTEM_TIME +SYSTEM_USER +TABLE +TABLESAMPLE +TAN +TANH +THEN +TIME +TIMESTAMP +TIMEZONE_HOUR +TIMEZONE_MINUTE +TO +TRAILING +TRANSLATE +TRANSLATE_REGEX +TRANSLATION +TREAT +TRIGGER +TRIM +TRIM_ARRAY +TRUE +TRUNCATE +UESCAPE +UNION +UNIQUE +UNKNOWN +UNMATCHED +UNNEST +UPDATE +UPPER +USER +USING +VALUE +VALUES +VALUE_OF +VAR_POP +VAR_SAMP +VARBINARY +VARCHAR +VARYING +VERSIONING +WHEN +WHENEVER +WHERE +WIDTH_BUCKET +WINDOW +WITH +WITHIN +WITHOUT +YEAR diff --git a/doc/src/sgml/keywords/sql2016-09-nonreserved.txt b/doc/src/sgml/keywords/sql2016-09-nonreserved.txt new file mode 100644 index 00000000000..b360f0ce861 --- /dev/null +++ b/doc/src/sgml/keywords/sql2016-09-nonreserved.txt @@ -0,0 +1,23 @@ +BLOCKED +CONTROL +DB +FILE +FS +INTEGRITY +LIBRARY +LIMIT +LINK +MAPPING +OFF +PASSTHROUGH +PERMISSION +RECOVERY +REQUIRING +RESTORE +SELECTIVE +SERVER +TOKEN +UNLINK +VERSION +WRAPPER +YES diff --git a/doc/src/sgml/keywords/sql2016-09-reserved.txt b/doc/src/sgml/keywords/sql2016-09-reserved.txt new file mode 100644 index 00000000000..02054857667 --- /dev/null +++ b/doc/src/sgml/keywords/sql2016-09-reserved.txt @@ -0,0 +1,13 @@ +DATALINK +DLNEWCOPY +DLPREVIOUSCOPY +DLURLCOMPLETE +DLURLCOMPLETEWRITE +DLURLCOMPLETEONLY +DLURLPATH +DLURLPATHWRITE +DLURLPATHONLY +DLURLSCHEME +DLURLSERVER +DLVALUE +IMPORT diff --git a/doc/src/sgml/keywords/sql2016-14-nonreserved.txt b/doc/src/sgml/keywords/sql2016-14-nonreserved.txt new file mode 100644 index 00000000000..00c88ffc57d --- /dev/null +++ b/doc/src/sgml/keywords/sql2016-14-nonreserved.txt @@ -0,0 +1,27 @@ +ABSENT +ACCORDING +BASE64 +BOM +COLUMNS +CONTENT +DOCUMENT +ENCODING +HEX +ID +INDENT +LOCATION +NAMESPACE +NIL +PATH +PRESERVE +RETURNING +SEQUENCE +STANDALONE +STRIP +UNTYPED +URI +VALID +VERSION +WHITESPACE +XMLSCHEMA +XMLDECLARATION diff --git a/doc/src/sgml/keywords/sql2016-14-reserved.txt b/doc/src/sgml/keywords/sql2016-14-reserved.txt new file mode 100644 index 00000000000..cf8052946f9 --- /dev/null +++ b/doc/src/sgml/keywords/sql2016-14-reserved.txt @@ -0,0 +1,20 @@ +XML +XMLAGG +XMLATTRIBUTES +XMLBINARY +XMLCAST +XMLCOMMENT +XMLCONCAT +XMLDOCUMENT +XMLELEMENT +XMLEXISTS +XMLFOREST +XMLITERATE +XMLNAMESPACES +XMLPARSE +XMLPI +XMLQUERY +XMLSERIALIZE +XMLTABLE +XMLTEXT +XMLVALIDATE -- cgit v1.2.3