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] Reopened: (DERBY-519) GROUP BY test depends on incorrect behaviour
Date Mon, 10 Apr 2006 15:14:00 GMT
     [ http://issues.apache.org/jira/browse/DERBY-519?page=all ]
     
Knut Anders Hatlen reopened DERBY-519:
--------------------------------------


> GROUP BY test depends on incorrect behaviour
> --------------------------------------------
>
>          Key: DERBY-519
>          URL: http://issues.apache.org/jira/browse/DERBY-519
>      Project: Derby
>         Type: Bug

>   Components: SQL
>     Versions: 10.2.0.0
>     Reporter: Knut Anders Hatlen
>     Assignee: 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