db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kmars...@apache.org
Subject svn commit: r563164 [3/3] - in /db/derby/code/branches/10.3/java: engine/org/apache/derby/iapi/types/ engine/org/apache/derby/impl/sql/compile/ engine/org/apache/derby/loc/ testing/org/apache/derbyTesting/functionTests/master/
Date Mon, 06 Aug 2007 15:04:15 GMT
Modified: db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out?view=diff&rev=563164&r1=563163&r2=563164
==============================================================================
--- db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
(original)
+++ db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out
Mon Aug  6 08:04:14 2007
@@ -67,15 +67,15 @@
 -- negative tests
 -- type mismatches
 select * from t where i between i and e;
-ERROR 42818: Comparisons between 'INTEGER' and 'DATE' are not supported.
+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> select * from t where i between i and t;
-ERROR 42818: Comparisons between 'INTEGER' and 'TIME' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' and 'TIME' 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> select * from t where i between i and p;
-ERROR 42818: Comparisons between 'INTEGER' and 'TIMESTAMP' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' and 'TIMESTAMP' 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> select * from t where e between p and p;
-ERROR 42818: Comparisons between 'DATE' and 'TIMESTAMP' are not supported.
+ERROR 42818: Comparisons between 'DATE' and 'TIMESTAMP' 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> select * from t where 1 between e and p;
-ERROR 42818: Comparisons between 'INTEGER' and 'DATE' are not supported.
+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> -- between null and
 select * from t where i between null and i;
 ERROR 42X01: Syntax error: Encountered "null" at line 2, column 33.
@@ -296,15 +296,15 @@
 ERROR 21000: Scalar subquery is only allowed to return a single row.
 ij> -- type mismatches
 select i from t where i in (i, i, e);
-ERROR 42818: Comparisons between 'INTEGER' and 'DATE' are not supported.
+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> select i from t where i in (i, i, t);
-ERROR 42818: Comparisons between 'INTEGER' and 'TIME' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' and 'TIME' 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> select i from t where i in (i, i, p);
-ERROR 42818: Comparisons between 'INTEGER' and 'TIMESTAMP' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' and 'TIMESTAMP' 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> select i from t where e in (e, p, e);
-ERROR 42818: Comparisons between 'DATE' and 'TIMESTAMP' are not supported.
+ERROR 42818: Comparisons between 'DATE' and 'TIMESTAMP' 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> select i from t where 1 in (p, 2, 1);
-ERROR 42818: Comparisons between 'INTEGER' and 'TIMESTAMP' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' and 'TIMESTAMP' 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
 -- type comparisons
 select i from t where i in (s, r, i, d, 40e1);
@@ -764,13 +764,13 @@
 ----------------------
 4          |4         
 ij> select * from big where c in (1, 3, 5, 7, 9, 11, 13, 15, 17, 19, 21, 23, 25, 27, 29,
31);
-ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'INTEGER' 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> select * from big where c in (31, 32, 5, 7, 9, 11, 13, 15, 17, 19, 21, 23, 25, 27,
29, 1);
-ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'INTEGER' 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> select * from big where c in (1, 5, 7, 9, 11, 13, 15, 17, 19, 21, 23, 25, 27, 29,
31);
-ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'INTEGER' 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> select * from big where c in (1, 5, 7, 9, 13, 15, 17, 19, 21, 23, 25, 27, 29, 31);
-ERROR 42818: Comparisons between 'CHAR' and 'INTEGER' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'INTEGER' 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> select * from big where c in ('1', '5', '7', '9', '13', '15', '17', '19', '21', '23',
'25', '27', '29', '31');
 I          |C         
 ----------------------
@@ -1525,7 +1525,7 @@
 5.0          
 ij> select c1 from t1 where c1 in ('10', '5', '20') and c1 > 3
 and c1 < 19;
-ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'REAL' and 'CHAR (UCS_BASIC)' 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> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
 0 rows inserted/updated/deleted
 ij> maximumdisplaywidth 4000;
@@ -1647,7 +1647,7 @@
 Negate comparison result: false
 ij> -- nested loop exists join, right side should be ProjectRestrict on index scan with
start and stop keys
 select c1 from t2 where c1 in (select c1 from t1 where c1 in (5, t2.c2) and c1 in ('5', '7'));
-ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'REAL' and 'CHAR (UCS_BASIC)' 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> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                       
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         

                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -1792,7 +1792,7 @@
 ij> -- hash exists join, right side PR on hash index scan, still no start/stop key, next
qualifier "=".
 -- It still doesn't have start/stop key because c1 in ('5', '7') is blocked out by 2 others.
 select c1 from t2 where c1 in (select c1 from t1 where c1 in (5, t2.c2) and c1 in ('5', '7'));
-ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'REAL' and 'CHAR (UCS_BASIC)' 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> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS();
 1                                                                                       
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         
                                                                                         

                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
@@ -1940,7 +1940,7 @@
 -- many items
 select c1 from t1 where c1 in ('9', '4', '8.0', '7.7',
 	5.2, 6, '7.7', '4.9', '6.1');
-ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'REAL' and 'CHAR (UCS_BASIC)' 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> prepare q1 as 'select c1 from t1 where c1 in (3, ?)';
 ij> execute q1 using 'values 8';
 C1           

Modified: db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/union.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/union.out?view=diff&rev=563164&r1=563163&r2=563164
==============================================================================
--- db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/union.out
(original)
+++ db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/union.out
Mon Aug  6 08:04:14 2007
@@ -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.
+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