You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2005/05/06 21:57:05 UTC

[jira] Created: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

This enhancement to allow expressions in ORDER BY clause will require documentation changes.
--------------------------------------------------------------------------------------------

         Key: DERBY-264
         URL: http://issues.apache.org/jira/browse/DERBY-264
     Project: Derby
        Type: Sub-task
  Components: Documentation  
    Versions: 10.1.0.0    
    Reporter: Satheesh Bandaram
    Priority: Minor
     Fix For: 10.1.0.0


I can help if needed for documenting this enhancement.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-264:
--------------------------------

    Derby Info: [Patch Available]

> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby264_1.diff, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Resolved: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart resolved DERBY-264.
---------------------------------

       Resolution: Fixed
    Fix Version/s: 10.3.0.0
       Derby Info:   (was: [Patch Available])

Committed revision 513085.

> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: derby264-html2.zip, derby264_1.diff, derby264_2.diff, derby264_3.diff, derby264_html3.zip, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-264?page=all ]

Rick Hillegas updated DERBY-264:
--------------------------------

    Fix Version/s: 10.2.3.0
                       (was: 10.2.2.0)

Move to 10.2.3.0.

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
    [ 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. 

Thanks!


> 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: 10.1.1.0, 10.2.1.6
>            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.


[jira] Closed: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart closed DERBY-264.
-------------------------------


> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: derby264-html2.zip, derby264_1.diff, derby264_2.diff, derby264_3.diff, derby264_html3.zip, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-264?page=comments#action_12449753 ] 
            
Laura Stewart commented on DERBY-264:
-------------------------------------

Can someone please explain what needs to be documented? 
I cannot find the thread that is mentioned in Derby134 and there isn't any explanation of what was changed.

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-264?page=all ]

Rick Hillegas updated DERBY-264:
--------------------------------

    Urgency: Low

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-264:
--------------------------------

    Attachment: derby264-html2.zip
                derby264_2.diff

Attaching a patch and a zip file with the html output.
3 files were updated.

Filename              Title                                      Improvements 
rrefsqlj13658       ORDER BY clause            Added expressions to syntax and examples
rrefsqlj19433       SQL Expressions              Added ORDER BY clause, improved index entries, reformatted tables
rrefsqlj23075       Boolean expressions       Corrected link

The diff file for rrefsqlj19433 will be hard to read. I really rearranged the tables in this file to make the info easier to find.  Please see the html output.

> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby264-html2.zip, derby264_1.diff, derby264_2.diff, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Øystein Grøvlen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12467328 ] 

Øystein Grøvlen commented on DERBY-264:
---------------------------------------

I think this is what needs to be documented:

     Pre 10.1, the 'ORDER BY' clause of a select statement could only
     contain column references, by name or number.  E.g, 

         SELECT i FROM t ORDER BY i;
         SELECT i FROM t ORDER BY 1;

     Now, expressions are also allowed in the ORDER BY clause.  E.g.,
         
         SELECT i, j FROM t ORDER BY i+j;
         SELECT i, j FROM t ORDER BY f(i);

The documentation for the ORDER BY clause (http://db.apache.org/derby/docs/dev/ref/rrefsqlj13658.html) needs to be  updated to reflect this change.

> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>            Priority: Minor
>             Fix For: 10.2.3.0
>
>
> 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.


[jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12474620 ] 

Yip Ng commented on DERBY-264:
------------------------------

Hi Laura:

I think the following statement can be separated out from the "expression" description and moved it before the Example section since it applies to column-name as well.

"If SELECT DISTINCT is specified or if the SELECT statement contains a GROUP BY clause, the ORDER BY columns must be in the SELECT list."

For the examples, perhaps the following may suffice?


You can sort the result set by a numeric expression, for example:

 SELECT name, salary, bonus FROM employee ORDER BY salary+bonus

where salary and bonus are of decimal type.

You can sort the result set by invoking a function, for example:

  SELECT i, len FROM measures ORDER BY sin(i)









> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby264_1.diff, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-264:
--------------------------------

    Attachment: derby264_3.diff
                derby264_html3.zip

Attaching the 3rd version of this patch and html files based on the comments from Yip.

> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby264-html2.zip, derby264_1.diff, derby264_2.diff, derby264_3.diff, derby264_html3.zip, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Øystein Grøvlen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12467318 ] 

