[
https://issues.apache.org/jira/browse/DERBY-6609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14032416#comment-14032416
]
Knut Anders Hatlen edited comment on DERBY-6609 at 6/16/14 1:27 PM:
--------------------------------------------------------------------
The wiki lists these features, which are not listed in SQL:2011 part 2:
Mandatory:
F021 Basic information schema
F021-01 COLUMNS view
F021-02 TABLES view
F021-03 VIEWS view
F021-04 TABLE_CONSTRAINTS view
F021-05 REFERENTIAL_CONSTRAINTS
F021-06 CHECK_CONSTRAINTS
F501 Features and conformance views
F501-01 SQL_FEATURES view
F501-02 SQL_SIZING view
F501-03 SQL_LANGUAGES view
S011-01 USER_DEFINED_TYPES view
T321-06 ROUTINES view
T321-07 PARAMETERS view
Optional:
F231 Privilege tables
F231-01 TABLE_PRIVILEGES view
F231-02 COLUMN_PRIVILEGES view
F231-03 USAGE_PRIVILEGES view
F341 Usage tables
F502 Enhanced documentation tables
F502-01 SQL_SIZING_PROFILES view
F502-02 SQL_IMPLEMENTATION_INFO view
F502-03 SQL_PACKAGES view
F691 Collation and translation
F696 Additional translation documentation
F811 Extended flagging
T011 Timestamp in Information Schema
T052 MAX and MIN for row types
T322 Overloading of SQL-invoked functions and procedures
T541 Updatable table references
was (Author: knutanders):
The wiki lists these features, which are not listed in SQL:2011 part 2:
Mandatory:
F021 Basic information schema
F021-01 COLUMNS view
F021-02 TABLES view
F021-03 VIEWS view
F021-04 TABLE_CONSTRAINTS view
F021-05 REFERENTIAL_CONSTRAINTS
F021-06 CHECK_CONSTRAINTS
F501 Features and conformance views
F501-01 SQL_FEATURES view
F501-02 SQL_SIZING view
F501-03 SQL_LANGUAGES view
S011-01 USER_DEFINED_TYPES view
T321-06 ROUTINES view
T321-07 PARAMETERS view
T632 IN predicate with one list element
Optional:
F231 Privilege tables
F231-01 TABLE_PRIVILEGES view
F231-02 COLUMN_PRIVILEGES view
F231-03 USAGE_PRIVILEGES view
F341 Usage tables
F502 Enhanced documentation tables
F502-01 SQL_SIZING_PROFILES view
F502-02 SQL_IMPLEMENTATION_INFO view
F502-03 SQL_PACKAGES view
F691 Collation and translation
F696 Additional translation documentation
F811 Extended flagging
T011 Timestamp in Information Schema
T052 MAX and MIN for row types
T322 Overloading of SQL-invoked functions and procedures
T541 Updatable table references
> 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)
