db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myrna van Lunteren (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2058) derbyall/derbyall.fail:lang/groupBy.sql failed with wctme5.7 max libraries on version 10.2
Date Sun, 19 Nov 2006 01:44:38 GMT
     [ http://issues.apache.org/jira/browse/DERBY-2058?page=all ]

Myrna van Lunteren updated DERBY-2058:
--------------------------------------

        Summary: derbyall/derbyall.fail:lang/groupBy.sql failed with wctme5.7 max libraries
on version 10.2  (was: derbyall/derbyall.fail:lang/groupBy.sql, derbyall/derbyall.fail:i18n/iepnegativetests_ES.sql
 failed with wctme5.7 max libraries on version 10.2)
    Description: 
The diff for the failed tests are :

*** Start: groupBy jdk1.3.1 subset - 2.2 derbyall:derbylang 2006-11-04 09:29:36 ***
24 del
< ij> -- group by position
24a24,25
> ij> -- group by constant. should compile but fail because
> -- it is not a valid grouping expression.
26 del
< ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
26a27
> 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.  
32 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.  
32a33
> 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 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.  
34a35
> 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.  
36 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.  
37 del
< ij> -- columns in group by list must be unique
38 del
< select a, b from t1 group by a, a;
39 del
< ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY
list must be unambiguous.
40 del
< ij> select a, b from t1 group by a, t1.a;
41 del
< ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY
list must be unambiguous.
41a37
> 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.  
50 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.  
50a46
> 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.  
59 del
< ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
59a55
> ERROR 42X01: Syntax error: ?.
Test Failed.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------


  was:
The diff for the failed tests are :

*** Start: groupBy jdk1.3.1 subset - 2.2 derbyall:derbylang 2006-11-04 09:29:36 ***
24 del
< ij> -- group by position
24a24,25
> ij> -- group by constant. should compile but fail because
> -- it is not a valid grouping expression.
26 del
< ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
26a27
> 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.  
32 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.  
32a33
> 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 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.  
34a35
> 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.  
36 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.  
37 del
< ij> -- columns in group by list must be unique
38 del
< select a, b from t1 group by a, a;
39 del
< ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY
list must be unambiguous.
40 del
< ij> select a, b from t1 group by a, t1.a;
41 del
< ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY
list must be unambiguous.
41a37
> 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.  
50 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.  
50a46
> 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.  
59 del
< ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
59a55
> ERROR 42X01: Syntax error: ?.
Test Failed.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
52 del
< ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: La tabla
'IEP.NOTABLE' no existe.' al evaluar una expresi EnC:>243< n.
53 del
< ERROR 42X05: La tabla 'IEP.NOTABLE' no existe.
53a52,53
> ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: La tabla/vista
'IEP.NOTABLE' no existe.' al evaluar una expresi EnC:>243< n.
> ERROR 42X05: La tabla/vista 'IEP.NOTABLE' no existe.
138 del
< ERROR XIE0M: La tabla 'IEP.NOTABLE' no existe. 
138a138
> ERROR XIE0M: La tabla 'IEP.NOTABLE' no existe.  
142 del
< ERROR XIE0M: La tabla 'XXXX.T1' no existe. 
142a142
> ERROR XIE0M: La tabla 'XXXX.T1' no existe.  
223 del
< ERROR XIE0M: La tabla 'SESSION.TEMP2' no existe. 
223a223
> ERROR XIE0M: La tabla 'SESSION.TEMP2' no existe.  
225 del
< ERROR 42X05: La tabla 'SESSION.TEMP2' no existe.
225a225
> ERROR 42X05: La tabla/vista 'SESSION.TEMP2' no existe.
317 del
< ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: 'SYS.SYSTABLES'
es una tabla del sistema. Los usuarios no tienen permitido modificar el contenido de esta
tabla.' al evaluar una expresi EnC:>243< n.
318 del
< ERROR 42Y25: 'SYS.SYSTABLES' es una tabla del sistema. Los usuarios no tienen permitido
modificar el contenido de esta tabla.
318a317,318
> ERROR 38000: Se he generado la excepci EnC:>243< n 'java.sql.SQLException: 'SYS.SYSTABLES'
es una tabla del sistema.  Los usuarios no tienen permitido modificar el contenido de esta
tabla.' al evaluar una expresi EnC:>243< n.
> ERROR 42Y25: 'SYS.SYSTABLES' es una tabla del sistema.  Los usuarios no tienen permitido
modificar el contenido de esta tabla.
326 del
< ERROR XIE0B: La columna CT de la tabla de tipo CLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export. 
326a326
> ERROR XIE0B: La columna CT de la tabla de tipo CLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export.   
330 del
< ERROR XIE0B: La columna BT de la tabla de tipo BLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export. 
330a330
> ERROR XIE0B: La columna BT de la tabla de tipo BLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export.   
333 del
< ERROR XIE0B: La columna CT de la tabla de tipo CLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export. 
333a333
> ERROR XIE0B: La columna CT de la tabla de tipo CLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export.   
337 del
< ERROR XIE0B: La columna BT de la tabla de tipo BLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export. 
337a337
> ERROR XIE0B: La columna BT de la tabla de tipo BLOB, no est EnC:>225<  soportada
por la funci EnC:>243< n import/export.   
Test Failed.




Modifying the description & title - it seems to me the iepnegativetests_ES.sql failing
with wcmte is the same problem and at least extremely similar output as what is described
in DERBY-2077. The groupBy test failing is a matter of an outdated canon.

> derbyall/derbyall.fail:lang/groupBy.sql failed with wctme5.7 max libraries on version
10.2
> ------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2058
>                 URL: http://issues.apache.org/jira/browse/DERBY-2058
>             Project: Derby
>          Issue Type: Bug
>          Components: Regression Test Failure
>    Affects Versions: 10.2.1.8
>            Reporter: Manjula Kutty
>            Priority: Minor
>
> The diff for the failed tests are :
> *** Start: groupBy jdk1.3.1 subset - 2.2 derbyall:derbylang 2006-11-04 09:29:36 ***
> 24 del
> < ij> -- group by position
> 24a24,25
> > ij> -- group by constant. should compile but fail because
> > -- it is not a valid grouping expression.
> 26 del
> < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
> 26a27
> > 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.  
> 32 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.  
> 32a33
> > 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 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.  
> 34a35
> > 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.  
> 36 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.  
> 37 del
> < ij> -- columns in group by list must be unique
> 38 del
> < select a, b from t1 group by a, a;
> 39 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP
BY list must be unambiguous.
> 40 del
> < ij> select a, b from t1 group by a, t1.a;
> 41 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP
BY list must be unambiguous.
> 41a37
> > 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.  
> 50 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.  
> 50a46
> > 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.  
> 59 del
> < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
> 59a55
> > 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

        

Mime
View raw message