[ 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
