[
https://issues.apache.org/jira/browse/DERBY-6609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14046045#comment-14046045
]
Knut Anders Hatlen commented on DERBY-6609:
-------------------------------------------
{quote}
Are the terms "entry-level" and "higher-level" still meaningful in the current
standard?
{quote}
I don't find any mentioning of entry-level features in SQL:2011. It does have
the concept "Core SQL", which seems to be essentially all mandatory features in
part 2 and part 11, plus it has some lists of optional features where at least
one feature in each list has to be supported in order to claim conformance. It
doesn't look like Derby supports all the required features, though. I don't
think it would be a lie to say that Derby supports "most of" or "a large part
of" the core SQL language. Although it might suffice to say that Derby supports
many SQL features, and not mention any specific levels or subsets that are
fully or almost fully supported.
> 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
> Assignee: Kim Haase
> Attachments: DERBY-6609-2.diff, DERBY-6609-2.zip, DERBY-6609-3.diff,
> DERBY-6609-3.diff, DERBY-6609-3.stat, DERBY-6609-3.zip, DERBY-6609-3.zip,
> DERBY-6609-4.diff, DERBY-6609-4.stat, DERBY-6609-4.zip, 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)
