db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-280) Wrong result from select when aliasing to same name as used in group by
Date Fri, 13 May 2005 08:08:14 GMT
Wrong result from select when aliasing to same name as used in group by
-----------------------------------------------------------------------

         Key: DERBY-280
         URL: http://issues.apache.org/jira/browse/DERBY-280
     Project: Derby
        Type: Bug
  Components: SQL  
    Reporter: Bernt M. Johnsen
    Priority: Minor


Wrong result from select when aliasing to same name as used in group by. Example:

If we have the following table:

    ij> select * from tt;
    I          |J
    -----------------------
    1          |2
    2          |3
    1          |2
    2          |3
    2          |3
                                                                                         
                                                   
    5 rows selected

The following select is ok:

    ij> select i, count(*) as cnt from tt group by i;
    I          |CNT
    -----------------------
    1          |2
    2          |3
                                                                                         
                                                   
    2 rows selected


But this one returns wrong result in the aliased column:

    ij> select i, count(*) as i from tt group by i;
    I          |I
    -----------------------
    1          |1
    2          |2
                                                                                         
                                                   
    2 rows selected
                                                                                         
                                                   


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


Mime
View raw message