db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject 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
Date Thu, 28 Feb 2008 23:52:28 GMT
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



Mime
View raw message