|
If you were logged in you would be able to see more operations.
|
|
|
|
Issue Links:
|
Dependants
|
|
This issue depends on:
|
|
DERBY-504
SELECT DISTINCT returns duplicates when selecting from subselects
|
|
|
|
|
|
|
|
| Resolution Date: |
10/Apr/06 11:26 PM
|
|
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.
|
|
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. |
Show » |
| No work has yet been logged on this issue.
|
|
Bug
