db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r562178 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/miscerrors.out tests/lang/miscerrors.sql
Date Thu, 02 Aug 2007 16:39:32 GMT
Author: kmarsden
Date: Thu Aug  2 09:39:30 2007
New Revision: 562178

URL: http://svn.apache.org/viewvc?view=rev&rev=562178
Log:
DERBY-2962 Change functional tests to use casts for System table queries to avoid conversion
errors when run with TERRITORY_BASED collation.

fix miscerrors.sql failure


Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out?view=diff&rev=562178&r1=562177&r2=562178
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/miscerrors.out
Thu Aug  2 09:39:30 2007
@@ -63,9 +63,8 @@
 ERROR 42X05: Table/View 'BILL932432' does not exist.
 ij> SELECT 932432;
 ERROR 42X01: Syntax error: Encountered "<EOF>" at line 1, column 13.
-ij> select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT  AS LONG VARCHAR)
LIKE '%932432%';
+ij> select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG VARCHAR)
LIKE '%932432%';
 SQL_TEXT                                                                                
                                       
 --------------------------------------------------------------------------------------------------------------------------------
 select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG VARCHAR) LIKE
'%932432%'                            
-select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT  AS LONG VARCHAR) LIKE
'%932432%'                           
 ij> 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql?view=diff&rev=562178&r1=562177&r2=562178
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
Thu Aug  2 09:39:30 2007
@@ -54,4 +54,4 @@
 SELECT * FROM BILL932432;
 SELECT 932432;
 
-select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT  AS LONG VARCHAR) LIKE
'%932432%';
+select SQL_TEXT from syscs_diag.statement_cache where CAST(SQL_TEXT AS LONG VARCHAR) LIKE
'%932432%';



Mime
View raw message