[
https://issues.apache.org/jira/browse/DERBY-6609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14032499#comment-14032499
]
Knut Anders Hatlen commented on DERBY-6609:
-------------------------------------------
{quote}
Interesting. So the letters E, T, F and so on are just artifacts of previous
versions but don't really mean anything any more, though each new feature gets
one anyway?
{quote}
I don't know the answer to that, but I'm not able to find any description of
what the letters mean in 2011. It looks like the E features are all mandatory.
The B prefix is only used in optional features. F, S and T are used both in
mandatory and optional features.
SQL:2011, part 1, 6.3.8 Feature ID and Feature Name says that features are
either standard-defined or implementation-defined, and standard-defined
features are either mandatory or optional. It describes the format of a Feature
ID, and says the prefix "V" is reserved for implementation-defined features. No
mentioning of any other letters.
> 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
> Attachments: DERBY-6609.diff, DERBY-6609.stat, DERBY-6609.zip
>
>
> 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)