Øystein Grøvlen commented on DERBY-264:
---------------------------------------

Laura Stewart writes:
> Can someone please explain what needs to be documented?
> I cannot find the thread that is mentioned in Derby134 and there isn't any explanation of what was changed.

I am not sure if it is of much help, but the thread being referred to can be found at:
http://thread.gmane.org/gmane.comp.apache.db.derby.devel/1897


> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>            Priority: Minor
>             Fix For: 10.2.3.0
>
>
> 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.


[jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12475608 ] 

Yip Ng commented on DERBY-264:
------------------------------

Hi Laura:

I think in the numeric example of the ORDER BY clause ref page, the following statement:

"In this example, the salary and bonus columns must contain DECIMAL data types."

may be better stated with the following:

"In this example, the salary and bonus columns are of DECIMAL data types."  






> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby264-html2.zip, derby264_1.diff, derby264_2.diff, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-264:
--------------------------------

    Attachment: rrefsqlj19433.html
                rrefsqlj13658.html
                derby264_1.diff

Attaching a draft of the patch for reivew.

There are 2 files updated with this patch, the "ORDER BY clause" topic and the "SQL expressions" topic.

There is an open question in the examples in the file rrefsqlj13658.html (ORDER BY clause) which I need help with.

> 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: 10.1.1.0, 10.2.1.6
>            Reporter: Satheesh Bandaram
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby264_1.diff, rrefsqlj13658.html, rrefsqlj19433.html
>
>
> 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.


[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-264?page=all ]

Rick Hillegas updated DERBY-264:
--------------------------------

    Fix Version/s: 10.2.2.0
                       (was: 10.2.1.0)

Moving to 10.2.2.0.

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Assigned: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart reassigned DERBY-264:
-----------------------------------

    Assignee: Laura Stewart

> 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: 10.1.1.0, 10.2.1.6
>            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.


[jira] Commented: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12474254 ] 

Laura Stewart commented on DERBY-264:
-------------------------------------

Posted a separate request on derby-dev with the questions I needed help with.

Yip Ng responded with:

Yip Ng <yi...@gmail.com>  to derby-dev 

On 2/16/07, Laura Stewart <sc...@gmail.com> wrote:

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


ORDER BY expression is not limited to boolean expression only.  It can contain
common value expression such as numeric, string, datetime, etc.  It can also
have row value expression such as a scalar subquery, case expression, etc.



> 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? Or should it be specific type of
> expression (TableExpression, SelectExpression, Boolean Expression).
> Are there limitations as to the types of expressions allowed? Boolean,
> concatenation?


Perhaps the name sort-key expression would be more appropriate?
Adding it after Column Position is fine.


> 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 needs to
> be in the select list. I need help describing the expressions
> parameter.


> 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.
>


Yes, there are restrictions.  If SELECT DISTINCT is specified or the
SELECT statement contains a GROUP BY clause, the ORDER BY columns need
to appear in the SELECT list.

I think there is a bug in Derby in the DISTINCT with ORDER BY case and
I have filed a jira for this.  See DERBY-2351 for further details.

Hope this helps.

Regards,

Yip Ng
 

> 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: 10.1.1.0, 10.2.1.6
>            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.


[jira] Updated: (DERBY-264) This enhancement to allow expressions in ORDER BY clause will require documentation changes.

Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-264?page=all ]

Andrew McIntyre updated DERBY-264:
----------------------------------

    Fix Version: 10.2.0.0
                     (was: 10.1.1.0)
        Version: 10.2.0.0
    Environment: 

Moving to 10.2 as it appears no one is currently working on this.

> This enhancement to allow expressions in ORDER BY clause will require documentation changes.
> --------------------------------------------------------------------------------------------
>
>          Key: DERBY-264
>          URL: http://issues.apache.org/jira/browse/DERBY-264
>      Project: Derby
>         Type: Sub-task
>   Components: Documentation
>     Versions: 10.2.0.0, 10.1.1.0
>     Reporter: Satheesh Bandaram
>     Priority: Minor
>      Fix For: 10.2.0.0

>
> I can help if needed for documenting this enhancement.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira