[
https://issues.apache.org/jira/browse/DERBY-6609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14044972#comment-14044972
]
Kim Haase commented on DERBY-6609:
----------------------------------
Here's another one that I'm not sure how to reword, from the "Application
development overview" topic of the Developer's Guide:
SQL-92 is the version of SQL standardized by ANSI and ISO in 1992; Derby
supports entry-level SQL-92 as well as some higher-level features. Entry-level
SQL-92 is a subset of full SQL-92 specified by ANSI and ISO that is supported
by nearly all major DBMSs today.
Are the terms "entry-level" and "higher-level" still meaningful in the current
standard? Would it be correct to simplify this to the following, or is more
rewording needed?
SQL is standardized by ANSI and ISO; Derby supports entry-level SQL as well as
some higher-level features. Entry-level SQL is a subset of full SQL specified
by ANSI and ISO that is supported by nearly all major DBMSs today.
> 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.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)
