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/08/19 16:42:54 UTC
[jira] Created: (DERBY-519) GROUP BY test depends on incorrect behaviour
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
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
Posted by 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
[jira] Commented: (DERBY-519) GROUP BY test depends on incorrect behaviour
Posted by "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
[jira] Assigned: (DERBY-519) GROUP BY test depends on incorrect behaviour
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-519?page=all ]
Knut Anders Hatlen reassigned DERBY-519:
----------------------------------------
Assign To: Knut Anders Hatlen
> 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
[jira] Closed: (DERBY-519) GROUP BY test depends on incorrect
behaviour
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-519?page=all ]
Knut Anders Hatlen closed DERBY-519:
------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
> 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
> Fix For: 10.2.0.0
>
> 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
[jira] Reopened: (DERBY-519) GROUP BY test depends on incorrect
behaviour
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-519?page=all ]
Knut Anders Hatlen reopened DERBY-519:
--------------------------------------
> 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
[jira] Closed: (DERBY-519) GROUP BY test depends on incorrect behaviour
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Updated: (DERBY-519) GROUP BY test depends on incorrect behaviour
Posted by "Knut Anders Hatlen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-519?page=all ]
Knut Anders Hatlen updated DERBY-519:
-------------------------------------
Component: SQL
(was: Test)
> 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