Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 66432 invoked from network); 5 Aug 2007 12:56:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 5 Aug 2007 12:56:04 -0000 Received: (qmail 12393 invoked by uid 500); 5 Aug 2007 12:56:04 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 12361 invoked by uid 500); 5 Aug 2007 12:56:03 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 12346 invoked by uid 99); 5 Aug 2007 12:56:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Aug 2007 05:56:03 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 05 Aug 2007 12:56:03 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 567D31A9823; Sun, 5 Aug 2007 05:55:43 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r562863 [3/3] - in /db/derby/code/trunk/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: Sun, 05 Aug 2007 12:55:41 -0000 To: derby-commits@db.apache.org From: kmarsden@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20070805125543.567D31A9823@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out?view=diff&rev=562863&r1=562862&r2=562863 ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/inbetween.out Sun Aug 5 05:55:40 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/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out?view=diff&rev=562863&r1=562862&r2=562863 ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/union.out Sun Aug 5 05:55:40 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