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-6605) "Derby support for SQL-92 features" topic in Reference Manual needs updating
Date Tue, 10 Jun 2014 14:22:02 GMT

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

Knut Anders Hatlen commented on DERBY-6605:

I went through the new features sections of the release notes for 10.x.1 where 4 <= x <=
10 and updated the wiki page accordingly. It was mostly up to date.

However, we have added some features that were added to the standard later than SQL:2003 (such
as SQL:2008 or SQL:2011), and they don't fit in the table on the wiki page, or in the reference
manual, currently. The ones I found were:

F200, “TRUNCATE TABLE statement”
F851, “<order by clause> in subqueries”
F852, “Top-level <order by clause> in views”
F855, “Nested <order by clause> in <query expression>”
F856, “Nested <fetch first clause> in <query expression>”
F857, “Top-level <fetch first clause> in <query expression>”
F858, “<fetch first clause> in subqueries”
F859, “Top-level <fetch first clause> in views”
F860, “dynamic <fetch first row count> in <fetch first clause>”
F861, “Top-level <result offset clause> in <query expression>”
F862, “<result offset clause> in subqueries”
F863, “Nested <result offset clause> in <query expression>”
F864, “Top-level <result offset clause> in views”
F865, “dynamic <offset row count> in <result offset clause>”

> "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:
>            Reporter: Kim Haase
>            Assignee: Kim Haase
>            Priority: Minor
> 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

View raw message