db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6609) Documentation for SQL features should reflect current standard
Date Mon, 16 Jun 2014 13:18:02 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14032416#comment-14032416
] 

Knut Anders Hatlen commented on DERBY-6609:
-------------------------------------------

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)

Mime
View raw message