You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by dj...@apache.org on 2005/07/21 08:38:37 UTC
svn commit: r220006 - in
/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/LOBDB2compatibility.out tests/lang/LOBDB2compatibility.sql
tests/lang/LOBDB2compatibility_derby.properties
Author: djd
Date: Wed Jul 20 23:38:35 2005
New Revision: 220006
URL: http://svn.apache.org/viewcvs?rev=220006&view=rev
Log:
lang/LOBDB2compatibility.sql incorrectly creates and uses a new database rather
than the wombat database created by the test harness.
Removed:
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/LOBDB2compatibility_derby.properties
Modified:
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/LOBDB2compatibility.sql
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out?rev=220006&r1=220005&r2=220006&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBDB2compatibility.out Wed Jul 20 23:38:35 2005
@@ -1,145 +1,144 @@
-ij> connect 'jdbc:derby:jonas;create=true';
-ij(CONNECTION1)> ----- TEST TO RUN IN DB2 COMPATIBLITY MODE
+ij> ----- TEST TO RUN IN DB2 COMPATIBLITY MODE
--
create table t1(c11 int);
0 rows inserted/updated/deleted
-ij(CONNECTION1)> insert into t1 values(1);
+ij> insert into t1 values(1);
1 row inserted/updated/deleted
-ij(CONNECTION1)> -- equal tests are allowed only for BLOB==BLOB
+ij> -- equal tests are allowed only for BLOB==BLOB
select c11 from t1 where cast(x'1111' as blob(5))=cast(x'1111' as blob(5));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))=cast(x'1111' as blob(7));
+ij> select c11 from t1 where cast(x'1111' as blob(5))=cast(x'1111' as blob(7));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1110' as blob(5))=cast(x'1110' as blob(7));
+ij> select c11 from t1 where cast(x'1110' as blob(5))=cast(x'1110' as blob(7));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))=cast(x'11100000' as blob(7));
+ij> select c11 from t1 where cast(x'1111' as blob(5))=cast(x'11100000' as blob(7));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))=cast(x'1110000000' as blob(7));
+ij> select c11 from t1 where cast(x'1111' as blob(5))=cast(x'1110000000' as blob(7));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where x'11' = cast(x'11' as blob(1));
+ij> select c11 from t1 where x'11' = cast(x'11' as blob(1));
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'11' as blob(1)) = x'11';
+ij> select c11 from t1 where cast(x'11' as blob(1)) = x'11';
ERROR 42818: Comparisons between 'BLOB' and 'CHAR () FOR BIT DATA' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'11' as blob(1)) = cast(x'11' as blob(1));
+ij> select c11 from t1 where cast(x'11' as blob(1)) = cast(x'11' as blob(1));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where '1' = cast('1' as clob(1));
+ij> select c11 from t1 where '1' = cast('1' as clob(1));
ERROR 42818: Comparisons between 'CHAR' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('1' as clob(1)) = '1';
+ij> select c11 from t1 where cast('1' as clob(1)) = '1';
ERROR 42818: Comparisons between 'CLOB' and 'CHAR' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('1' as clob(1)) = cast('1' as clob(1));
+ij> select c11 from t1 where cast('1' as clob(1)) = cast('1' as clob(1));
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where '1' = cast('1' as nclob(1));
+ij> select c11 from t1 where '1' = cast('1' as nclob(1));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('1' as nclob(1)) = '1';
+ij> select c11 from t1 where cast('1' as nclob(1)) = '1';
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('1' as nclob(1)) = cast('1' as nclob(1));
+ij> select c11 from t1 where cast('1' as nclob(1)) = cast('1' as nclob(1));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> -- NCLOB is comparable with CLOB
+ij> -- NCLOB is comparable with CLOB
select c11 from t1 where cast('1' as nclob(10)) = cast('1' as clob(10));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('1' as clob(10)) = cast('1' as nclob(10));
+ij> select c11 from t1 where cast('1' as clob(10)) = cast('1' as nclob(10));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> drop table b;
+ij> drop table b;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'B' because it does not exist.
-ij(CONNECTION1)> drop table c;
+ij> drop table c;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'C' because it does not exist.
-ij(CONNECTION1)> drop table n;
+ij> drop table n;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'N' because it does not exist.
-ij(CONNECTION1)> create table b(blob blob(3K));
+ij> create table b(blob blob(3K));
0 rows inserted/updated/deleted
-ij(CONNECTION1)> create table c(clob clob(2M));
+ij> create table c(clob clob(2M));
0 rows inserted/updated/deleted
-ij(CONNECTION1)> create table n(nclob nclob(1G));
+ij> create table n(nclob nclob(1G));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> insert into b values(cast(X'0031' as blob(3K)));
+ij> insert into b values(cast(X'0031' as blob(3K)));
1 row inserted/updated/deleted
-ij(CONNECTION1)> insert into c values(cast('2' as clob(2M)));
+ij> insert into c values(cast('2' as clob(2M)));
1 row inserted/updated/deleted
-ij(CONNECTION1)> insert into n values(cast('3' as nclob(1G)));
+ij> insert into n values(cast('3' as nclob(1G)));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> insert into b values(cast(X'0031' as blob(3K)));
+ij> insert into b values(cast(X'0031' as blob(3K)));
1 row inserted/updated/deleted
-ij(CONNECTION1)> insert into c values(cast('2' as clob(2M)));
+ij> insert into c values(cast('2' as clob(2M)));
1 row inserted/updated/deleted
-ij(CONNECTION1)> insert into n values(cast('3' as nclob(1G)));
+ij> insert into n values(cast('3' as nclob(1G)));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> insert into b values(cast(X'0031' as blob(3K)));
+ij> insert into b values(cast(X'0031' as blob(3K)));
1 row inserted/updated/deleted
-ij(CONNECTION1)> insert into c values(cast('2' as clob(2M)));
+ij> insert into c values(cast('2' as clob(2M)));
1 row inserted/updated/deleted
-ij(CONNECTION1)> insert into n values(cast('3' as nclob(1G)));
+ij> insert into n values(cast('3' as nclob(1G)));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select blob from b;
+ij> select blob from b;
BLOB
--------------------------------------------------------------------------------------------------------------------------------
0031
0031
0031
-ij(CONNECTION1)> select clob from c;
+ij> select clob from c;
CLOB
--------------------------------------------------------------------------------------------------------------------------------
2
2
2
-ij(CONNECTION1)> select nclob from n;
+ij> select nclob from n;
ERROR 42X05: Table 'N' does not exist.
-ij(CONNECTION1)> -- comparsion using tables
+ij> -- comparsion using tables
select * from b as b1, b as b2 where b1.blob=b2.blob;
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select * from b as b1, b as b2 where b1.blob!=b2.blob;
+ij> select * from b as b1, b as b2 where b1.blob!=b2.blob;
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select * from b as b1, b as b2 where b1.blob=x'0001';
+ij> select * from b as b1, b as b2 where b1.blob=x'0001';
ERROR 42818: Comparisons between 'BLOB' and 'CHAR () FOR BIT DATA' are not supported.
-ij(CONNECTION1)> select * from b as b1, b as b2 where x'0001'=b1.blob;
+ij> select * from b as b1, b as b2 where x'0001'=b1.blob;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'BLOB' are not supported.
-ij(CONNECTION1)> select * from b as b1, b as b2 where x'0001'!=b1.blob;
+ij> select * from b as b1, b as b2 where x'0001'!=b1.blob;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'BLOB' are not supported.
-ij(CONNECTION1)> select * from b as b1, b as b2 where b1.blob=X'7575';
+ij> select * from b as b1, b as b2 where b1.blob=X'7575';
ERROR 42818: Comparisons between 'BLOB' and 'CHAR () FOR BIT DATA' are not supported.
-ij(CONNECTION1)> select * from b as b1, b as b2 where X'7575'=b1.blob;
+ij> select * from b as b1, b as b2 where X'7575'=b1.blob;
ERROR 42818: Comparisons between 'CHAR () FOR BIT DATA' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c.clob from c where c.clob = '2';
+ij> select c.clob from c where c.clob = '2';
ERROR 42818: Comparisons between 'CLOB' and 'CHAR' are not supported.
-ij(CONNECTION1)> select n.nclob from n where n.nclob = '3';
+ij> select n.nclob from n where n.nclob = '3';
ERROR 42X05: Table 'N' does not exist.
-ij(CONNECTION1)> -- ORDER tests on LOB types (not allowed)
+ij> -- ORDER tests on LOB types (not allowed)
select c11 from t1 where cast(x'1111' as blob(5))=cast(x'1111' as blob(5));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))!=cast(x'1111' as blob(5));
+ij> select c11 from t1 where cast(x'1111' as blob(5))!=cast(x'1111' as blob(5));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))<cast(x'1111' as blob(5));
+ij> select c11 from t1 where cast(x'1111' as blob(5))<cast(x'1111' as blob(5));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))>cast(x'1111' as blob(7));
+ij> select c11 from t1 where cast(x'1111' as blob(5))>cast(x'1111' as blob(7));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))<=cast(x'1110' as blob(7));
+ij> select c11 from t1 where cast(x'1111' as blob(5))<=cast(x'1110' as blob(7));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast(x'1111' as blob(5))>=cast(x'11100000' as blob(7));
+ij> select c11 from t1 where cast(x'1111' as blob(5))>=cast(x'11100000' as blob(7));
ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as clob(5))=cast('fish' as clob(5));
+ij> select c11 from t1 where cast('fish' as clob(5))=cast('fish' as clob(5));
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as clob(5))!=cast('fish' as clob(5));
+ij> select c11 from t1 where cast('fish' as clob(5))!=cast('fish' as clob(5));
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as clob(5))<cast('fish' as clob(5));
+ij> select c11 from t1 where cast('fish' as clob(5))<cast('fish' as clob(5));
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as clob(5))>cast('fish' as clob(7));
+ij> select c11 from t1 where cast('fish' as clob(5))>cast('fish' as clob(7));
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as clob(5))<=cast('fish' as clob(7));
+ij> select c11 from t1 where cast('fish' as clob(5))<=cast('fish' as clob(7));
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as clob(5))>=cast('fish' as clob(7));
+ij> select c11 from t1 where cast('fish' as clob(5))>=cast('fish' as clob(7));
ERROR 42818: Comparisons between 'CLOB' and 'CLOB' are not supported.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as nclob(5))=cast('fish' as nclob(5));
+ij> select c11 from t1 where cast('fish' as nclob(5))=cast('fish' as nclob(5));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as nclob(5))!=cast('fish' as nclob(5));
+ij> select c11 from t1 where cast('fish' as nclob(5))!=cast('fish' as nclob(5));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as nclob(5))<cast('fish' as nclob(5));
+ij> select c11 from t1 where cast('fish' as nclob(5))<cast('fish' as nclob(5));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as nclob(5))>cast('fish' as nclob(7));
+ij> select c11 from t1 where cast('fish' as nclob(5))>cast('fish' as nclob(7));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as nclob(5))<=cast('fish' as nclob(7));
+ij> select c11 from t1 where cast('fish' as nclob(5))<=cast('fish' as nclob(7));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> select c11 from t1 where cast('fish' as nclob(5))>=cast('fish' as nclob(7));
+ij> select c11 from t1 where cast('fish' as nclob(5))>=cast('fish' as nclob(7));
ERROR 0A000: Feature not implemented: NCLOB.
-ij(CONNECTION1)> -- BIT STRING literal is not allowed in DB2
+ij> -- BIT STRING literal is not allowed in DB2
values cast(B'1' as blob(10));
ERROR 42X01: Syntax error: Encountered "\'1\'" at line 2, column 14.
-ij(CONNECTION1)>
+ij>
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/LOBDB2compatibility.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/LOBDB2compatibility.sql?rev=220006&r1=220005&r2=220006&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/LOBDB2compatibility.sql (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/LOBDB2compatibility.sql Wed Jul 20 23:38:35 2005
@@ -1,4 +1,3 @@
-connect 'jdbc:derby:jonas;create=true';
----- TEST TO RUN IN DB2 COMPATIBLITY MODE
--