blobclob4blob.out

derby database source code.good for you.

Found Beginning in row 7 starting from position 1 at position  NOTFOUND 
Found Beginning in row 7 starting from position 2 at position  NOTFOUND 
Found position-69 in row 7 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 7 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 7 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 7 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 7 starting from position 1 at position  NOTFOUND 
Found horse in row 8 starting from position 1 at position  NOTFOUND 
Found ouch in row 8 starting from position 1 at position  NOTFOUND 
Found 
 in row 8 starting from position 1 at position 100
Found  in row 8 starting from position 1 at position 1
Found Beginning in row 8 starting from position 1 at position  NOTFOUND 
Found Beginning in row 8 starting from position 2 at position  NOTFOUND 
Found position-69 in row 8 starting from position 1 at position  NOTFOUND 
Found This-is-position-204 in row 8 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 8 starting from position 1 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5910 at position  NOTFOUND 
Found I-am-hiding-here-at-position-5910 in row 8 starting from position 5911 at position  NOTFOUND 
Found Position-9907 in row 8 starting from position 1 at position  NOTFOUND 
clobTest3 finished
START: clobTest32
Succeeded: Found unicode string 0 at position 1,row 1
Succeeded: Found unicode string 0 at position -1,row 1
Succeeded: Found unicode string 1 at position 1,row 2
Succeeded: Found unicode string 1 at position -1,row 2
Succeeded: Found unicode string 2 at position 1,row 3
Succeeded: Found unicode string 2 at position -1,row 3
Succeeded: Found unicode string 0 at position 1,row 4
Succeeded: Found unicode string 0 at position 5004,row 4
Succeeded: Found unicode string 1 at position 1,row 5
Succeeded: Found unicode string 1 at position 5004,row 5
Succeeded: Found unicode string 2 at position 1,row 6
Succeeded: Found unicode string 2 at position 5004,row 6
clobTest32 finished
START: clobTest4
position(clob) NOT FOUND 1 searchStr horse
position(clob) NOT FOUND 1 searchStr ouch
position(clob) NOT FOUND 1 searchStr 
position(clob) FOUND @ 1 with empty search clob in clob of length 0
position(clob) NOT FOUND 1 searchStr Beginning
position(clob) NOT FOUND 1 searchStr position-69
position(clob) NOT FOUND 1 searchStr I-am-hiding-here-at-position-5910
position(clob) NOT FOUND 1 searchStr Position-9907
position(clob) NOT FOUND 1 searchStr test data: a string column inserted as an Ascii stream
position(clob) NOT FOUND 1 searchStr >150chars
position(clob) FOUND @ 1 with empty search clob in clob of length 0
position(clob) NOT FOUND 1 searchStr >150chars
searchClob row 13 skipped (too large)
Found horse in row 2 at position 16
position(clob) NOT FOUND 2 searchStr ouch
position(clob) NOT FOUND 2 searchStr 
position(clob) FOUND @ 1 with empty search clob in clob of length 65
position(clob) NOT FOUND 2 searchStr Beginning
position(clob) NOT FOUND 2 searchStr position-69
position(clob) NOT FOUND 2 searchStr I-am-hiding-here-at-position-5910
position(clob) NOT FOUND 2 searchStr Position-9907
position(clob) NOT FOUND 2 searchStr test data: a string column inserted as an Ascii stream
position(clob) NOT FOUND 2 searchStr >150chars
position(clob) FOUND @ 1 with empty search clob in clob of length 65
position(clob) NOT FOUND 2 searchStr >150chars
searchClob row 13 skipped (too large)
position(clob) NOT FOUND 3 searchStr horse
Found ouch in row 3 at position 23
position(clob) NOT FOUND 3 searchStr 
position(clob) FOUND @ 1 with empty search clob in clob of length 26
position(clob) NOT FOUND 3 searchStr Beginning
position(clob) NOT FOUND 3 searchStr position-69
position(clob) NOT FOUND 3 searchStr I-am-hiding-here-at-position-5910
position(clob) NOT FOUND 3 searchStr Position-9907
position(clob) NOT FOUND 3 searchStr test data: a string column inserted as an Ascii stream
position(clob) NOT FOUND 3 searchStr >150chars
position(clob) FOUND @ 1 with empty search clob in clob of length 26
position(clob) NOT FOUND 3 searchStr >150chars
searchClob row 13 skipped (too large)
position(clob) NOT FOUND 4 searchStr horse
position(clob) NOT FOUND 4 searchStr ouch
Found 
 in row 4 at position 32
