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/08/23 00:54:33 UTC
svn commit: r433790 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet:
blobclob4BLOB.out jdk15/blobclob4BLOB.out ver2.6/blobclob4BLOB.out
Author: fuzzylogic
Date: Tue Aug 22 15:54:32 2006
New Revision: 433790
URL: http://svn.apache.org/viewvc?rev=433790&view=rev
Log:
Add some JCC and JDK version specific masters in the hopes of fixing the
blobclob4BLOB test.
Added:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out (with props)
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out (with props)
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out?rev=433790&r1=433789&r2=433790&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 Aug 22 15:54:32 2006
@@ -464,7 +464,6 @@
START: clobTest53
clobTest53 finished
START: clobTest54
-java.lang.StringIndexOutOfBoundsException: String index out of range: -1
EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER.
end clobTest54
START: clobTest6
@@ -473,6 +472,7 @@
EXPECTED SQLSTATE(null): Invalid position 1 or length -1
EXPECTED SQLSTATE(null): Invalid position 0 or length 0
FAIL -- unexpected exception:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
+java.lang.StringIndexOutOfBoundsException: String index out of range: -1
START: clobTest7
clobTest7 finished
START: clobTest8
@@ -773,7 +773,6 @@
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'.
-java.lang.NegativeArraySizeException
blobTest54 finished
START: blobTest6
EXPECTED SQLSTATE(null): Invalid position 0 or length 5
@@ -781,6 +780,7 @@
EXPECTED SQLSTATE(null): Invalid position 1 or length -1
EXPECTED SQLSTATE(null): Invalid position 0 or length 0
FAIL -- unexpected exception:java.lang.NegativeArraySizeException
+java.lang.NegativeArraySizeException
START: blobTest7
blobTest7 finished
START: blobTest8Trigger
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out?rev=433790&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out Tue Aug 22 15:54:32 2006
@@ -0,0 +1,837 @@
+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: clobTest13Trigger
+testCLOB_MAIN: NULL
+testCLOB_MAIN: length 0 crc32 0 0
+testCLOB_MAIN: length 0 crc32 0 0
+testCLOB_MAIN: length 26 crc32 3726329377 26
+testCLOB_MAIN: length 42 crc32 384104526 42
+testCLOB_MAIN: length 56 crc32 4255880856 56
+testCLOB_MAIN: length 65 crc32 3470395945 65
+testCLOB_MAIN: length 5000 crc32 2272896610 5000
+testCLOB_MAIN: length 10000 crc32 1814912934 10000
+testCLOB_MAIN: length 300000 crc32 3781770763 300000
+main update row count :10
+row trigger: NULL
+row trigger: length 0 crc32 0 0
+row trigger: length 0 crc32 0 0
+row trigger: length 26 crc32 3726329377 26
+row trigger: length 42 crc32 384104526 42
+row trigger: length 56 crc32 4255880856 56
+row trigger: length 65 crc32 3470395945 65
+row trigger: length 5000 crc32 2272896610 5000
+row trigger: length 10000 crc32 1814912934 10000
+row trigger: length 300000 crc32 3781770763 300000
+statement trigger: NULL
+statement trigger: length 0 crc32 0 0
+statement trigger: length 0 crc32 0 0
+statement trigger: length 26 crc32 3726329377 26
+statement trigger: length 42 crc32 384104526 42
+statement trigger: length 56 crc32 4255880856 56
+statement trigger: length 65 crc32 3470395945 65
+statement trigger: length 5000 crc32 2272896610 5000
+statement trigger: length 10000 crc32 1814912934 10000
+statement trigger: length 300000 crc32 3781770763 300000
+clobTest13Trigger 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
+1(5) (len 50)
+1(6) (len 1)
+1(7) (len 0)
+1(8) (len 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
+2(7) (len 0)
+2(8) (len 0)
+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
+3(7) (len 0)
+3(8) (len 0)
+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
+4(7) (len 0)
+4(8) (len 0)
+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
+5(7) (len 0)
+5(8) (len 0)
+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) (len 0)
+6(8) (len 0)
+6(9)
+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
+7(5) (len 50)
+7(6) (len 1)
+7(7) (len 0)
+7(8) (len 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) (len 0)
+8(8) (len 0)
+8(9)
+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) (len 0)
+9(8) (len 0)
+9(9)
+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
+EXPECTED SQLSTATE(null): Invalid position 0 or length 5
+EXPECTED SQLSTATE(null): Invalid position 1 or length -76
+EXPECTED SQLSTATE(null): Invalid position 1 or length -1
+EXPECTED SQLSTATE(null): Invalid position 0 or length 0
+FAIL -- unexpected exception:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
+java.lang.StringIndexOutOfBoundsException: String index out of range: -1
+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
+FAIL -- unexpected exception ****************
+SQLSTATE(40XL1): A lock could not be obtained within the time requested
+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
+Row Count 9 Null Row 1
+blobTest0 finished
+START: blobTest2
+testing Blob.getBytes() with pos 9905 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+1(5)
+1(6)
+1(7)
+1(8)
+testing Blob.getBytes() with pos 9905 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+2(5) you can lead a horse to water but you can't form i
+2(6) y
+2(7)
+2(8)
+testing Blob.getBytes() with pos 9905 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+3(5) a stitch in time says ouch
+3(6) a
+3(7)
+3(8)
+testing Blob.getBytes() with pos 9905 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+4(5) here is a string with a return
+ character
+4(6) h
+4(7)
+4(8)
+testing Blob.getBytes() with pos 9905 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+5(5) test data: a string column inserted as an Ascii st
+5(6) t
+5(7)
+5(8)
+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)
+6(8)
+6(9)
+wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+testing Blob.getBytes() with pos 9905 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+7(5)
+7(6)
+7(7)
+7(8)
+testing Blob.getBytes() with pos 9905 > 5000
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 5000
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 5000
+FAIL: Caught exception java.lang.NegativeArraySizeException
+8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(6) w
+8(7)
+8(8)
+8(9)
+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)
+9(8)
+9(9)
+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
+FAIL -- unexpected exception ****************
+SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
+blobTest52 finished
+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'.
+blobTest54 finished
+START: blobTest6
+EXPECTED SQLSTATE(null): Invalid position 0 or length 5
+EXPECTED SQLSTATE(null): Invalid position 1 or length -76
+EXPECTED SQLSTATE(null): Invalid position 1 or length -1
+EXPECTED SQLSTATE(null): Invalid position 0 or length 0
+FAIL -- unexpected exception:java.lang.NegativeArraySizeException
+START: blobTest7
+java.lang.NegativeArraySizeException
+blobTest7 finished
+START: blobTest8Trigger
+FAIL -- unexpected exception ****************
+SQLSTATE(X0X95): Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
+<FILTERED>.SqlException: Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
+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
+-----
+START: blobTestNegativeTest_Derby265
+-----
+FINISHED TEST blobclob :-)
+Test blobclob finished
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out
------------------------------------------------------------------------------
svn:eol-style = native
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out?rev=433790&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out Tue Aug 22 15:54:32 2006
@@ -0,0 +1,837 @@
+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: clobTest13Trigger
+testCLOB_MAIN: NULL
+testCLOB_MAIN: length 0 crc32 0 0
+testCLOB_MAIN: length 0 crc32 0 0
+testCLOB_MAIN: length 26 crc32 3726329377 26
+testCLOB_MAIN: length 42 crc32 384104526 42
+testCLOB_MAIN: length 56 crc32 4255880856 56
+testCLOB_MAIN: length 65 crc32 3470395945 65
+testCLOB_MAIN: length 5000 crc32 2272896610 5000
+testCLOB_MAIN: length 10000 crc32 1814912934 10000
+testCLOB_MAIN: length 300000 crc32 3781770763 300000
+main update row count :10
+row trigger: NULL
+row trigger: length 0 crc32 0 0
+row trigger: length 0 crc32 0 0
+row trigger: length 26 crc32 3726329377 26
+row trigger: length 42 crc32 384104526 42
+row trigger: length 56 crc32 4255880856 56
+row trigger: length 65 crc32 3470395945 65
+row trigger: length 5000 crc32 2272896610 5000
+row trigger: length 10000 crc32 1814912934 10000
+row trigger: length 300000 crc32 3781770763 300000
+statement trigger: NULL
+statement trigger: length 0 crc32 0 0
+statement trigger: length 0 crc32 0 0
+statement trigger: length 26 crc32 3726329377 26
+statement trigger: length 42 crc32 384104526 42
+statement trigger: length 56 crc32 4255880856 56
+statement trigger: length 65 crc32 3470395945 65
+statement trigger: length 5000 crc32 2272896610 5000
+statement trigger: length 10000 crc32 1814912934 10000
+statement trigger: length 300000 crc32 3781770763 300000
+clobTest13Trigger 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
+1(5) (len 50)
+1(6) (len 1)
+1(7) (len 0)
+1(8) (len 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
+2(7) (len 0)
+2(8) (len 0)
+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
+3(7) (len 0)
+3(8) (len 0)
+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
+4(7) (len 0)
+4(8) (len 0)
+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
+5(7) (len 0)
+5(8) (len 0)
+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) (len 0)
+6(8) (len 0)
+6(9)
+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
+7(5) (len 50)
+7(6) (len 1)
+7(7) (len 0)
+7(8) (len 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) (len 0)
+8(8) (len 0)
+8(9)
+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) (len 0)
+9(8) (len 0)
+9(9)
+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
+EXPECTED SQLSTATE(null): Invalid position 0 or length 5
+EXPECTED SQLSTATE(null): Invalid position 1 or length -76
+EXPECTED SQLSTATE(null): Invalid position 1 or length -1
+EXPECTED SQLSTATE(null): Invalid position 0 or length 0
+FAIL -- unexpected exception:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
+java.lang.StringIndexOutOfBoundsException: String index out of range: -1
+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
+FAIL -- unexpected exception ****************
+SQLSTATE(40XL1): A lock could not be obtained within the time requested
+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
+Row Count 9 Null Row 1
+blobTest0 finished
+START: blobTest2
+testing Blob.getBytes() with pos 9905 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+1(5)
+1(6)
+1(7)
+1(8)
+testing Blob.getBytes() with pos 9905 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 65
+FAIL: Caught exception java.lang.NegativeArraySizeException
+2(5) you can lead a horse to water but you can't form i
+2(6) y
+2(7)
+2(8)
+testing Blob.getBytes() with pos 9905 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 26
+FAIL: Caught exception java.lang.NegativeArraySizeException
+3(5) a stitch in time says ouch
+3(6) a
+3(7)
+3(8)
+testing Blob.getBytes() with pos 9905 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 42
+FAIL: Caught exception java.lang.NegativeArraySizeException
+4(5) here is a string with a return
+ character
+4(6) h
+4(7)
+4(8)
+testing Blob.getBytes() with pos 9905 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 56
+FAIL: Caught exception java.lang.NegativeArraySizeException
+5(5) test data: a string column inserted as an Ascii st
+5(6) t
+5(7)
+5(8)
+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)
+6(8)
+6(9)
+wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+testing Blob.getBytes() with pos 9905 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 204 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 68 > 0
+FAIL: Caught exception java.lang.NegativeArraySizeException
+7(5)
+7(6)
+7(7)
+7(8)
+testing Blob.getBytes() with pos 9905 > 5000
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 5000
+FAIL: Caught exception java.lang.NegativeArraySizeException
+testing Blob.getBytes() with pos 5910 > 5000
+FAIL: Caught exception java.lang.NegativeArraySizeException
+8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+wwwwwwwwwwwwwwwww
+8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
+8(6) w
+8(7)
+8(8)
+8(9)
+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)
+9(8)
+9(9)
+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
+FAIL -- unexpected exception ****************
+SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
+blobTest52 finished
+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'.
+blobTest54 finished
+START: blobTest6
+EXPECTED SQLSTATE(null): Invalid position 0 or length 5
+EXPECTED SQLSTATE(null): Invalid position 1 or length -76
+EXPECTED SQLSTATE(null): Invalid position 1 or length -1
+EXPECTED SQLSTATE(null): Invalid position 0 or length 0
+FAIL -- unexpected exception:java.lang.NegativeArraySizeException
+START: blobTest7
+java.lang.NegativeArraySizeException
+blobTest7 finished
+START: blobTest8Trigger
+FAIL -- unexpected exception ****************
+SQLSTATE(X0X95): Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
+<FILTERED>.SqlException: Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
+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
+-----
+START: blobTestNegativeTest_Derby265
+-----
+FINISHED TEST blobclob :-)
+Test blobclob finished
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out
------------------------------------------------------------------------------
svn:eol-style = native
Re: svn commit: r433790 - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet:
blobclob4BLOB.out jdk15/blobclob4BLOB.out ver2.6/blobclob4BLOB.out
Posted by David Van Couvering <Da...@Sun.COM>.
Thanks, Andrew. I just haven't had time to address this this week.
Sorry I went radio silent -- I was thinking about how to fix it but
never finding time to get to it.
David
fuzzylogic@apache.org wrote:
> Author: fuzzylogic
> Date: Tue Aug 22 15:54:32 2006
> New Revision: 433790
>
> URL: http://svn.apache.org/viewvc?rev=433790&view=rev
> Log:
> Add some JCC and JDK version specific masters in the hopes of fixing the
> blobclob4BLOB test.
>
> Added:
> db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out (with props)
> db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out (with props)
> Modified:
> db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out
>
> Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out
> URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/blobclob4BLOB.out?rev=433790&r1=433789&r2=433790&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 Aug 22 15:54:32 2006
> @@ -464,7 +464,6 @@
> START: clobTest53
> clobTest53 finished
> START: clobTest54
> -java.lang.StringIndexOutOfBoundsException: String index out of range: -1
> EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER.
> end clobTest54
> START: clobTest6
> @@ -473,6 +472,7 @@
> EXPECTED SQLSTATE(null): Invalid position 1 or length -1
> EXPECTED SQLSTATE(null): Invalid position 0 or length 0
> FAIL -- unexpected exception:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
> +java.lang.StringIndexOutOfBoundsException: String index out of range: -1
> START: clobTest7
> clobTest7 finished
> START: clobTest8
> @@ -773,7 +773,6 @@
> 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'.
> -java.lang.NegativeArraySizeException
> blobTest54 finished
> START: blobTest6
> EXPECTED SQLSTATE(null): Invalid position 0 or length 5
> @@ -781,6 +780,7 @@
> EXPECTED SQLSTATE(null): Invalid position 1 or length -1
> EXPECTED SQLSTATE(null): Invalid position 0 or length 0
> FAIL -- unexpected exception:java.lang.NegativeArraySizeException
> +java.lang.NegativeArraySizeException
> START: blobTest7
> blobTest7 finished
> START: blobTest8Trigger
>
> Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out
> URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out?rev=433790&view=auto
> ==============================================================================
> --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out (added)
> +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out Tue Aug 22 15:54:32 2006
> @@ -0,0 +1,837 @@
> +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: clobTest13Trigger
> +testCLOB_MAIN: NULL
> +testCLOB_MAIN: length 0 crc32 0 0
> +testCLOB_MAIN: length 0 crc32 0 0
> +testCLOB_MAIN: length 26 crc32 3726329377 26
> +testCLOB_MAIN: length 42 crc32 384104526 42
> +testCLOB_MAIN: length 56 crc32 4255880856 56
> +testCLOB_MAIN: length 65 crc32 3470395945 65
> +testCLOB_MAIN: length 5000 crc32 2272896610 5000
> +testCLOB_MAIN: length 10000 crc32 1814912934 10000
> +testCLOB_MAIN: length 300000 crc32 3781770763 300000
> +main update row count :10
> +row trigger: NULL
> +row trigger: length 0 crc32 0 0
> +row trigger: length 0 crc32 0 0
> +row trigger: length 26 crc32 3726329377 26
> +row trigger: length 42 crc32 384104526 42
> +row trigger: length 56 crc32 4255880856 56
> +row trigger: length 65 crc32 3470395945 65
> +row trigger: length 5000 crc32 2272896610 5000
> +row trigger: length 10000 crc32 1814912934 10000
> +row trigger: length 300000 crc32 3781770763 300000
> +statement trigger: NULL
> +statement trigger: length 0 crc32 0 0
> +statement trigger: length 0 crc32 0 0
> +statement trigger: length 26 crc32 3726329377 26
> +statement trigger: length 42 crc32 384104526 42
> +statement trigger: length 56 crc32 4255880856 56
> +statement trigger: length 65 crc32 3470395945 65
> +statement trigger: length 5000 crc32 2272896610 5000
> +statement trigger: length 10000 crc32 1814912934 10000
> +statement trigger: length 300000 crc32 3781770763 300000
> +clobTest13Trigger 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
> +1(5) (len 50)
> +1(6) (len 1)
> +1(7) (len 0)
> +1(8) (len 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
> +2(7) (len 0)
> +2(8) (len 0)
> +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
> +3(7) (len 0)
> +3(8) (len 0)
> +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
> +4(7) (len 0)
> +4(8) (len 0)
> +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
> +5(7) (len 0)
> +5(8) (len 0)
> +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) (len 0)
> +6(8) (len 0)
> +6(9)
> +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
> +7(5) (len 50)
> +7(6) (len 1)
> +7(7) (len 0)
> +7(8) (len 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) (len 0)
> +8(8) (len 0)
> +8(9)
> +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) (len 0)
> +9(8) (len 0)
> +9(9)
> +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
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 5
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -76
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -1
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 0
> +FAIL -- unexpected exception:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
> +java.lang.StringIndexOutOfBoundsException: String index out of range: -1
> +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
> +FAIL -- unexpected exception ****************
> +SQLSTATE(40XL1): A lock could not be obtained within the time requested
> +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
> +Row Count 9 Null Row 1
> +blobTest0 finished
> +START: blobTest2
> +testing Blob.getBytes() with pos 9905 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +1(5)
> +1(6)
> +1(7)
> +1(8)
> +testing Blob.getBytes() with pos 9905 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +2(5) you can lead a horse to water but you can't form i
> +2(6) y
> +2(7)
> +2(8)
> +testing Blob.getBytes() with pos 9905 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +3(5) a stitch in time says ouch
> +3(6) a
> +3(7)
> +3(8)
> +testing Blob.getBytes() with pos 9905 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +4(5) here is a string with a return
> + character
> +4(6) h
> +4(7)
> +4(8)
> +testing Blob.getBytes() with pos 9905 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +5(5) test data: a string column inserted as an Ascii st
> +5(6) t
> +5(7)
> +5(8)
> +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)
> +6(8)
> +6(9)
> +wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +testing Blob.getBytes() with pos 9905 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +7(5)
> +7(6)
> +7(7)
> +7(8)
> +testing Blob.getBytes() with pos 9905 > 5000
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 5000
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 5000
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +wwwwwwwwwwwwwwwww
> +8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +8(6) w
> +8(7)
> +8(8)
> +8(9)
> +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)
> +9(8)
> +9(9)
> +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
> +FAIL -- unexpected exception ****************
> +SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
> +blobTest52 finished
> +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'.
> +blobTest54 finished
> +START: blobTest6
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 5
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -76
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -1
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 0
> +FAIL -- unexpected exception:java.lang.NegativeArraySizeException
> +START: blobTest7
> +java.lang.NegativeArraySizeException
> +blobTest7 finished
> +START: blobTest8Trigger
> +FAIL -- unexpected exception ****************
> +SQLSTATE(X0X95): Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
> +<FILTERED>.SqlException: Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
> +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
> +-----
> +START: blobTestNegativeTest_Derby265
> +-----
> +FINISHED TEST blobclob :-)
> +Test blobclob finished
>
> Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk15/blobclob4BLOB.out
> ------------------------------------------------------------------------------
> svn:eol-style = native
>
> Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out
> URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out?rev=433790&view=auto
> ==============================================================================
> --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out (added)
> +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out Tue Aug 22 15:54:32 2006
> @@ -0,0 +1,837 @@
> +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: clobTest13Trigger
> +testCLOB_MAIN: NULL
> +testCLOB_MAIN: length 0 crc32 0 0
> +testCLOB_MAIN: length 0 crc32 0 0
> +testCLOB_MAIN: length 26 crc32 3726329377 26
> +testCLOB_MAIN: length 42 crc32 384104526 42
> +testCLOB_MAIN: length 56 crc32 4255880856 56
> +testCLOB_MAIN: length 65 crc32 3470395945 65
> +testCLOB_MAIN: length 5000 crc32 2272896610 5000
> +testCLOB_MAIN: length 10000 crc32 1814912934 10000
> +testCLOB_MAIN: length 300000 crc32 3781770763 300000
> +main update row count :10
> +row trigger: NULL
> +row trigger: length 0 crc32 0 0
> +row trigger: length 0 crc32 0 0
> +row trigger: length 26 crc32 3726329377 26
> +row trigger: length 42 crc32 384104526 42
> +row trigger: length 56 crc32 4255880856 56
> +row trigger: length 65 crc32 3470395945 65
> +row trigger: length 5000 crc32 2272896610 5000
> +row trigger: length 10000 crc32 1814912934 10000
> +row trigger: length 300000 crc32 3781770763 300000
> +statement trigger: NULL
> +statement trigger: length 0 crc32 0 0
> +statement trigger: length 0 crc32 0 0
> +statement trigger: length 26 crc32 3726329377 26
> +statement trigger: length 42 crc32 384104526 42
> +statement trigger: length 56 crc32 4255880856 56
> +statement trigger: length 65 crc32 3470395945 65
> +statement trigger: length 5000 crc32 2272896610 5000
> +statement trigger: length 10000 crc32 1814912934 10000
> +statement trigger: length 300000 crc32 3781770763 300000
> +clobTest13Trigger 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
> +1(5) (len 50)
> +1(6) (len 1)
> +1(7) (len 0)
> +1(8) (len 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
> +2(7) (len 0)
> +2(8) (len 0)
> +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
> +3(7) (len 0)
> +3(8) (len 0)
> +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
> +4(7) (len 0)
> +4(8) (len 0)
> +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
> +5(7) (len 0)
> +5(8) (len 0)
> +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) (len 0)
> +6(8) (len 0)
> +6(9)
> +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
> +7(5) (len 50)
> +7(6) (len 1)
> +7(7) (len 0)
> +7(8) (len 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) (len 0)
> +8(8) (len 0)
> +8(9)
> +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) (len 0)
> +9(8) (len 0)
> +9(9)
> +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
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 5
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -76
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -1
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 0
> +FAIL -- unexpected exception:java.lang.StringIndexOutOfBoundsException: String index out of range: -1
> +java.lang.StringIndexOutOfBoundsException: String index out of range: -1
> +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
> +FAIL -- unexpected exception ****************
> +SQLSTATE(40XL1): A lock could not be obtained within the time requested
> +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
> +Row Count 9 Null Row 1
> +blobTest0 finished
> +START: blobTest2
> +testing Blob.getBytes() with pos 9905 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +1(5)
> +1(6)
> +1(7)
> +1(8)
> +testing Blob.getBytes() with pos 9905 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 65
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +2(5) you can lead a horse to water but you can't form i
> +2(6) y
> +2(7)
> +2(8)
> +testing Blob.getBytes() with pos 9905 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 26
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +3(5) a stitch in time says ouch
> +3(6) a
> +3(7)
> +3(8)
> +testing Blob.getBytes() with pos 9905 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 42
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +4(5) here is a string with a return
> + character
> +4(6) h
> +4(7)
> +4(8)
> +testing Blob.getBytes() with pos 9905 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 56
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +5(5) test data: a string column inserted as an Ascii st
> +5(6) t
> +5(7)
> +5(8)
> +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)
> +6(8)
> +6(9)
> +wwwwwwPosition-9907-behold-the-end-of-the-clob-is-nighwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +testing Blob.getBytes() with pos 9905 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 204 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 68 > 0
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +7(5)
> +7(6)
> +7(7)
> +7(8)
> +testing Blob.getBytes() with pos 9905 > 5000
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 5000
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +testing Blob.getBytes() with pos 5910 > 5000
> +FAIL: Caught exception java.lang.NegativeArraySizeException
> +8(3) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +8(4) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +wwwwwwwwwwwwwwwww
> +8(5) wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww
> +8(6) w
> +8(7)
> +8(8)
> +8(9)
> +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)
> +9(8)
> +9(9)
> +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
> +FAIL -- unexpected exception ****************
> +SQLSTATE(null): Invalid data conversion: Wrong result column type for requested conversion.
> +blobTest52 finished
> +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'.
> +blobTest54 finished
> +START: blobTest6
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 5
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -76
> +EXPECTED SQLSTATE(null): Invalid position 1 or length -1
> +EXPECTED SQLSTATE(null): Invalid position 0 or length 0
> +FAIL -- unexpected exception:java.lang.NegativeArraySizeException
> +START: blobTest7
> +java.lang.NegativeArraySizeException
> +blobTest7 finished
> +START: blobTest8Trigger
> +FAIL -- unexpected exception ****************
> +SQLSTATE(X0X95): Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
> +<FILTERED>.SqlException: Operation 'CREATE TRIGGER' cannot be performed on object 'TESTBLOB' because there is an open ResultSet dependent on that object.
> +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
> +-----
> +START: blobTestNegativeTest_Derby265
> +-----
> +FINISHED TEST blobclob :-)
> +Test blobclob finished
>
> Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.6/blobclob4BLOB.out
> ------------------------------------------------------------------------------
> svn:eol-style = native
>
>