On Tue, Oct 26, 2004 at 10:18:09AM -0000, kartinku wrote:

>
> DatabaseMetaData.getSQLKeywords() contains only partial set of
> keywords. Many key words are missing . I referred
> "FBDatabaseMetaData.java" (1.5.3 version). In that for fbSQLKeywords
> you have all the set of key words but most of them are commented. Is
> it intentional or Bug?

The reason that most of the keywords are commented out can be found in the
javadoc for the getSQLKeywords method:

* Gets a comma-separated list of all a database's SQL keywords
* that are NOT also SQL92 keywords.

Also, the javadoc for fbSQLKeywords states:

* Derived from firebird2/src/dsql/keywords.cpp.
* Exclusions from list of sql-92 keywords in SQL Instant Reference,
* Martin Gruber (1993) Sybex.


Thus, the commented-out keywords are commented out because they are
SQL92 keywords.


Gabriel