There are some newer database features, which are only available for certain
database versions. For example the proposed solution for implementing LIMIT and
OFFSET using Oracle database connects in Bug 1732 is only available for
versions of 8.1.6 or above. Currently the functions isLimitClauseSupported()
and isOffsetClauseSupported() always return the value 'true'.
Wouldn't it be possible to look first at the database version, to determine if
the keywords can be supported?
I think, it would be better to look at the information obtained by
DatabaseMetaData.getDatabaseProductVersion() to determine if the used database
really supports the required features.