db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6605) "Derby support for SQL-92 features" topic in Reference Manual needs updating
Date Wed, 11 Jun 2014 20:46:02 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kim Haase updated DERBY-6605:
-----------------------------

    Attachment: DERBY-6605.diff
                rrefsql9241891.html

Attaching DERBY-6605.diff and rrefsql9241891.html, a preliminary patch for this issue.

M       src/ref/rrefsql9241891.dita

I added a shortdesc and made a few other formatting tweaks near the top, but I found only
a couple of things to change.

Are deferrable constraints part of SQL92E or SQL92F? On the wiki page they are shown as F,
but for a later version of the standard. I am guessing they were in SQL-92 in some form, since
DERBY-532 was filed pretty early and they have been mentioned (as unsupported) in the "Derby
support for SQL-92 features" topic.

I added support for NATURAL JOIN. When did CROSS JOIN come into SQL -- after 92? It's not
listed in the table as unsupported.

What should I say about scrolled cursors? The table says "Partial support (scrollable insensitive
result sets through JDBC 2.0)". That seems outdated.

I didn't see anything else that looked obvious. Please let me know what needs changing. Thanks!


> "Derby support for SQL-92 features" topic in Reference Manual needs updating
> ----------------------------------------------------------------------------
>
>                 Key: DERBY-6605
>                 URL: https://issues.apache.org/jira/browse/DERBY-6605
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.11.0.0
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>            Priority: Minor
>         Attachments: DERBY-6605.diff, rrefsql9241891.html
>
>
> The topic "Derby support for SQL-92 features" in the Reference Manual (http://db.apache.org/derby/docs/10.10/ref/rrefsql9241891.html)
seems not to have been substantively updated since about 2007.
> For one thing, the parenthesis "(non-deferrable)" needs to be removed from Table 8 (constraint
support). Also, I think we've supported natural joins for some time. 
> Could someone more knowledgeable than I am go through the items marked "No" and see if
any more need updating? I think those two might be the only ones, but I am not quite sure.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message