svn commit: r632173 [3/3] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: LOB.out bit.out implicitConversions.out union.out

[km...@apache.org]

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out?rev=632173&r1=632172&r2=632173&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out Thu Feb 28 15:52:23 2008
@@ -693,7 +693,7 @@
 ERROR 21000: Scalar subquery is only allowed to return a single row.
 ij> -- both sides of union have same type, which is incompatible with LHS
 select i from t1 where i in (select date('1999-02-04') from t2 union all select date('1999-03-08') from t2);
-ERROR 42818: Comparisons between 'INTEGER' and 'DATE' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. select tablename from sys.systables where CAST(tablename as VARCHAR(128)) = 'T1')
+ERROR 42818: Comparisons between 'INTEGER' and 'DATE' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
 ij> -- positive tests
 
 -- expression subquery