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 "Deepa Remesh (JIRA)" <de...@db.apache.org> on 2006/09/12 00:37:22 UTC
[jira] Created: (DERBY-1841) lang/groupBy.sql fails with IBM j9 vms
lang/groupBy.sql fails with IBM j9 vms
---------------------------------------
Key: DERBY-1841
URL: http://issues.apache.org/jira/browse/DERBY-1841
Project: Derby
Issue Type: Test
Components: Regression Test Failure
Reporter: Deepa Remesh
This looks like a master update issue. The canons for j9 vms need to be updated with changes made for DERBY-883.
Diff:
8 del
< ij> -- group by position
8a8,9
> ij> -- group by constant. should compile but fail because
> -- it is not a valid grouping expression.
10 del
< ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
10a11
> ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
16 del
< ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
16a17
> ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
18 del
< ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
18a19
> ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
20 del
< ERROR 42Y36: Column reference 'B' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
21 del
< ij> -- columns in group by list must be unique
22 del
< select a, b from t1 group by a, a;
23 del
< ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
24 del
< ij> select a, b from t1 group by a, t1.a;
25 del
< ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
25a21
> ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
34 del
< ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
34a30
> ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
43 del
< ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
43a39
> ERROR 42X01: Syntax error: ?.
Test Failed.
--
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-1841) lang/groupBy.sql fails with IBM j9 vms
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1841?page=all ]
Myrna van Lunteren closed DERBY-1841.
-------------------------------------
Didn't see a failure on 10.2. so no need to port back.
> lang/groupBy.sql fails with IBM j9 vms
> --------------------------------------
>
> Key: DERBY-1841
> URL: http://issues.apache.org/jira/browse/DERBY-1841
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Reporter: Deepa Remesh
> Assigned To: Myrna van Lunteren
> Fix For: 10.3.0.0
>
> Attachments: DERBY-1841_20060927.diff
>
>
> This looks like a master update issue. The canons for j9 vms need to be updated with changes made for DERBY-883.
> Diff:
> 8 del
> < ij> -- group by position
> 8a8,9
> > ij> -- group by constant. should compile but fail because
> > -- it is not a valid grouping expression.
> 10 del
> < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
> 10a11
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 16 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 16a17
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 18 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 18a19
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 20 del
> < ERROR 42Y36: Column reference 'B' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 21 del
> < ij> -- columns in group by list must be unique
> 22 del
> < select a, b from t1 group by a, a;
> 23 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 24 del
> < ij> select a, b from t1 group by a, t1.a;
> 25 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 25a21
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 34 del
> < ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 34a30
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 43 del
> < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
> 43a39
> > ERROR 42X01: Syntax error: ?.
> Test Failed.
--
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-1841) lang/groupBy.sql fails with IBM j9 vms
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1841?page=all ]
Myrna van Lunteren updated DERBY-1841:
--------------------------------------
Attachment: DERBY-1841_20060927.diff
Still an issue - basically, wsdd5.6 (aka j9_13) for 2 queries shows the rows that (to me look the same but to diff not) in a different order, and because wctme5.7 (aka j9_22) would also pick this master up, we need 2 master updates.
j9_foundation is fine.
Attaching a match with 2 updated masters.
> lang/groupBy.sql fails with IBM j9 vms
> --------------------------------------
>
> Key: DERBY-1841
> URL: http://issues.apache.org/jira/browse/DERBY-1841
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Reporter: Deepa Remesh
> Assigned To: Myrna van Lunteren
> Attachments: DERBY-1841_20060927.diff
>
>
> This looks like a master update issue. The canons for j9 vms need to be updated with changes made for DERBY-883.
> Diff:
> 8 del
> < ij> -- group by position
> 8a8,9
> > ij> -- group by constant. should compile but fail because
> > -- it is not a valid grouping expression.
> 10 del
> < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
> 10a11
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 16 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 16a17
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 18 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 18a19
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 20 del
> < ERROR 42Y36: Column reference 'B' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 21 del
> < ij> -- columns in group by list must be unique
> 22 del
> < select a, b from t1 group by a, a;
> 23 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 24 del
> < ij> select a, b from t1 group by a, t1.a;
> 25 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 25a21
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 34 del
> < ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 34a30
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 43 del
> < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
> 43a39
> > ERROR 42X01: Syntax error: ?.
> Test Failed.
--
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] Resolved: (DERBY-1841) lang/groupBy.sql fails with IBM j9
vms
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1841?page=all ]
Andrew McIntyre resolved DERBY-1841.
------------------------------------
Fix Version/s: 10.3.0.0
Resolution: Fixed
Committed to trunk with revision 450736.
> lang/groupBy.sql fails with IBM j9 vms
> --------------------------------------
>
> Key: DERBY-1841
> URL: http://issues.apache.org/jira/browse/DERBY-1841
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Reporter: Deepa Remesh
> Assigned To: Myrna van Lunteren
> Fix For: 10.3.0.0
>
> Attachments: DERBY-1841_20060927.diff
>
>
> This looks like a master update issue. The canons for j9 vms need to be updated with changes made for DERBY-883.
> Diff:
> 8 del
> < ij> -- group by position
> 8a8,9
> > ij> -- group by constant. should compile but fail because
> > -- it is not a valid grouping expression.
> 10 del
> < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
> 10a11
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 16 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 16a17
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 18 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 18a19
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 20 del
> < ERROR 42Y36: Column reference 'B' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 21 del
> < ij> -- columns in group by list must be unique
> 22 del
> < select a, b from t1 group by a, a;
> 23 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 24 del
> < ij> select a, b from t1 group by a, t1.a;
> 25 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 25a21
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 34 del
> < ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 34a30
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 43 del
> < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
> 43a39
> > ERROR 42X01: Syntax error: ?.
> Test Failed.
--
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] Commented: (DERBY-1841) lang/groupBy.sql fails with IBM j9
vms
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1841?page=comments#action_12438290 ]
Andrew McIntyre commented on DERBY-1841:
----------------------------------------
Deepa, is this still an issue for the J2ME runs? If so, can you prepare a patch for this? I will be glad to review and commit it if so.
> lang/groupBy.sql fails with IBM j9 vms
> --------------------------------------
>
> Key: DERBY-1841
> URL: http://issues.apache.org/jira/browse/DERBY-1841
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Reporter: Deepa Remesh
>
> This looks like a master update issue. The canons for j9 vms need to be updated with changes made for DERBY-883.
> Diff:
> 8 del
> < ij> -- group by position
> 8a8,9
> > ij> -- group by constant. should compile but fail because
> > -- it is not a valid grouping expression.
> 10 del
> < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
> 10a11
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 16 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 16a17
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 18 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 18a19
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 20 del
> < ERROR 42Y36: Column reference 'B' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 21 del
> < ij> -- columns in group by list must be unique
> 22 del
> < select a, b from t1 group by a, a;
> 23 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 24 del
> < ij> select a, b from t1 group by a, t1.a;
> 25 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 25a21
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 34 del
> < ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 34a30
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 43 del
> < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
> 43a39
> > ERROR 42X01: Syntax error: ?.
> Test Failed.
--
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-1841) lang/groupBy.sql fails with IBM j9
vms
Posted by "Myrna van Lunteren (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1841?page=all ]
Myrna van Lunteren reassigned DERBY-1841:
-----------------------------------------
Assignee: Myrna van Lunteren
> lang/groupBy.sql fails with IBM j9 vms
> --------------------------------------
>
> Key: DERBY-1841
> URL: http://issues.apache.org/jira/browse/DERBY-1841
> Project: Derby
> Issue Type: Test
> Components: Regression Test Failure
> Reporter: Deepa Remesh
> Assigned To: Myrna van Lunteren
>
> This looks like a master update issue. The canons for j9 vms need to be updated with changes made for DERBY-883.
> Diff:
> 8 del
> < ij> -- group by position
> 8a8,9
> > ij> -- group by constant. should compile but fail because
> > -- it is not a valid grouping expression.
> 10 del
> < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
> 10a11
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 16 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 16a17
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 18 del
> < ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 18a19
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 20 del
> < ERROR 42Y36: Column reference 'B' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 21 del
> < ij> -- columns in group by list must be unique
> 22 del
> < select a, b from t1 group by a, a;
> 23 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 24 del
> < ij> select a, b from t1 group by a, t1.a;
> 25 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
> 25a21
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 34 del
> < ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
> 34a30
> > ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.
> 43 del
> < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
> 43a39
> > ERROR 42X01: Syntax error: ?.
> Test Failed.
--
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