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 [2/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/implicitConversions.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out?view=diff&rev=563164&r1=563163&r2=563164
==============================================================================
--- db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out (original)
+++ db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/implicitConversions.out Mon Aug  6 08:04:14 2007
@@ -227,293 +227,293 @@
 ERROR 42X61: Types 'LONG VARCHAR' and 'TIMESTAMP' are not UNION compatible.
 ij> -- comparisons at the language level
 select si from all1 where cast(1 as smallint) = '1';
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) > '2';
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) >= '2';
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) < '2';
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) <= '2';
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) <> '2';
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) = cast(null as char);
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) > cast(null as char);
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) >= cast(null as char);
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) < cast(null as char);
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) <= cast(null as char);
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where cast(1 as smallint) <> cast(null as char);
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select si from all1 where '1' = cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where '2' > cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where '2' >= cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where '2' < cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where '2' <= cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where '2' <> cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where cast(null as char) = cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where cast(null as char) > cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where cast(null as char) >= cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where cast(null as char) < cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where cast(null as char) <= cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where cast(null as char) <> cast(1 as smallint);
-ERROR 42818: Comparisons between 'CHAR' and 'SMALLINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'SMALLINT' 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 si from all1 where cast(1 as int) = '1';
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) > '2';
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) >= '2';
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) < '2';
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) <= '2';
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) <> '2';
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) = cast(null as char);
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) > cast(null as char);
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) >= cast(null as char);
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) < cast(null as char);
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) <= cast(null as char);
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where cast(1 as int) <> cast(null as char);
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select si from all1 where '1' = cast(1 as int);
-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 si from all1 where '2' > cast(1 as int);
-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 si from all1 where '2' >= cast(1 as int);
-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 si from all1 where '2' < cast(1 as int);
-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 si from all1 where '2' <> cast(1 as int);
-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 si from all1 where '2' <= cast(1 as int);
-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 si from all1 where cast(null as char) = cast(1 as int);
-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 si from all1 where cast(null as char) > cast(1 as int);
-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 si from all1 where cast(null as char) >= cast(1 as int);
-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 si from all1 where cast(null as char) < cast(1 as int);
-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 si from all1 where cast(null as char) <> cast(1 as int);
-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 si from all1 where cast(null as char) <= cast(1 as int);
-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 si from all1 where cast(1 as bigint) = '1';
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) > '2';
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) >= '2';
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) < '2';
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) <= '2';
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) <> '2';
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) = cast(null as char);
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) > cast(null as char);
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) >= cast(null as char);
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) < cast(null as char);
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) <= cast(null as char);
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where cast(1 as bigint) <> cast(null as char);
-ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'BIGINT' 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> select si from all1 where '1' = cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where '2' > cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where '2' >= cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where '2' < cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where '2' <= cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where '2' <> cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where cast(null as char) = cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where cast(null as char) > cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where cast(null as char) >= cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where cast(null as char) < cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where cast(null as char) <= cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where cast(null as char) <> cast(1 as bigint);
-ERROR 42818: Comparisons between 'CHAR' and 'BIGINT' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'BIGINT' 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 si from all1 where cast(1 as real) = '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> select si from all1 where cast(1 as real) > '2';
-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> select si from all1 where cast(1 as real) >= '2';
-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> select si from all1 where cast(1 as real) < '2';
-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> select si from all1 where cast(1 as real) <> '2';
-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> select si from all1 where cast(1 as real) <= '2';
-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> select si from all1 where cast(1 as real) = cast(null as char);
-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> select si from all1 where cast(1 as real) > cast(null as char);
-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> select si from all1 where cast(1 as real) >= cast(null as char);
-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> select si from all1 where cast(1 as real) < cast(null as char);
-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> select si from all1 where cast(1 as real) <> cast(null as char);
-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> select si from all1 where cast(1 as real) <= cast(null as char);
-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> select si from all1 where '1' = cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where '2' > cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where '2' >= cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where '2' < cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where '2' <= cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where '2' <> cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where cast(null as char) = cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where cast(null as char) > cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where cast(null as char) >= cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where cast(null as char) < cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where cast(null as char) <= cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where cast(null as char) <> cast(1 as real);
-ERROR 42818: Comparisons between 'CHAR' and 'REAL' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'REAL' 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 si from all1 where cast(1 as double precision) = '1';
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) > '2';
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) >= '2';
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) < '2';
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) <= '2';
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) <> '2';
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) = cast(null as char);
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) > cast(null as char);
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) >= cast(null as char);
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) < cast(null as char);
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) <= cast(null as char);
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where cast(1 as double precision) <> cast(null as char);
-ERROR 42818: Comparisons between 'DOUBLE' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'DOUBLE' 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> select si from all1 where '1' = cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where '2' > cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where '2' >= cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where '2' < cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where '2' <= cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where '2' <> cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where cast(null as char) = cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where cast(null as char) > cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where cast(null as char) >= cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where cast(null as char) < cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where cast(null as char) <= cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where cast(null as char) <> cast(1 as double precision);
-ERROR 42818: Comparisons between 'CHAR' and 'DOUBLE' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'DOUBLE' 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 si from all1 where cast(1 as numeric) = '1';
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) > '2';
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) >= '2';
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) < '2';
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) <= '2';
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) <> '2';
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) = cast(null as char);
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) > cast(null as char);
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) >= cast(null as char);
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) < cast(null as char);
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) <= cast(null as char);
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where cast(1 as numeric) <> cast(null as char);
-ERROR 42818: Comparisons between 'NUMERIC' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'NUMERIC' 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> select si from all1 where '1' = cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where '2' > cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where '2' >= cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where '2' < cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where '2' <= cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where '2' <> cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where cast(null as char) = cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where cast(null as char) > cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where cast(null as char) >= cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where cast(null as char) < cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where cast(null as char) <= cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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 si from all1 where cast(null as char) <> cast(1 as numeric);
-ERROR 42818: Comparisons between 'CHAR' and 'NUMERIC' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'NUMERIC' 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> -- the following queries return 1 if the search condition is satisfied
 -- and returns nothing if the search condition is not satisfied
 select 1 from all1 where '1996-09-09' = date('1996-09-09');
