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

[JIRA]

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