[jira] Commented: (DERBY-519) GROUP BY test depends on incorrect behaviour

["Satheesh Bandaram (JIRA)" <de...@db.apache.org>]

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

Re: [jira] Commented: (DERBY-519) GROUP BY test depends on incorrect behaviour

[Knut Anders Hatlen <Kn...@Sun.COM>]

"Satheesh Bandaram (JIRA)" <de...@db.apache.org> writes:

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

It is actually both a test problem and a code problem. It's a code
problem because there is a bug in the handling of the GROUP BY
query. It's a test problem because the test will only succeed as long
as the bug is present. I guess you're right that SQL is more
appropriate in this case.

-- 
Knut Anders