db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-519) GROUP BY test depends on incorrect behaviour
Date Fri, 19 Aug 2005 14:42:54 GMT
GROUP BY test depends on incorrect behaviour
--------------------------------------------

         Key: DERBY-519
         URL: http://issues.apache.org/jira/browse/DERBY-519
     Project: Derby
        Type: Bug
  Components: Test  
    Versions: 10.2.0.0    
    Reporter: Knut Anders Hatlen
    Priority: Minor


One of the test cases in the GROUP BY test depends on incorrect behaviour.

A section in java/testing/org/apache/derbyTesting/functionTests/master/groupBy.out looks like
this:

ij> -- group by expression
select expr1, expr2
from (select i * s, c || v from t) t (expr1, expr2) group by expr2, expr1 order by expr2,expr1;
EXPR1      |EXPR2                                                       
------------------------------------------------------------------------
0          |goodbye   everyone is here                                  
0          |hello     everyone is here                                  
0          |hello     everyone is here                                  
100        |hello     everyone is here                                  
0          |hello     noone is here                                     
NULL       |NULL                                                        

Since the result should be grouped by expr2 and expr1, it shouldn't have duplicate entries.
The output is however specified to have two identical rows (0, 'hello     everyone is here').

This test will fail if the query is executed correctly.

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