db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrnap <my...@Golux.Com>
Subject [PATCH] re jira 45 - test master updates...
Date Fri, 12 Nov 2004 17:53:46 GMT
Now that there are tests, and svn 57487 was committed for jira 45, 2 
master files need to be updated.

As of now, updates to tests and masters will go with the patch that 
changes functionality, but in this case there was a timing problem...

Index: java/testing/org/apache/derbyTesting/functionTests/master/LOB.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/LOB.out    
(revision 57534)
+++ java/testing/org/apache/derbyTesting/functionTests/master/LOB.out    
(working copy)
@@ -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
Index: 
java/testing/org/apache/derbyTesting/functionTests/master/dynamicLikeOptimization.out
===================================================================
--- 
java/testing/org/apache/derbyTesting/functionTests/master/dynamicLikeOptimization.out    
(revision 57534)
+++ 
java/testing/org/apache/derbyTesting/functionTests/master/dynamicLikeOptimization.out    
(working copy)
@@ -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