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 fu...@apache.org on 2006/04/26 02:26:55 UTC
svn commit: r397028 [1/3] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/ master/DerbyNet/ master/DerbyNet/jdk16/ master/DerbyNetClient/
master/DerbyNetClient/jdk16/ tests/jdbc4/ tests/jdbcapi/ tests/tools/
Author: fuzzylogic
Date: Tue Apr 25 17:26:41 2006
New Revision: 397028
URL: http://svn.apache.org/viewcvs?rev=397028&view=rev
Log:
DERBY-575: Fix blobclob4BLOB, lobStreams, and ieptests on systems with non-ASCII
native encodings.
Committed for Myrna Van Lunteren <m....@gmail.com>
Added:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/aclob.utf
- copied unchanged from r397003, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/aclob.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/empty.utf
- copied unchanged from r397003, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/empty.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/littleclob.utf
- copied unchanged from r397003, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/littleclob.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/searchclob.utf
- copied unchanged from r397003, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/searchclob.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/short.utf
- copied unchanged from r397003, db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/short.txt
Removed:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/aclob.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/empty.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/littleclob.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/searchclob.txt
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/short.txt
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/blobclob4BLOB.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/blobclob4BLOB.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/blobclob4BLOB.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ieptests.out
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestConnectionMethods_app.properties
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/blobclob4BLOB.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/blobclob4BLOB_app.properties
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/build.xml
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/lobStreams.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/lobStreams_app.properties
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultsetStream.java
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultsetStream_app.properties
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/tools/ieptests.sql
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out?rev=397028&r1=397027&r2=397028&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out Tue Apr 25 17:26:41 2006
@@ -1,16 +1,16 @@
Test blobclob starting
START: prepareCLOBMAIN
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
START: prepareSearchClobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
prepareSearchClobTable finished
START: prepareUnicodeTable
START: prepareUnicodeFile
@@ -524,17 +524,17 @@
START: clobTest96
clobTest96 finished
START: prepareBlobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
START: prepareSearchBlobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
START: blobTest0
blobTest0 finished
START: blobTest2
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out?rev=397028&r1=397027&r2=397028&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ieptests.out Tue Apr 25 17:26:41 2006
@@ -656,7 +656,7 @@
ij> ---test with a file which has a differen records seperators (\n, \r , \r\n)
create table nt1( a int , b char(30));
0 rows inserted/updated/deleted
-ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'NT1', 'extin/mixednl.del',null, null, null,0);
+ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'NT1', 'extin/mixednl.del',null, null, 'UTF-8',0);
Statement executed.
ij> select * from nt1;
A |B
@@ -690,7 +690,7 @@
);
0 rows inserted/updated/deleted
ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE ('APP', 'POSITION_INFO', 'extin/position_info.del',
- null, null, null, 1);
+ null, null, 'US-ASCII', 1);
Statement executed.
ij> select count(*) from position_info ;
1
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out?rev=397028&r1=397027&r2=397028&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/blobclob4BLOB.out Tue Apr 25 17:26:41 2006
@@ -1,771 +1,771 @@
-Test blobclob starting
-START: prepareCLOBMAIN
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-START: prepareSearchClobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-prepareSearchClobTable finished
-START: prepareUnicodeTable
-START: prepareUnicodeFile
-unicode string 0 correct
-unicode string 1 correct
-unicode string 2 correct
-Finished prepareUnicodeFile
-START: setCharacterStreamTest
-Length of clob is 5009
-unicode string 0 matched
-unicode string 1 matched
-unicode string 2 matched
-EOF matched
-setCharacterStreamTest finished
-START: clobTest0
-clobTest0 finished
-START: clobTest1
-clobTest11 finished
-START: clobTest12
-Succeeded to match, row 1
-PASSED, row 1, length was 3
-Succeeded to match, row 2
-PASSED, row 2, length was 3
-Succeeded to match, row 3
-PASSED, row 3, length was 3
-Succeeded to match, row 4
-PASSED, row 4, length was 5016
-Succeeded to match, row 5
-PASSED, row 5, length was 5016
-Succeeded to match, row 6
-PASSED, row 6, length was 5016
-clobTest12 finished
-START: clobTest2
-CLOB getSubString 9905 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 1 > 0
-1(5) (len 50)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 1 > 0
-1(6) (len 1)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 9905 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 65
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 65
-EXPECTED Out of bounds exception
-2(5) (len 50) you can lead a horse to water but you can't form i
-2(6) (len 1) y
-CLOB getSubString 9905 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 26
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 26
-EXPECTED Out of bounds exception
-3(5) (len 50) a stitch in time says ouch
-3(6) (len 1) a
-CLOB getSubString 9905 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 42
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 42
-EXPECTED Out of bounds exception
-4(5) (len 50) here is a string with a return
- character
-4(6) (len 1) h
-CLOB getSubString 9905 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 56
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 56
-EXPECTED Out of bounds exception
-5(5) (len 50) test data: a string column inserted as an Ascii st
-5(6) (len 1) t
-6(0) (len 50) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
-6(1) (len 150) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(2) (len 50) I-am-hiding-here-at-position-5910-in-this-little-c
-6(3) (len 50) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(4) (len 50) wposition-69-end-of-the-first-l
-ine-we-are-now-on
-6(5) (len 50) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(6) (len 1) B
-6(7)
-wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-CLOB getSubString 9905 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 204 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 68 > 0
-EXPECTED Out of bounds exception
-CLOB getSubString 1 > 0
-7(5) (len 50)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 1 > 0
-7(6) (len 1)
-CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
-CLOB getSubString 9905 > 5000
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 5000
-EXPECTED Out of bounds exception
-CLOB getSubString 5910 > 5000
-EXPECTED Out of bounds exception
-8(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-8(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(6) (len 1) w
-8(7)
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(0) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(1) (len 150) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(2) (len 50) I-am-hiding-here-at-position-5910-in-this-humungus
-9(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-9(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(6) (len 1) w
-9(7)
-wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-clobTest2 finished
-START: clobTest22
-Row 1 : Succeeded
-Row 2 : Succeeded
-Row 3 : Succeeded
-Row 4 : Succeeded
-Second time Succeeded
-Row 5 : Succeeded
-Second time Succeeded
-Row 6 : Succeeded
-Second time Succeeded
-clobTest22 finished
-START: clobTest3
-Found horse in row 1 starting from position 1 at position NOTFOUND
-Found ouch in row 1 starting from position 1 at position NOTFOUND
-Found
- in row 1 starting from position 1 at position NOTFOUND
-Found in row 1 starting from position 1 at position 1
-Found Beginning in row 1 starting from position 1 at position NOTFOUND
-Found Beginning in row 1 starting from position 2 at position NOTFOUND
-Found position-69 in row 1 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 1 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 1 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 1 starting from position 1 at position NOTFOUND
-Found horse in row 2 starting from position 1 at position 16
-Found ouch in row 2 starting from position 1 at position NOTFOUND
-Found
- in row 2 starting from position 1 at position NOTFOUND
-Found in row 2 starting from position 1 at position 1
-Found Beginning in row 2 starting from position 1 at position NOTFOUND
-Found Beginning in row 2 starting from position 2 at position NOTFOUND
-Found position-69 in row 2 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 2 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 2 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 2 starting from position 1 at position NOTFOUND
-Found horse in row 3 starting from position 1 at position NOTFOUND
-Found ouch in row 3 starting from position 1 at position 23
-Found
- in row 3 starting from position 1 at position NOTFOUND
-Found in row 3 starting from position 1 at position 1
-Found Beginning in row 3 starting from position 1 at position NOTFOUND
-Found Beginning in row 3 starting from position 2 at position NOTFOUND
-Found position-69 in row 3 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 3 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 3 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 3 starting from position 1 at position NOTFOUND
-Found horse in row 4 starting from position 1 at position NOTFOUND
-Found ouch in row 4 starting from position 1 at position NOTFOUND
-Found
- in row 4 starting from position 1 at position 32
-Found in row 4 starting from position 1 at position 1
-Found Beginning in row 4 starting from position 1 at position NOTFOUND
-Found Beginning in row 4 starting from position 2 at position NOTFOUND
-Found position-69 in row 4 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 4 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 4 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 4 starting from position 1 at position NOTFOUND
-Found horse in row 5 starting from position 1 at position NOTFOUND
-Found ouch in row 5 starting from position 1 at position NOTFOUND
-Found
- in row 5 starting from position 1 at position 56
-Found in row 5 starting from position 1 at position 1
-Found Beginning in row 5 starting from position 1 at position NOTFOUND
-Found Beginning in row 5 starting from position 2 at position NOTFOUND
-Found position-69 in row 5 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 5 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 5 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 5 starting from position 1 at position NOTFOUND
-Found horse in row 6 starting from position 1 at position NOTFOUND
-Found ouch in row 6 starting from position 1 at position NOTFOUND
-Found
- in row 6 starting from position 1 at position 100
-Found in row 6 starting from position 1 at position 1
-Found Beginning in row 6 starting from position 1 at position 1
-Found Beginning in row 6 starting from position 2 at position NOTFOUND
-Found position-69 in row 6 starting from position 1 at position 69
-Found This-is-position-204 in row 6 starting from position 1 at position 204
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 6 starting from position 1 at position 9907
-Found horse in row 7 starting from position 1 at position NOTFOUND
-Found ouch in row 7 starting from position 1 at position NOTFOUND
-Found
- in row 7 starting from position 1 at position NOTFOUND
-Found in row 7 starting from position 1 at position 1
-Found Beginning in row 7 starting from position 1 at position NOTFOUND
-Found Beginning in row 7 starting from position 2 at position NOTFOUND
-Found position-69 in row 7 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 7 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 7 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 7 starting from position 1 at position NOTFOUND
-Found horse in row 8 starting from position 1 at position NOTFOUND
-Found ouch in row 8 starting from position 1 at position NOTFOUND
-Found
- in row 8 starting from position 1 at position 100
-Found in row 8 starting from position 1 at position 1
-Found Beginning in row 8 starting from position 1 at position NOTFOUND
-Found Beginning in row 8 starting from position 2 at position NOTFOUND
-Found position-69 in row 8 starting from position 1 at position NOTFOUND
-Found This-is-position-204 in row 8 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 8 starting from position 1 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5910 at position NOTFOUND
-Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5911 at position NOTFOUND
-Found Position-9907 in row 8 starting from position 1 at position NOTFOUND
-clobTest3 finished
-START: clobTest32
-Succeeded: Found unicode string 0 at position 1,row 1
-Succeeded: Found unicode string 0 at position -1,row 1
-Succeeded: Found unicode string 1 at position 1,row 2
-Succeeded: Found unicode string 1 at position -1,row 2
-Succeeded: Found unicode string 2 at position 1,row 3
-Succeeded: Found unicode string 2 at position -1,row 3
-Succeeded: Found unicode string 0 at position 1,row 4
-Succeeded: Found unicode string 0 at position 5004,row 4
-Succeeded: Found unicode string 1 at position 1,row 5
-Succeeded: Found unicode string 1 at position 5004,row 5
-Succeeded: Found unicode string 2 at position 1,row 6
-Succeeded: Found unicode string 2 at position 5004,row 6
-clobTest32 finished
-START: clobTest4
-position(clob) NOT FOUND 1 searchStr horse
-position(clob) NOT FOUND 1 searchStr ouch
-position(clob) NOT FOUND 1 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 1 searchStr Beginning
-position(clob) NOT FOUND 1 searchStr position-69
-position(clob) NOT FOUND 1 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 1 searchStr Position-9907
-position(clob) NOT FOUND 1 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 1 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 1 searchStr >150chars
-searchClob row 13 skipped (too large)
-Found horse in row 2 at position 16
-position(clob) NOT FOUND 2 searchStr ouch
-position(clob) NOT FOUND 2 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 65
-position(clob) NOT FOUND 2 searchStr Beginning
-position(clob) NOT FOUND 2 searchStr position-69
-position(clob) NOT FOUND 2 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 2 searchStr Position-9907
-position(clob) NOT FOUND 2 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 2 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 65
-position(clob) NOT FOUND 2 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 3 searchStr horse
-Found ouch in row 3 at position 23
-position(clob) NOT FOUND 3 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 26
-position(clob) NOT FOUND 3 searchStr Beginning
-position(clob) NOT FOUND 3 searchStr position-69
-position(clob) NOT FOUND 3 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 3 searchStr Position-9907
-position(clob) NOT FOUND 3 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 3 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 26
-position(clob) NOT FOUND 3 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 4 searchStr horse
-position(clob) NOT FOUND 4 searchStr ouch
-Found
- in row 4 at position 32
-position(clob) FOUND @ 1 with empty search clob in clob of length 42
-position(clob) NOT FOUND 4 searchStr Beginning
-position(clob) NOT FOUND 4 searchStr position-69
-position(clob) NOT FOUND 4 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 4 searchStr Position-9907
-position(clob) NOT FOUND 4 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 4 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 42
-position(clob) NOT FOUND 4 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 5 searchStr horse
-position(clob) NOT FOUND 5 searchStr ouch
-Found
- in row 5 at position 56
-position(clob) FOUND @ 1 with empty search clob in clob of length 56
-position(clob) NOT FOUND 5 searchStr Beginning
-position(clob) NOT FOUND 5 searchStr position-69
-position(clob) NOT FOUND 5 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 5 searchStr Position-9907
-Found test data: a string column inserted as an Ascii stream
- in row 5 at position 1
-position(clob) NOT FOUND 5 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 56
-position(clob) NOT FOUND 5 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 6 searchStr horse
-position(clob) NOT FOUND 6 searchStr ouch
-Found
- in row 6 at position 100
-position(clob) FOUND @ 1 with empty search clob in clob of length 10000
-Found Beginning in row 6 at position 1
-Found position-69 in row 6 at position 69
-Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
-Found Position-9907 in row 6 at position 9907
-position(clob) NOT FOUND 6 searchStr test data: a string column inserted as an Ascii stream
-Found clob (row 10) in row 6 at position 1
-position(clob) FOUND @ 1 with empty search clob in clob of length 10000
-Found clob (row 12) in row 6 at position 301
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 7 searchStr horse
-position(clob) NOT FOUND 7 searchStr ouch
-position(clob) NOT FOUND 7 searchStr
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 7 searchStr Beginning
-position(clob) NOT FOUND 7 searchStr position-69
-position(clob) NOT FOUND 7 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 7 searchStr Position-9907
-position(clob) NOT FOUND 7 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 7 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 0
-position(clob) NOT FOUND 7 searchStr >150chars
-searchClob row 13 skipped (too large)
-position(clob) NOT FOUND 8 searchStr horse
-position(clob) NOT FOUND 8 searchStr ouch
-Found
- in row 8 at position 100
-position(clob) FOUND @ 1 with empty search clob in clob of length 5000
-position(clob) NOT FOUND 8 searchStr Beginning
-position(clob) NOT FOUND 8 searchStr position-69
-position(clob) NOT FOUND 8 searchStr I-am-hiding-here-at-position-5910
-position(clob) NOT FOUND 8 searchStr Position-9907
-position(clob) NOT FOUND 8 searchStr test data: a string column inserted as an Ascii stream
-position(clob) NOT FOUND 8 searchStr >150chars
-position(clob) FOUND @ 1 with empty search clob in clob of length 5000
-Found clob (row 12) in row 8 at position 1
-searchClob row 13 skipped (too large)
-testCLOB_MAIN row 9 skipped (too large)
-clobTest4 finished
-START: clobTest42
-Succeeded: Found clob at position 1,row 0
-Succeeded: Found clob at position 1,row 1
-Succeeded: Found clob at position 1,row 2
-clobTest42 finished
-START: clobTest51
-clobTest51 finished
-START: clobTest52
-create table testInteger (a integer)
-insert into testInteger values('158')
-select a from testInteger
-getClob(1)
-52: SQLException
-EXPECTED SQL Exception: Invalid data conversion: Wrong result column type for requested conversion.
-START: clobTest53
-clobTest53 finished
-START: clobTest54
-EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER.
-end clobTest54
-START: clobTest6
- negative tests for clob.getSubstring won't run for network server until 5243 is fixed
-START: clobTest7
-clobTest7 finished
-START: clobTest8
-small string pattern
-@1 position MATCH(129)
-@2 position MATCH(2074)
-@3 position MATCH(4595)
-@4 position MATCH(34584)
-@5 position MATCH(67918)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-small java.sql.Clob pattern
-@1 position MATCH(129)
-@2 position MATCH(2074)
-@3 position MATCH(4595)
-@4 position MATCH(34584)
-@5 position MATCH(67918)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-medium string pattern
-@1 position MATCH(11253)
-@2 position MATCH(12225)
-@3 position MATCH(13478)
-@4 position MATCH(43467)
-@5 position MATCH(76801)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-medium java.sql.Clob pattern
-@1 position MATCH(11253)
-@2 position MATCH(12225)
-@3 position MATCH(13478)
-@4 position MATCH(43467)
-@5 position MATCH(76801)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-long string pattern
-@1 position MATCH(287875)
-@2 position MATCH(288847)
-@3 position MATCH(290108)
-@4 position MATCH(305102)
-@5 position MATCH(321769)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-long java.sql.Clob pattern
-@1 position MATCH(287875)
-@2 position MATCH(288847)
-@3 position MATCH(290108)
-@4 position MATCH(305102)
-@5 position MATCH(321769)
-@6 position MATCH(-1)
-@7 position MATCH(-1)
-@8 position MATCH(-1)
-@9 position MATCH(-1)
-@10 position MATCH(-1)
-complete clobTest8
-START: clobTest91
-done row 0, length was 0
-done row 1, length was 65
-done row 2, length was 26
-done row 3, length was 42
-done row 4, length was 56
-done row 5, length was 10000
-done row 6, length was 0
-done row 7, length was 5000
-done row 8, length was 300000
-row 9 is null, skipped
-clobTest91 finished
-START: clobTest92
-clobTest92 finished
-START: clobTest93
-clobTest92 finished
-START: clobTest94
-shortClob length after commit is 26
-clobTest94 finished
-START: clobTest95
-shortClob length after closing connection is 26
-EXPECTED SQL Exception: Lob method called after connection was closed
-EXPECTED SQL Exception: Lob method called after connection was closed
-EXPECTED SQL Exception: Lob method called after connection was closed
-EXPECTED SQL Exception: Lob method called after connection was closed
-clobTest95 finished
-START: clobTest96
-clobTest96 finished
-START: prepareBlobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-START: prepareSearchBlobTable
-===> inserting short.txt length = 56
-===> inserting littleclob.txt length = 10000
-===> inserting empty.txt length = 0
-===> inserting searchclob.txt length = 5000
-===> inserting aclob.txt length = 300000
-START: blobTest0
-blobTest0 finished
-START: blobTest2
-testing Blob.getBytes() with pos 9905 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 1 > 0
-1(5)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 1 > 0
-1(6)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 9905 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 65
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 65
-Known JCC Bug 5914
-2(5) you can lead a horse to water but you can't form i
-2(6) y
-testing Blob.getBytes() with pos 9905 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 26
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 26
-Known JCC Bug 5914
-3(5) a stitch in time says ouch
-3(6) a
-testing Blob.getBytes() with pos 9905 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 42
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 42
-Known JCC Bug 5914
-4(5) here is a string with a return
- character
-4(6) h
-testing Blob.getBytes() with pos 9905 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 56
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 56
-Known JCC Bug 5914
-5(5) test data: a string column inserted as an Ascii st
-5(6) t
-6(0) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
-6(1) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(2) I-am-hiding-here-at-position-5910-in-this-little-c
-6(3) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(4) wposition-69-end-of-the-first-l
-ine-we-are-now-on
-6(5) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-6(6) B
-6(7)
-wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-testing Blob.getBytes() with pos 9905 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 204 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 68 > 0
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 1 > 0
-7(5)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 1 > 0
-7(6)
-FAIL testing Blob.getBytes() with pos 1 > 0
-testing Blob.getBytes() with pos 9905 > 5000
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 5000
-Known JCC Bug 5914
-testing Blob.getBytes() with pos 5910 > 5000
-Known JCC Bug 5914
-8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-8(6) w
-8(7)
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(0) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(1) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(2) I-am-hiding-here-at-position-5910-in-this-humungus
-9(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-wwwwwwwwwwwwwwwww
-9(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-9(6) w
-9(7)
-wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
-blobTest2 finished
-START: blobTest3
-Found horse in row 2 starting from position 1 at position 16
-Found ouch in row 3 starting from position 1 at position 23
-Found
- in row 4 starting from position 1 at position 32
-Found
- in row 5 starting from position 1 at position 56
-Found
- in row 6 starting from position 1 at position 100
-Found Beginning in row 6 starting from position 1 at position 1
-Found position-69 in row 6 starting from position 1 at position 69
-Found This-is-position-204 in row 6 starting from position 1 at position 204
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
-Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
-Found Position-9907 in row 6 starting from position 1 at position 9907
-Found
- in row 8 starting from position 1 at position 100
-blobTest3 finished
-START: blobTest4
-searchBlob row 13 skipped (too large)
-Found horse in row 2 at position 16
-searchBlob row 13 skipped (too large)
-Found ouch in row 3 at position 23
-searchBlob row 13 skipped (too large)
-Found
- in row 4 at position 32
-searchBlob row 13 skipped (too large)
-Found
- in row 5 at position 56
-Found test data: a string column inserted as an Ascii stream
- in row 5 at position 1
-searchBlob row 13 skipped (too large)
-Found
- in row 6 at position 100
-Found Beginning in row 6 at position 1
-Found position-69 in row 6 at position 69
-Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
-Found Position-9907 in row 6 at position 9907
-Found blob (row 10) in row 6 at position 1
-Found blob (row 12) in row 6 at position 301
-searchBlob row 13 skipped (too large)
-searchBlob row 13 skipped (too large)
-Found
- in row 8 at position 100
-Found blob (row 12) in row 8 at position 1
-searchBlob row 13 skipped (too large)
-testBlob row 9 skipped (too large)
-blobTest4 finished
-START: blobTest51
-blobTest51 finished
-START: blobTest52
-EXPECTED SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
-START: blobTest53
-blobTest53 finished
-START: blobTest54
-EXPECTED SQLSTATE(XCL12): An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'.
-START: blobTest6
-EXPECTED SQLSTATE(null): Invalid position 0 or length 5
-EXPECTED SQLSTATE(null): Invalid position 1 or length -76
-EXPECTED SQLSTATE(null): Search pattern cannot be null.
-EXPECTED SQLSTATE(null): Search pattern cannot be null.
-blobTest6 finished
-START: blobTest7
-blobTest7 finished
-START: blobTest91
-done row 0, length was 0
-done row 1, length was 65
-done row 2, length was 26
-done row 3, length was 42
-done row 4, length was 56
-done row 5, length was 10000
-done row 6, length was 0
-done row 7, length was 5000
-done row 8, length was 300000
-row 9 is null, skipped
-blobTest91 finished
-START: blobTest92
-Locks not held by Network Server for Blobs since they are materialized on client
-blobTest92 finished
-START: blobTest93
-blobTest93 finished
-START: blobTest94
-shortBlob length after commit is 26
-blobTest94 finished
-START: blobTest95
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-EXPECTED SQLSTATE(null): Lob method called after connection was closed
-blobTest95 finished
-START: blobTest96
-blobTest96 finished
-START: clobTestSelfDestructive
-length of clob chosen is 10000
-After update
-Row 1 value.substring(0,50) is jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
-10000 total bytes read
-clobTestSelfDestructive finished
-START: clobTestSelfDestructive2
-length of clob chosen is 10000
-After drop
-Expect to get an IOException, container has been closed
-10000 total bytes read
-clobTestSelfDestructive2 finished
-START: clobNegativeTest_Derby265
------
-EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'java.sql.String' from an InputStream.
-START: blobTestNegativeTest_Derby265
------
-EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'BLOB' from an InputStream.
-FINISHED TEST blobclob :-)
-Test blobclob finished
+Test blobclob starting
+START: prepareCLOBMAIN
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
+START: prepareSearchClobTable
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
+prepareSearchClobTable finished
+START: prepareUnicodeTable
+START: prepareUnicodeFile
+unicode string 0 correct
+unicode string 1 correct
+unicode string 2 correct
+Finished prepareUnicodeFile
+START: setCharacterStreamTest
+Length of clob is 5009
+unicode string 0 matched
+unicode string 1 matched
+unicode string 2 matched
+EOF matched
+setCharacterStreamTest finished
+START: clobTest0
+clobTest0 finished
+START: clobTest1
+clobTest11 finished
+START: clobTest12
+Succeeded to match, row 1
+PASSED, row 1, length was 3
+Succeeded to match, row 2
+PASSED, row 2, length was 3
+Succeeded to match, row 3
+PASSED, row 3, length was 3
+Succeeded to match, row 4
+PASSED, row 4, length was 5016
+Succeeded to match, row 5
+PASSED, row 5, length was 5016
+Succeeded to match, row 6
+PASSED, row 6, length was 5016
+clobTest12 finished
+START: clobTest2
+CLOB getSubString 9905 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 1 > 0
+1(5) (len 50)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 1 > 0
+1(6) (len 1)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 9905 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 65
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 65
+EXPECTED Out of bounds exception
+2(5) (len 50) you can lead a horse to water but you can't form i
+2(6) (len 1) y
+CLOB getSubString 9905 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 26
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 26
+EXPECTED Out of bounds exception
+3(5) (len 50) a stitch in time says ouch
+3(6) (len 1) a
+CLOB getSubString 9905 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 42
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 42
+EXPECTED Out of bounds exception
+4(5) (len 50) here is a string with a return
+ character
+4(6) (len 1) h
+CLOB getSubString 9905 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 56
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 56
+EXPECTED Out of bounds exception
+5(5) (len 50) test data: a string column inserted as an Ascii st
+5(6) (len 1) t
+6(0) (len 50) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
+6(1) (len 150) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(2) (len 50) I-am-hiding-here-at-position-5910-in-this-little-c
+6(3) (len 50) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(4) (len 50) wposition-69-end-of-the-first-l
+ine-we-are-now-on
+6(5) (len 50) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(6) (len 1) B
+6(7)
+wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+CLOB getSubString 9905 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 204 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 68 > 0
+EXPECTED Out of bounds exception
+CLOB getSubString 1 > 0
+7(5) (len 50)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 1 > 0
+7(6) (len 1)
+CLOB FAIL - NO ERROR ON getSubString POS TOO LARGE 1 > 0
+CLOB getSubString 9905 > 5000
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 5000
+EXPECTED Out of bounds exception
+CLOB getSubString 5910 > 5000
+EXPECTED Out of bounds exception
+8(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+8(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(6) (len 1) w
+8(7)
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(0) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(1) (len 150) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(2) (len 50) I-am-hiding-here-at-position-5910-in-this-humungus
+9(3) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(4) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+9(5) (len 50) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(6) (len 1) w
+9(7)
+wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+clobTest2 finished
+START: clobTest22
+Row 1 : Succeeded
+Row 2 : Succeeded
+Row 3 : Succeeded
+Row 4 : Succeeded
+Second time Succeeded
+Row 5 : Succeeded
+Second time Succeeded
+Row 6 : Succeeded
+Second time Succeeded
+clobTest22 finished
+START: clobTest3
+Found horse in row 1 starting from position 1 at position NOTFOUND
+Found ouch in row 1 starting from position 1 at position NOTFOUND
+Found
+ in row 1 starting from position 1 at position NOTFOUND
+Found in row 1 starting from position 1 at position 1
+Found Beginning in row 1 starting from position 1 at position NOTFOUND
+Found Beginning in row 1 starting from position 2 at position NOTFOUND
+Found position-69 in row 1 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 1 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 1 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 1 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 1 starting from position 1 at position NOTFOUND
+Found horse in row 2 starting from position 1 at position 16
+Found ouch in row 2 starting from position 1 at position NOTFOUND
+Found
+ in row 2 starting from position 1 at position NOTFOUND
+Found in row 2 starting from position 1 at position 1
+Found Beginning in row 2 starting from position 1 at position NOTFOUND
+Found Beginning in row 2 starting from position 2 at position NOTFOUND
+Found position-69 in row 2 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 2 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 2 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 2 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 2 starting from position 1 at position NOTFOUND
+Found horse in row 3 starting from position 1 at position NOTFOUND
+Found ouch in row 3 starting from position 1 at position 23
+Found
+ in row 3 starting from position 1 at position NOTFOUND
+Found in row 3 starting from position 1 at position 1
+Found Beginning in row 3 starting from position 1 at position NOTFOUND
+Found Beginning in row 3 starting from position 2 at position NOTFOUND
+Found position-69 in row 3 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 3 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 3 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 3 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 3 starting from position 1 at position NOTFOUND
+Found horse in row 4 starting from position 1 at position NOTFOUND
+Found ouch in row 4 starting from position 1 at position NOTFOUND
+Found
+ in row 4 starting from position 1 at position 32
+Found in row 4 starting from position 1 at position 1
+Found Beginning in row 4 starting from position 1 at position NOTFOUND
+Found Beginning in row 4 starting from position 2 at position NOTFOUND
+Found position-69 in row 4 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 4 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 4 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 4 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 4 starting from position 1 at position NOTFOUND
+Found horse in row 5 starting from position 1 at position NOTFOUND
+Found ouch in row 5 starting from position 1 at position NOTFOUND
+Found
+ in row 5 starting from position 1 at position 56
+Found in row 5 starting from position 1 at position 1
+Found Beginning in row 5 starting from position 1 at position NOTFOUND
+Found Beginning in row 5 starting from position 2 at position NOTFOUND
+Found position-69 in row 5 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 5 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 5 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 5 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 5 starting from position 1 at position NOTFOUND
+Found horse in row 6 starting from position 1 at position NOTFOUND
+Found ouch in row 6 starting from position 1 at position NOTFOUND
+Found
+ in row 6 starting from position 1 at position 100
+Found in row 6 starting from position 1 at position 1
+Found Beginning in row 6 starting from position 1 at position 1
+Found Beginning in row 6 starting from position 2 at position NOTFOUND
+Found position-69 in row 6 starting from position 1 at position 69
+Found This-is-position-204 in row 6 starting from position 1 at position 204
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 6 starting from position 1 at position 9907
+Found horse in row 7 starting from position 1 at position NOTFOUND
+Found ouch in row 7 starting from position 1 at position NOTFOUND
+Found
+ in row 7 starting from position 1 at position NOTFOUND
+Found in row 7 starting from position 1 at position 1
+Found Beginning in row 7 starting from position 1 at position NOTFOUND
+Found Beginning in row 7 starting from position 2 at position NOTFOUND
+Found position-69 in row 7 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 7 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 7 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 7 starting from position 1 at position NOTFOUND
+Found horse in row 8 starting from position 1 at position NOTFOUND
+Found ouch in row 8 starting from position 1 at position NOTFOUND
+Found
+ in row 8 starting from position 1 at position 100
+Found in row 8 starting from position 1 at position 1
+Found Beginning in row 8 starting from position 1 at position NOTFOUND
+Found Beginning in row 8 starting from position 2 at position NOTFOUND
+Found position-69 in row 8 starting from position 1 at position NOTFOUND
+Found This-is-position-204 in row 8 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 8 starting from position 1 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5910 at position NOTFOUND
+Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5911 at position NOTFOUND
+Found Position-9907 in row 8 starting from position 1 at position NOTFOUND
+clobTest3 finished
+START: clobTest32
+Succeeded: Found unicode string 0 at position 1,row 1
+Succeeded: Found unicode string 0 at position -1,row 1
+Succeeded: Found unicode string 1 at position 1,row 2
+Succeeded: Found unicode string 1 at position -1,row 2
+Succeeded: Found unicode string 2 at position 1,row 3
+Succeeded: Found unicode string 2 at position -1,row 3
+Succeeded: Found unicode string 0 at position 1,row 4
+Succeeded: Found unicode string 0 at position 5004,row 4
+Succeeded: Found unicode string 1 at position 1,row 5
+Succeeded: Found unicode string 1 at position 5004,row 5
+Succeeded: Found unicode string 2 at position 1,row 6
+Succeeded: Found unicode string 2 at position 5004,row 6
+clobTest32 finished
+START: clobTest4
+position(clob) NOT FOUND 1 searchStr horse
+position(clob) NOT FOUND 1 searchStr ouch
+position(clob) NOT FOUND 1 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 1 searchStr Beginning
+position(clob) NOT FOUND 1 searchStr position-69
+position(clob) NOT FOUND 1 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 1 searchStr Position-9907
+position(clob) NOT FOUND 1 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 1 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 1 searchStr >150chars
+searchClob row 13 skipped (too large)
+Found horse in row 2 at position 16
+position(clob) NOT FOUND 2 searchStr ouch
+position(clob) NOT FOUND 2 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 65
+position(clob) NOT FOUND 2 searchStr Beginning
+position(clob) NOT FOUND 2 searchStr position-69
+position(clob) NOT FOUND 2 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 2 searchStr Position-9907
+position(clob) NOT FOUND 2 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 2 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 65
+position(clob) NOT FOUND 2 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 3 searchStr horse
+Found ouch in row 3 at position 23
+position(clob) NOT FOUND 3 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 26
+position(clob) NOT FOUND 3 searchStr Beginning
+position(clob) NOT FOUND 3 searchStr position-69
+position(clob) NOT FOUND 3 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 3 searchStr Position-9907
+position(clob) NOT FOUND 3 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 3 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 26
+position(clob) NOT FOUND 3 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 4 searchStr horse
+position(clob) NOT FOUND 4 searchStr ouch
+Found
+ in row 4 at position 32
+position(clob) FOUND @ 1 with empty search clob in clob of length 42
+position(clob) NOT FOUND 4 searchStr Beginning
+position(clob) NOT FOUND 4 searchStr position-69
+position(clob) NOT FOUND 4 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 4 searchStr Position-9907
+position(clob) NOT FOUND 4 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 4 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 42
+position(clob) NOT FOUND 4 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 5 searchStr horse
+position(clob) NOT FOUND 5 searchStr ouch
+Found
+ in row 5 at position 56
+position(clob) FOUND @ 1 with empty search clob in clob of length 56
+position(clob) NOT FOUND 5 searchStr Beginning
+position(clob) NOT FOUND 5 searchStr position-69
+position(clob) NOT FOUND 5 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 5 searchStr Position-9907
+Found test data: a string column inserted as an Ascii stream
+ in row 5 at position 1
+position(clob) NOT FOUND 5 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 56
+position(clob) NOT FOUND 5 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 6 searchStr horse
+position(clob) NOT FOUND 6 searchStr ouch
+Found
+ in row 6 at position 100
+position(clob) FOUND @ 1 with empty search clob in clob of length 10000
+Found Beginning in row 6 at position 1
+Found position-69 in row 6 at position 69
+Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
+Found Position-9907 in row 6 at position 9907
+position(clob) NOT FOUND 6 searchStr test data: a string column inserted as an Ascii stream
+Found clob (row 10) in row 6 at position 1
+position(clob) FOUND @ 1 with empty search clob in clob of length 10000
+Found clob (row 12) in row 6 at position 301
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 7 searchStr horse
+position(clob) NOT FOUND 7 searchStr ouch
+position(clob) NOT FOUND 7 searchStr
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 7 searchStr Beginning
+position(clob) NOT FOUND 7 searchStr position-69
+position(clob) NOT FOUND 7 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 7 searchStr Position-9907
+position(clob) NOT FOUND 7 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 7 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 0
+position(clob) NOT FOUND 7 searchStr >150chars
+searchClob row 13 skipped (too large)
+position(clob) NOT FOUND 8 searchStr horse
+position(clob) NOT FOUND 8 searchStr ouch
+Found
+ in row 8 at position 100
+position(clob) FOUND @ 1 with empty search clob in clob of length 5000
+position(clob) NOT FOUND 8 searchStr Beginning
+position(clob) NOT FOUND 8 searchStr position-69
+position(clob) NOT FOUND 8 searchStr I-am-hiding-here-at-position-5910
+position(clob) NOT FOUND 8 searchStr Position-9907
+position(clob) NOT FOUND 8 searchStr test data: a string column inserted as an Ascii stream
+position(clob) NOT FOUND 8 searchStr >150chars
+position(clob) FOUND @ 1 with empty search clob in clob of length 5000
+Found clob (row 12) in row 8 at position 1
+searchClob row 13 skipped (too large)
+testCLOB_MAIN row 9 skipped (too large)
+clobTest4 finished
+START: clobTest42
+Succeeded: Found clob at position 1,row 0
+Succeeded: Found clob at position 1,row 1
+Succeeded: Found clob at position 1,row 2
+clobTest42 finished
+START: clobTest51
+clobTest51 finished
+START: clobTest52
+create table testInteger (a integer)
+insert into testInteger values('158')
+select a from testInteger
+getClob(1)
+52: SQLException
+EXPECTED SQL Exception: Invalid data conversion: Wrong result column type for requested conversion.
+START: clobTest53
+clobTest53 finished
+START: clobTest54
+EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER.
+end clobTest54
+START: clobTest6
+ negative tests for clob.getSubstring won't run for network server until 5243 is fixed
+START: clobTest7
+clobTest7 finished
+START: clobTest8
+small string pattern
+@1 position MATCH(129)
+@2 position MATCH(2074)
+@3 position MATCH(4595)
+@4 position MATCH(34584)
+@5 position MATCH(67918)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+small java.sql.Clob pattern
+@1 position MATCH(129)
+@2 position MATCH(2074)
+@3 position MATCH(4595)
+@4 position MATCH(34584)
+@5 position MATCH(67918)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+medium string pattern
+@1 position MATCH(11253)
+@2 position MATCH(12225)
+@3 position MATCH(13478)
+@4 position MATCH(43467)
+@5 position MATCH(76801)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+medium java.sql.Clob pattern
+@1 position MATCH(11253)
+@2 position MATCH(12225)
+@3 position MATCH(13478)
+@4 position MATCH(43467)
+@5 position MATCH(76801)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+long string pattern
+@1 position MATCH(287875)
+@2 position MATCH(288847)
+@3 position MATCH(290108)
+@4 position MATCH(305102)
+@5 position MATCH(321769)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+long java.sql.Clob pattern
+@1 position MATCH(287875)
+@2 position MATCH(288847)
+@3 position MATCH(290108)
+@4 position MATCH(305102)
+@5 position MATCH(321769)
+@6 position MATCH(-1)
+@7 position MATCH(-1)
+@8 position MATCH(-1)
+@9 position MATCH(-1)
+@10 position MATCH(-1)
+complete clobTest8
+START: clobTest91
+done row 0, length was 0
+done row 1, length was 65
+done row 2, length was 26
+done row 3, length was 42
+done row 4, length was 56
+done row 5, length was 10000
+done row 6, length was 0
+done row 7, length was 5000
+done row 8, length was 300000
+row 9 is null, skipped
+clobTest91 finished
+START: clobTest92
+clobTest92 finished
+START: clobTest93
+clobTest92 finished
+START: clobTest94
+shortClob length after commit is 26
+clobTest94 finished
+START: clobTest95
+shortClob length after closing connection is 26
+EXPECTED SQL Exception: Lob method called after connection was closed
+EXPECTED SQL Exception: Lob method called after connection was closed
+EXPECTED SQL Exception: Lob method called after connection was closed
+EXPECTED SQL Exception: Lob method called after connection was closed
+clobTest95 finished
+START: clobTest96
+clobTest96 finished
+START: prepareBlobTable
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
+START: prepareSearchBlobTable
+===> inserting short.utf length = 56
+===> inserting littleclob.utf length = 10000
+===> inserting empty.utf length = 0
+===> inserting searchclob.utf length = 5000
+===> inserting aclob.utf length = 300000
+START: blobTest0
+blobTest0 finished
+START: blobTest2
+testing Blob.getBytes() with pos 9905 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 1 > 0
+1(5)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 1 > 0
+1(6)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 9905 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 65
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 65
+Known JCC Bug 5914
+2(5) you can lead a horse to water but you can't form i
+2(6) y
+testing Blob.getBytes() with pos 9905 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 26
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 26
+Known JCC Bug 5914
+3(5) a stitch in time says ouch
+3(6) a
+testing Blob.getBytes() with pos 9905 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 42
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 42
+Known JCC Bug 5914
+4(5) here is a string with a return
+ character
+4(6) h
+testing Blob.getBytes() with pos 9905 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 56
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 56
+Known JCC Bug 5914
+5(5) test data: a string column inserted as an Ascii st
+5(6) t
+6(0) wwPosition-9907-behold-the-end-of-the-clob-is-nigh
+6(1) I-am-hiding-here-at-position-5910-in-this-little-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(2) I-am-hiding-here-at-position-5910-in-this-little-c
+6(3) This-is-position-204wwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(4) wposition-69-end-of-the-first-l
+ine-we-are-now-on
+6(5) Beginning-this-is-itwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+6(6) B
+6(7)
+wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+testing Blob.getBytes() with pos 9905 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 204 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 68 > 0
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 1 > 0
+7(5)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 1 > 0
+7(6)
+FAIL testing Blob.getBytes() with pos 1 > 0
+testing Blob.getBytes() with pos 9905 > 5000
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 5000
+Known JCC Bug 5914
+testing Blob.getBytes() with pos 5910 > 5000
+Known JCC Bug 5914
+8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(6) w
+8(7)
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(0) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(1) I-am-hiding-here-at-position-5910-in-this-humungus-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(2) I-am-hiding-here-at-position-5910-in-this-humungus
+9(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+9(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+9(6) w
+9(7)
+wwHere-I-am-at-position-299003-near-the-end-of-the-clobwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+blobTest2 finished
+START: blobTest3
+Found horse in row 2 starting from position 1 at position 16
+Found ouch in row 3 starting from position 1 at position 23
+Found
+ in row 4 starting from position 1 at position 32
+Found
+ in row 5 starting from position 1 at position 56
+Found
+ in row 6 starting from position 1 at position 100
+Found Beginning in row 6 starting from position 1 at position 1
+Found position-69 in row 6 starting from position 1 at position 69
+Found This-is-position-204 in row 6 starting from position 1 at position 204
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 1 at position 5910
+Found I-am-hiding-here-at-position-5910 in row 6 starting from position 5910 at position 5910
+Found Position-9907 in row 6 starting from position 1 at position 9907
+Found
+ in row 8 starting from position 1 at position 100
+blobTest3 finished
+START: blobTest4
+searchBlob row 13 skipped (too large)
+Found horse in row 2 at position 16
+searchBlob row 13 skipped (too large)
+Found ouch in row 3 at position 23
+searchBlob row 13 skipped (too large)
+Found
+ in row 4 at position 32
+searchBlob row 13 skipped (too large)
+Found
+ in row 5 at position 56
+Found test data: a string column inserted as an Ascii stream
+ in row 5 at position 1
+searchBlob row 13 skipped (too large)
+Found
+ in row 6 at position 100
+Found Beginning in row 6 at position 1
+Found position-69 in row 6 at position 69
+Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
+Found Position-9907 in row 6 at position 9907
+Found blob (row 10) in row 6 at position 1
+Found blob (row 12) in row 6 at position 301
+searchBlob row 13 skipped (too large)
+searchBlob row 13 skipped (too large)
+Found
+ in row 8 at position 100
+Found blob (row 12) in row 8 at position 1
+searchBlob row 13 skipped (too large)
+testBlob row 9 skipped (too large)
+blobTest4 finished
+START: blobTest51
+blobTest51 finished
+START: blobTest52
+EXPECTED SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
+START: blobTest53
+blobTest53 finished
+START: blobTest54
+EXPECTED SQLSTATE(XCL12): An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'.
+START: blobTest6
+EXPECTED SQLSTATE(null): Invalid position 0 or length 5
+EXPECTED SQLSTATE(null): Invalid position 1 or length -76
+EXPECTED SQLSTATE(null): Search pattern cannot be null.
+EXPECTED SQLSTATE(null): Search pattern cannot be null.
+blobTest6 finished
+START: blobTest7
+blobTest7 finished
+START: blobTest91
+done row 0, length was 0
+done row 1, length was 65
+done row 2, length was 26
+done row 3, length was 42
+done row 4, length was 56
+done row 5, length was 10000
+done row 6, length was 0
+done row 7, length was 5000
+done row 8, length was 300000
+row 9 is null, skipped
+blobTest91 finished
+START: blobTest92
+Locks not held by Network Server for Blobs since they are materialized on client
+blobTest92 finished
+START: blobTest93
+blobTest93 finished
+START: blobTest94
+shortBlob length after commit is 26
+blobTest94 finished
+START: blobTest95
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+EXPECTED SQLSTATE(null): Lob method called after connection was closed
+blobTest95 finished
+START: blobTest96
+blobTest96 finished
+START: clobTestSelfDestructive
+length of clob chosen is 10000
+After update
+Row 1 value.substring(0,50) is jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
+10000 total bytes read
+clobTestSelfDestructive finished
+START: clobTestSelfDestructive2
+length of clob chosen is 10000
+After drop
+Expect to get an IOException, container has been closed
+10000 total bytes read
+clobTestSelfDestructive2 finished
+START: clobNegativeTest_Derby265
+-----
+EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'java.sql.String' from an InputStream.
+START: blobTestNegativeTest_Derby265
+-----
+EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'BLOB' from an InputStream.
+FINISHED TEST blobclob :-)
+Test blobclob finished