@@ -757,53 +757,53 @@
 1          
 -----------
 ij> select si from all1 where ' ' = X'0020';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where ' ' > X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where ' ' >= X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where ' ' < X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where ' ' <= X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where ' ' <> X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where cast(null as char) = X'0020';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where cast(null as char) > X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where cast(null as char) >= X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where cast(null as char) < X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where cast(null as char) <= X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where cast(null as char) <> X'001F';
-ERROR 42818: Comparisons between 'CHAR' and 'CHAR () FOR BIT DATA' are not supported.
+ERROR 42818: Comparisons between 'CHAR (UCS_BASIC)' and 'CHAR () FOR BIT DATA' 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 si from all1 where X'0020' = ' ';
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' > ' ';
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' >= ' ';
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' < ' ';
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' <= ' ';
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' <> ' ';
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'0020' = cast(null as char);
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' > cast(null as char);
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' >= cast(null as char);
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' < cast(null as char);
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' <= cast(null as char);
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> select si from all1 where X'001F' <> cast(null as char);
-ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' 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> create table all_c1(c_ti char(3), c_si char(10), c_i char(30), c_li char(30), 
 					c_r char(50), c_dp char(50), c_dc char(10), 
 					c_num char(50), c_bool char(5), c_b char(8), 
@@ -817,113 +817,113 @@
 1 row inserted/updated/deleted
 ij> -- test qualifiers with conversion from (var)char
 select 1 from all_c1, all1 where si = c_si;
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select 1 from all_c1, all1 where si > c_si;
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select 1 from all_c1, all1 where si >= c_si;
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select 1 from all_c1, all1 where si < c_si;
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select 1 from all_c1, all1 where si <= c_si;
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select 1 from all_c1, all1 where si <> c_si;
-ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'SMALLINT' 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> select 1 from all_c1, all1 where i = c_i;
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select 1 from all_c1, all1 where i > c_i;
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select 1 from all_c1, all1 where i >= c_i;
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select 1 from all_c1, all1 where i < c_i;
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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> select 1 from all_c1, all1 where i <= c_i;
-ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
+ERROR 42818: Comparisons between 'INTEGER' 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')

[... 2420 lines stripped ...]


Mime
View raw message