Description
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.
Attachments
Issue Links
- depends upon
-
DERBY-504 SELECT DISTINCT returns duplicates when selecting from subselects
- Closed