db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-519) GROUP BY test depends on incorrect behaviour
Date Tue, 23 Aug 2005 17:56:08 GMT
    [ http://issues.apache.org/jira/browse/DERBY-519?page=comments#action_12319762 ] 

Satheesh Bandaram commented on DERBY-519:

Is this a TEST issue or a code problem? First look at the description seems to indicate a
code problem? If so, the component should be SQL.

> 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:
>     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:
For more information on JIRA, see:

View raw message