db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From banda...@apache.org
Subject svn commit: rev 76009 - incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master
Date Tue, 16 Nov 2004 19:31:44 GMT
Author: bandaram
Date: Tue Nov 16 11:31:43 2004
New Revision: 76009

Modified:
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dynamicLikeOptimization.out
Log:
Test modifications for Derby-45

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOB.out
Tue Nov 16 11:31:43 2004
@@ -239,7 +239,13 @@
 ij> select * from b where b like cast('0102%' as blob(10));
 ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
 ij> select * from c where c like cast('12%' as clob(10));
-ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments
was found.
+C    
+-----
+1234 
+12345
+1234 
+12345
+1234&
 ij> select * from n where n like cast('12%' as nclob(10));
 ERROR 0A000: Feature not implemented: NCLOB.
 ij> -- cleanup

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dynamicLikeOptimization.out
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dynamicLikeOptimization.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dynamicLikeOptimization.out
Tue Nov 16 11:31:43 2004
@@ -86,7 +86,7 @@
 1          
 ij> -- match
 select 1 from t1  where 'asdf' like 'a%' escape cast(null as char);
-ERROR 42884: No authorized routine named 'LIKE' of type 'FUNCTION' having compatible arguments
was found.
+ERROR 22501: An ESCAPE clause of NULL returns undefined results and is not allowed.
 ij> -- error NULL escape
 prepare ll2 as 'select 1 from t1 where ''%foobar'' like ? escape ?';
 ij> execute ll2 using 'values (''Z%foobar'', ''Z'') ';

Mime
View raw message