NotificationsYou must be signed in to change notification settings
Fork4.9k
Star17.7k

Commitc29ba98

committed

Update SQL keywords list to SQL:2016

Per previous convention (seeace397e), drop SQL:2008 and only keepthe latest two standards and SQL-92.Note: SQL:2016-2 lists a large number of non-reserved keywords thatare really just information_schema column names related to newfeatures. Those kinds of thing have not previously been listed askeywords, and this was apparently done here by mistake, since thesekeywords have been removed again in post-2016 working drafts. So inorder to avoid bloating the keywords table unnecessarily, I haveomitted these erroneous keywords here.

1 parent356c837 commitc29ba98Copy full SHA for c29ba98

File tree

7 files changed

+95

-7

lines changed

doc/src/sgml
- generate-keywords-table.pl
- keywords

7 files changed

+95

-7

lines changed

`‎doc/src/sgml/generate-keywords-table.pl`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -6,7 +6,7 @@`
`6`	`6`	`use strict;`
`7`	`7`	`use warnings;`
`8`	`8`
`9`		`-my@sql_versions =reversesort ('1992','2008','2011');`
	`9`	`+my@sql_versions =reversesort ('1992','2011','2016');`
`10`	`10`
`11`	`11`	`my$srcdir =$ARGV[0];`
`12`	`12`

`‎doc/src/sgml/keywords/sql2008-02-nonreserved.txtrenamed to‎doc/src/sgml/keywords/sql2016-02-nonreserved.txt`

Lines changed: 32 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,6 +19,7 @@ CASCADE`
`19`	`19`	`CATALOG`
`20`	`20`	`CATALOG_NAME`
`21`	`21`	`CHAIN`
	`22`	`+CHAINING`
`22`	`23`	`CHARACTER_SET_CATALOG`
`23`	`24`	`CHARACTER_SET_NAME`
`24`	`25`	`CHARACTER_SET_SCHEMA`
`@@ -30,10 +31,12 @@ COLLATION`
`30`	`31`	`COLLATION_CATALOG`
`31`	`32`	`COLLATION_NAME`
`32`	`33`	`COLLATION_SCHEMA`
	`34`	`+COLUMNS`
`33`	`35`	`COLUMN_NAME`
`34`	`36`	`COMMAND_FUNCTION`
`35`	`37`	`COMMAND_FUNCTION_CODE`
`36`	`38`	`COMMITTED`
	`39`	`+CONDITIONAL`
`37`	`40`	`CONDITION_NUMBER`
`38`	`41`	`CONNECTION`
`39`	`42`	`CONNECTION_NAME`
`@@ -42,7 +45,6 @@ CONSTRAINT_NAME`
`42`	`45`	`CONSTRAINT_SCHEMA`
`43`	`46`	`CONSTRAINTS`
`44`	`47`	`CONSTRUCTOR`
`45`		`-CONTAINS`
`46`	`48`	`CONTINUE`
`47`	`49`	`CURSOR_NAME`
`48`	`50`	`DATA`
`@@ -63,15 +65,21 @@ DISPATCH`
`63`	`65`	`DOMAIN`
`64`	`66`	`DYNAMIC_FUNCTION`
`65`	`67`	`DYNAMIC_FUNCTION_CODE`
`66`		`-EQUALS`
	`68`	`+ENCODING`
	`69`	`+ENFORCED`
	`70`	`+ERROR`
`67`	`71`	`EXCLUDE`
`68`	`72`	`EXCLUDING`
	`73`	`+EXPRESSION`
`69`	`74`	`FINAL`
	`75`	`+FINISH`
`70`	`76`	`FIRST`
`71`	`77`	`FLAG`
`72`	`78`	`FOLLOWING`
	`79`	`+FORMAT`
`73`	`80`	`FORTRAN`
`74`	`81`	`FOUND`
	`82`	`+FULFILL`
`75`	`83`	`G`
`76`	`84`	`GENERAL`
`77`	`85`	`GENERATED`
`@@ -81,6 +89,7 @@ GRANTED`
`81`	`89`	`HIERARCHY`
`82`	`90`	`IGNORE`
`83`	`91`	`IMMEDIATE`
	`92`	`+IMMEDIATELY`
`84`	`93`	`IMPLEMENTATION`
`85`	`94`	`INCLUDING`
`86`	`95`	`INCREMENT`
`@@ -91,8 +100,11 @@ INSTANTIABLE`
`91`	`100`	`INSTEAD`
`92`	`101`	`INVOKER`
`93`	`102`	`ISOLATION`
	`103`	`+JSON`
