db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Van Couvering <David.Vancouver...@Sun.COM>
Subject 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
Date Wed, 23 Aug 2006 00:10:08 GMT
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
> 
> 

Mime
View raw message