position(clob) FOUND @ 1 with empty search clob in clob of length 42
position(clob) NOT FOUND 4 searchStr Beginning
position(clob) NOT FOUND 4 searchStr position-69
position(clob) NOT FOUND 4 searchStr I-am-hiding-here-at-position-5910
position(clob) NOT FOUND 4 searchStr Position-9907
position(clob) NOT FOUND 4 searchStr test data: a string column inserted as an Ascii stream
position(clob) NOT FOUND 4 searchStr >150chars
position(clob) FOUND @ 1 with empty search clob in clob of length 42
position(clob) NOT FOUND 4 searchStr >150chars
searchClob row 13 skipped (too large)
position(clob) NOT FOUND 5 searchStr horse
position(clob) NOT FOUND 5 searchStr ouch
Found 
 in row 5 at position 56
position(clob) FOUND @ 1 with empty search clob in clob of length 56
position(clob) NOT FOUND 5 searchStr Beginning
position(clob) NOT FOUND 5 searchStr position-69
position(clob) NOT FOUND 5 searchStr I-am-hiding-here-at-position-5910
position(clob) NOT FOUND 5 searchStr Position-9907
Found test data: a string column inserted as an Ascii stream
 in row 5 at position 1
position(clob) NOT FOUND 5 searchStr >150chars
position(clob) FOUND @ 1 with empty search clob in clob of length 56
position(clob) NOT FOUND 5 searchStr >150chars
searchClob row 13 skipped (too large)
position(clob) NOT FOUND 6 searchStr horse
position(clob) NOT FOUND 6 searchStr ouch
Found 
 in row 6 at position 100
position(clob) FOUND @ 1 with empty search clob in clob of length 10000
Found Beginning in row 6 at position 1
Found position-69 in row 6 at position 69
Found I-am-hiding-here-at-position-5910 in row 6 at position 5910
Found Position-9907 in row 6 at position 9907
position(clob) NOT FOUND 6 searchStr test data: a string column inserted as an Ascii stream
Found clob (row 10)  in row 6 at position 1
position(clob) FOUND @ 1 with empty search clob in clob of length 10000
Found clob (row 12)  in row 6 at position 301
searchClob row 13 skipped (too large)
position(clob) NOT FOUND 7 searchStr horse
position(clob) NOT FOUND 7 searchStr ouch
position(clob) NOT FOUND 7 searchStr 
position(clob) FOUND @ 1 with empty search clob in clob of length 0
position(clob) NOT FOUND 7 searchStr Beginning
position(clob) NOT FOUND 7 searchStr position-69
position(clob) NOT FOUND 7 searchStr I-am-hiding-here-at-position-5910
position(clob) NOT FOUND 7 searchStr Position-9907
position(clob) NOT FOUND 7 searchStr test data: a string column inserted as an Ascii stream
position(clob) NOT FOUND 7 searchStr >150chars
position(clob) FOUND @ 1 with empty search clob in clob of length 0
position(clob) NOT FOUND 7 searchStr >150chars
searchClob row 13 skipped (too large)
position(clob) NOT FOUND 8 searchStr horse
position(clob) NOT FOUND 8 searchStr ouch
Found 
 in row 8 at position 100
