[
https://issues.apache.org/jira/browse/DERBY-6609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14030621#comment-14030621
]
Knut Anders Hatlen commented on DERBY-6609:
-------------------------------------------
{quote}
Would there be any value in a separate topic listing unimplemented features,
just so people can verify that we didn't just forget to include them in the
table? Or would retrieving a list of unimplemented features new in SQL:2011 be
too hard?
{quote}
I think it would be relatively easy to extract the feature list. It can be
found in two tables (Table 38, “Feature taxonomy and definition for mandatory
features” and Table 39, “Feature taxonomy for optional features”). Those two
tables take 30 pages in standard, though, so it might become a very long topic,
although we'll probably be able to compress it somewhat.
I see that PostgreSQL has such a list in their manual:
http://www.postgresql.org/docs/9.3/interactive/unsupported-features-sql-standard.html
{quote}
In the wiki, I see some features are shown as No for SQL-99 and as N/A for
SQL-2003. Does this mean that the feature was dropped from the SQL standard at
SQL-2003?
{quote}
I'm not sure what happened to F811 Extended flagging and T541 Updatable table
references. The other N/A features seem to have been moved from Part 2
(Foundation) to Part 11 (Schemata) in SQL:2003, so they're still part of the
standard (with the same feature numbers), just in a different book.
> Documentation for SQL features should reflect current standard
> --------------------------------------------------------------
>
> Key: DERBY-6609
> URL: https://issues.apache.org/jira/browse/DERBY-6609
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.11.0.0
> Reporter: Kim Haase
>
> We document Derby as an SQL-92 database. This standard is now very old, and
> we should describe how Derby conforms to the most current standard
> (SQL:2011). Knut Anders Hatlen listed the relevant features in a comment to
> DERBY-6605.
> This will involve at a minimum replacing the "Derby support for SQL-92
> features" topic
> (http://db.apache.org/derby/docs/10.10/ref/rrefsql9241891.html) with a new
> one that describes Derby's support for current features, with notes as needed
> indicating when the support is partial. Only features Derby supports, fully
> or partially, should be listed. We should state that features not listed are
> not supported.
> The information would be taken from
> http://wiki.apache.org/db-derby/SQLvsDerbyFeatures (which currently goes only
> through the 2003 standard). Listing the Feature IDs in the documentation
> would also be helpful.
> Other topics should be changed as needed. For example, is the term
> "SQL92Identifier" still correct?
--
This message was sent by Atlassian JIRA
(v6.2#6252)