`94`	`104`	`K`
	`105`	`+KEEP`
`95`	`106`	`KEY`
	`107`	`+KEYS`
`96`	`108`	`KEY_MEMBER`
`97`	`109`	`KEY_TYPE`
`98`	`110`	`LAST`
`@@ -111,6 +123,7 @@ MORE`
`111`	`123`	`MUMPS`
`112`	`124`	`NAME`
`113`	`125`	`NAMES`
	`126`	`+NESTED`
`114`	`127`	`NESTING`
`115`	`128`	`NEXT`
`116`	`129`	`NFC`
`@@ -129,6 +142,7 @@ ORDERING`
`129`	`142`	`ORDINALITY`
`130`	`143`	`OTHERS`
`131`	`144`	`OUTPUT`
	`145`	`+OVERFLOW`
`132`	`146`	`OVERRIDING`
`133`	`147`	`P`
`134`	`148`	`PAD`
`@@ -140,14 +154,21 @@ PARAMETER_SPECIFIC_NAME`
`140`	`154`	`PARAMETER_SPECIFIC_SCHEMA`
`141`	`155`	`PARTIAL`
`142`	`156`	`PASCAL`
	`157`	`+PASS`
	`158`	`+PASSING`
	`159`	`+PAST`
`143`	`160`	`PATH`
`144`	`161`	`PLACING`
	`162`	`+PLAN`
`145`	`163`	`PLI`
`146`	`164`	`PRECEDING`
`147`	`165`	`PRESERVE`
`148`	`166`	`PRIOR`
	`167`	`+PRIVATE`
`149`	`168`	`PRIVILEGES`
	`169`	`+PRUNE`
`150`	`170`	`PUBLIC`
	`171`	`+QUOTES`
`151`	`172`	`READ`
`152`	`173`	`RELATIVE`
`153`	`174`	`REPEATABLE`
`@@ -158,12 +179,14 @@ RETURNED_CARDINALITY`
`158`	`179`	`RETURNED_LENGTH`
`159`	`180`	`RETURNED_OCTET_LENGTH`
`160`	`181`	`RETURNED_SQLSTATE`
	`182`	`+RETURNING`
`161`	`183`	`ROLE`
`162`	`184`	`ROUTINE`
`163`	`185`	`ROUTINE_CATALOG`
`164`	`186`	`ROUTINE_NAME`
`165`	`187`	`ROUTINE_SCHEMA`
`166`	`188`	`ROW_COUNT`
	`189`	`+SCALAR`
`167`	`190`	`SCALE`
`168`	`191`	`SCHEMA`
`169`	`192`	`SCHEMA_NAME`
`@@ -185,12 +208,14 @@ SPACE`
`185`	`208`	`SPECIFIC_NAME`
`186`	`209`	`STATE`
`187`	`210`	`STATEMENT`
	`211`	`+STRING`
`188`	`212`	`STRUCTURE`
`189`	`213`	`STYLE`
`190`	`214`	`SUBCLASS_ORIGIN`
`191`	`215`	`T`
`192`	`216`	`TABLE_NAME`
`193`	`217`	`TEMPORARY`
	`218`	`+THROUGH`
`194`	`219`	`TIES`
`195`	`220`	`TOP_LEVEL_COUNT`
`196`	`221`	`TRANSACTION`
`@@ -205,14 +230,19 @@ TRIGGER_SCHEMA`
`205`	`230`	`TYPE`
`206`	`231`	`UNBOUNDED`
`207`	`232`	`UNCOMMITTED`
	`233`	`+UNCONDITIONAL`
`208`	`234`	`UNDER`
`209`	`235`	`UNNAMED`
`210`	`236`	`USAGE`
`211`	`237`	`USER_DEFINED_TYPE_CATALOG`
`212`	`238`	`USER_DEFINED_TYPE_CODE`
`213`	`239`	`USER_DEFINED_TYPE_NAME`
`214`	`240`	`USER_DEFINED_TYPE_SCHEMA`
	`241`	`+UTF16`
	`242`	`+UTF32`
	`243`	`+UTF8`
`215`	`244`	`VIEW`
`216`	`245`	`WORK`
	`246`	`+WRAPPER`
`217`	`247`	`WRITE`
`218`	`248`	`ZONE`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitc29ba98

File tree

7 files changed

7 files changed

`‎doc/src/sgml/generate-keywords-table.pl`

`‎doc/src/sgml/keywords/sql2008-02-nonreserved.txtrenamed to‎doc/src/sgml/keywords/sql2016-02-nonreserved.txt`

0 commit comments