position(clob) FOUND @ 1 with empty search clob in clob of length 5000
position(clob) NOT FOUND 8 searchStr Beginning
position(clob) NOT FOUND 8 searchStr position-69
position(clob) NOT FOUND 8 searchStr I-am-hiding-here-at-position-5910
position(clob) NOT FOUND 8 searchStr Position-9907
position(clob) NOT FOUND 8 searchStr test data: a string column inserted as an Ascii stream
position(clob) NOT FOUND 8 searchStr >150chars
position(clob) FOUND @ 1 with empty search clob in clob of length 5000
Found clob (row 12)  in row 8 at position 1
searchClob row 13 skipped (too large)
testCLOB_MAIN row 9 skipped (too large)
clobTest4 finished
START: clobTest42
Succeeded: Found clob at position 1,row 0
Succeeded: Found clob at position 1,row 1
Succeeded: Found clob at position 1,row 2
clobTest42 finished
START: clobTest51
clobTest51 finished
START: clobTest52
create table testInteger (a integer)
insert into testInteger values('158')
select a from testInteger
getClob(1)
52: SQLException
EXPECTED SQL Exception: Invalid data conversion: Wrong result column type for requested conversion.
START: clobTest53
clobTest53 finished
START: clobTest54
EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER.
end clobTest54
START: clobTest6
 negative tests for clob.getSubstring won't run  for network server  until 5243 is fixed
START: clobTest7
clobTest7 finished
START: clobTest8
small string pattern
@1  position MATCH(129)
@2  position MATCH(2074)
@3  position MATCH(4595)
@4  position MATCH(34584)
@5  position MATCH(67918)
@6  position MATCH(-1)
@7  position MATCH(-1)
@8  position MATCH(-1)
@9  position MATCH(-1)
@10  position MATCH(-1)
small java.sql.Clob pattern
@1  position MATCH(129)
@2  position MATCH(2074)
@3  position MATCH(4595)
@4  position MATCH(34584)
@5  position MATCH(67918)
@6  position MATCH(-1)
@7  position MATCH(-1)
@8  position MATCH(-1)
@9  position MATCH(-1)
@10  position MATCH(-1)
medium string pattern
@1  position MATCH(11253)
@2  position MATCH(12225)
@3  position MATCH(13478)
@4  position MATCH(43467)
@5  position MATCH(76801)
@6  position MATCH(-1)
@7  position MATCH(-1)
@8  position MATCH(-1)
@9  position MATCH(-1)
@10  position MATCH(-1)
medium java.sql.Clob pattern
@1  position MATCH(11253)
@2  position MATCH(12225)
@3  position MATCH(13478)
@4  position MATCH(43467)
@5  position MATCH(76801)
@6  position MATCH(-1)
@7  position MATCH(-1)
@8  position MATCH(-1)
@9  position MATCH(-1)
@10  position MATCH(-1)
long string pattern
@1  position MATCH(287875)
@2  position MATCH(288847)
@3  position MATCH(290108)
@4  position MATCH(305102)
@5  position MATCH(321769)
@6  position MATCH(-1)
@7  position MATCH(-1)
@8  position MATCH(-1)
@9  position MATCH(-1)
@10  position MATCH(-1)
long java.sql.Clob pattern
@1  position MATCH(287875)
@2  position MATCH(288847)
@3  position MATCH(290108)
@4  position MATCH(305102)
@5  position MATCH(321769)
@6  position MATCH(-1)
@7  position MATCH(-1)
@8  position MATCH(-1)
@9  position MATCH(-1)
@10  position MATCH(-1)
complete clobTest8
START: clobTest91
done row 0, length was 0
done row 1, length was 65
done row 2, length was 26
done row 3, length was 42
done row 4, length was 56
done row 5, length was 10000
done row 6, length was 0
done row 7, length was 5000
done row 8, length was 300000
row 9 is null, skipped
clobTest91 finished
START: clobTest92
clobTest92 finished
START: clobTest93
clobTest92 finished
START: clobTest94
shortClob length after commit is 26
clobTest94 finished