You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org> on 2005/09/05 10:17:32 UTC
[jira] Closed: (DERBY-519) GROUP BY test depends on incorrect behaviour
[ http://issues.apache.org/jira/browse/DERBY-519?page=all ]
Knut Anders Hatlen closed DERBY-519:
------------------------------------
Resolution: Fixed
Fixed in revision 267239.
> 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