db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.
Date Fri, 16 Feb 2007 19:55:05 GMT

    [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12473806

Laura Stewart commented on DERBY-264:

Need more information to update the ORDER BY clause topic - http://db.apache.org/derby/docs/dev/ref/

I glanced through the thread that Oystein pointed me to, but did not 
find what I need.

1.  The type of expressions that are allowed.  My impression is that they are the Boolean
expressions (as opposed to TableExpressions or SelectExpressions)?

2. I need to understand how the Syntax for ORDER BY should appear.  Should it just be "Expressions"
added immediately after ColumnPosition (in both places in the Syntax?  Are there limitations
as to the types of expressions allowed?  Boolean, concatenation?

3. Description of the expressions allowed (will appear below the syntax)  This will depend
on what type of expressions are allowed, but one thing that the other parameters mention is
if the column needss to be in the select list. 

4. Whatever type of expressions are allowed, that topic in the Derby Ref Guide needs to be
updated too.   Are there any limitations for ORDER BY?  For example, the Boolean expressions
topic mentions that there are limitations with check constraints. 


> This enhancement to allow expressions in ORDER BY clause will require documentation changes.
> --------------------------------------------------------------------------------------------
>                 Key: DERBY-264
>                 URL: https://issues.apache.org/jira/browse/DERBY-264
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Documentation
>    Affects Versions:,
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
> I can help if needed for documenting this enhancement.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message