Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <31587256.48981272424472286.JavaMail.jira@thor>
Date: Tue, 27 Apr 2010 23:14:32 -0400 (EDT)
From: "C.S. Nirmal J. Fernando (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-4371) Non-selected columns for SELECT
 DISTINCT allowed in ORDER BY clause if ordered by expression
In-Reply-To: <809488972.1252323237535.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

C.S. Nirmal J. Fernando commented on DERBY-4371:
------------------------------------------------

Thanks Bryan for help me out to read this.

So, I found that the line 1736 is referred to the query: select distinct c1, c2 from t1 order by c1+1;

According to the standards this should fail with the error I created:

ERROR 42879: The ORDER BY clause may not contain column 'expression', since the query specifies DISTINCT and that column does
not appear in the query result.

But it expects the query to be pass and output this:

C1         |C2        
----------------------
1          |c         
2          |b         
3          |a         
4          |c  

So, I think we need to modify this test, isn't it? Isn't this the place I need to add additional queries to test the functionality of the modified code?

Thanks.
 

> Non-selected columns for SELECT DISTINCT allowed in ORDER BY clause if ordered by expression
> --------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4371
>                 URL: https://issues.apache.org/jira/browse/DERBY-4371
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.5.1.1
>            Reporter: Bernt M. Johnsen
>            Assignee: C.S. Nirmal J. Fernando
>            Priority: Critical
>         Attachments: DERBY-4371-2.diff, DERBY-4371.diff
>
>
> How to repeat:
> ij> create table t (i integer, j integer);;
> 0 rows inserted/updated/deleted
> ij> insert into t values (1,2),(1,3);
> 2 rows inserted/updated/deleted
> ij> select distinct i from t order by j;
> ERROR 42879: The ORDER BY clause may not contain column 'J', since the query specifies DISTINCT and that column does not appear in the query result.
> ij> select distinct i from t order by j*2;
> I          
> -----------
> 1          
> 1          
> 2 rows selected

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