db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5499) Document the new JDBC limit/offset escape syntax
Date Thu, 29 Mar 2012 12:36:26 GMT

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

Rick Hillegas commented on DERBY-5499:
--------------------------------------

Thanks for the patch, Kim. It looks good.

I stumbled over one small issue in the first paragraph under "Syntax". That paragraph repeats
some material about FETCH NEXT from the functional spec. That material only makes sense to
me if it is preceded by the explanation which appears under "Equivalent to". I would either
move the "Equivalent to" material higher up or I would reword this paragraph to something
like this:

"The rowCount is a non-negative integer that specifies the number of rows to return. If rowCount
is 0, then all rows from startRow forward are returned."

Thanks,
-Rick

                
> Document the new JDBC limit/offset escape syntax
> ------------------------------------------------
>
>                 Key: DERBY-5499
>                 URL: https://issues.apache.org/jira/browse/DERBY-5499
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.9.0.0
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>         Attachments: DERBY-5499.diff, DERBY-5499.stat, DERBY-5499.zip
>
>
> The work on DERBY-5488 adds new JDBC escape syntax for the limit/offset clauses. These
should be documented, probably in the Reference Guide as a subsection of JDBC escape syntax.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message