I just found typo of <overlaps predicate part 1> or <overlaps predicate part 2> .
In sql-2003-2.bnf,the below lines uses <overlaps predicate part> but no definition in BNF.
<case operand> ::= <row value predicand> | <overlaps predicate part>
But there is <overlaps predicate part 1>,<overlaps predicate part2> definition in BNF.
<overlaps predicate part 1> ::= <row value predicand 1>

<overlaps predicate part 2> ::= OVERLAPS <row value predicand 2>

I just found typo of <multset value expression> or <multiset value expression> .
In sql-2003-2.bnf,the below lines uses <multset value expression> but no definition in BNF.
<multiset element reference> ::=
ELEMENT <left paren> <multset value expression> <right paren>

But there is <multiset value expression> definition in BNF.
<multiset value expression> ::=
<multiset term>
| <multiset value expression> MULTISET UNION [ ALL | DISTINCT ] <multiset term>
| <multiset value expression> MULTISET EXCEPT [ ALL | DISTINCT ] <multiset term>

Found another error. Typo: CONSTRATIN_CATALOG

Should obviously(?) be CONSTRAINT_CATALOG. Will submit a pull request.

At line 220 of sql-2003-2.bnf,<bit string literal> is used.
But there is no definition.

At line 1539 of sql-2003-2.bnf,<overlaps predicate part> is used.
But there is no definition of <overlaps predicate part>.

Hello,

It would be great if railroad diagrams (like sqlite's) were included on the webpage.

Here is a nice JS generator for railroad diagrams: https://github.com/tabatkins/railroad-diagrams

Thanks for considering!

The document sql-2003-2.bnf.html and many other documents on the web contain !! See Syntax Rules, but I'm not able to find them. Where do I find the definition of these rules?

At https://github.com/ronsavage/SQL/blob/master/sql-2003-2.bnf#L1344-L1346 <path-resolved user-defined type name> seems to be duplicated

Edit:
Also <character set specification list> at L4491 and L5307
and <item number> at L5422 and L5356

Does your <single datetime field> in your SQL92.bnf file have an extra <left paren> that it should not have?

This line in your BNF has the following (I wrapped it so that it would not create a horizontal scroll in the issue):

|  SECOND [ <left paren> <interval leading field precision> 
   [ <comma> <left paren> <interval fractional seconds precision> ] <right paren> ]

However, the equivalent line for SQL99 has the following:

| SECOND [ <left paren> <interval leading field precision> 
   [ <comma> <interval fractional seconds precision> ] <right paren> ]   

Can I assume the <left paren> that comes after the <comma> is an error in your SQL92 file?

I'll be happy to create a pull request if you confirm that it is an error and I am understanding correctly what it should be.

At line 4472 of sql-2003-2.bnf,<module collation> may be typo for <module collations>.

<SQL-client module definition> ::=
		<module name clause> <language clause> <module authorization clause>
		[ <module path specification> ]
		[ <module transform group specification> ]
		[ <module collation> ]
		~~~~~~here~~~~~~~~~~~~~~~~
		[ <temporary table declaration>... ]
		<module contents>...

At line 4487 of sql-2003-2.bnf,<module collations> is defined,but <module collation> is not found.

<module collations> ::= <module collation specification>...

Starting at line 5330 of sql-2003-2.bnf (the plaintext one), there are a few unclosed "--h2" tags. (would expect to see a --/h2 for each)

I just found typo of <module collation> or <module collations> .

In sql-2003-2.bnf,the below lines uses <module collation> but no definition in BNF.
<SQL-client module definition> ::=
<module name clause> <language clause> <module authorization clause>
[ <module path specification> ]
[ <module transform group specification> ]
[ <module collation> ]
[ <temporary table declaration>... ]
<module contents>...

But there is <module collations> definition in BNF.
<module collations> ::= <module collation specification>...

Hi, would you mind looking into re-exporting the HTML using github pages?

There's more info here:
https://pages.github.com/ (search for project page)

Hi all,
at sql-2003-2.bnf.html#select list:

<select list> ::= <asterisk> | <select sublist> [ { <comma> <select sublist> }... ]
mean <asterisk> **or** <select sublist> [ { <comma> <select sublist> }... ]
but SQL accept :
<select list> ::= <asterisk> | <asterisk> <select sublist> [ { <comma> <select sublist> }... ]
regards