streamingcolumn.out

来自「derby database source code.good for you.」· OUT 代码 · 共 137 行

Test streamingColumn starting
===> testing extin/short.data length = 56
No truncation and hence no error
===> testing extin/shortbanner length = 8282
No truncation and hence no error
===> testing extin/derby.banner length = 414000
expected exception for data > 32700 in length
===> testing extin/empty.data length = 0
No truncation and hence no error
===> verified length 56
===> verified length 8282
===> verified length 0
===> verified length 56
===> verified length 8282
===> verified length 0
===> verified length 56
===> verified length 8282
===> verified length 0
===> verified length 56
===> verified length 8282
===> verified length 0
expect to get null string back
a = -1 got null string back
a = -1 got null string back
===> testing extin/short.data length = 56
===> testing extin/shortbanner length = 8282
===> testing extin/derby.banner length = 414000
===> testing extin/empty.data length = 0
streamTest7
Starting streamTest8(conn, 10, 2500)
Finishing streamTest8(conn, 10, 2500)
Starting streamTest9(conn, 10, 2500)
Finishing streamTest9(conn, 10, 2500)
Starting streamTest8(conn, 2500, 10)
Finishing streamTest8(conn, 2500, 10)
Starting streamTest9(conn, 2500, 10)
Finishing streamTest9(conn, 2500, 10)
Testing 10 starts from here
===> testing extin/short.data length = 56
No truncation and hence no error
===> testing extin/shortbanner length = 8282
No truncation and hence no error
===> testing extin/derby.banner length = 414000
expected exception for data > 32700 in length
===> testing extin/empty.data length = 0
No truncation and hence no error
Testing 10 ends in here
Test 11 - Can't pass negative length as the stream length for various setXXXStream methods
===> testing using setAsciiStream with -2 as length
PASS -- expected exception:SQL Exception: Input stream cannot have negative length.
===> testing using setCharacterStream with -1 as length
PASS -- expected exception:SQL Exception: Input stream cannot have negative length.
===> testing using setBinaryStream with -1 as length
PASS -- expected exception:SQL Exception: Input stream cannot have negative length.
Test 11 - negative stream length tests end in here
Test 12 - varchar truncation tests start from here
===> testing(using setAsciiStream) extin/char32675trailingblanks.data length = 32675
No truncation and hence no error
===> testing(using setCharacterStream) extin/char32675trailingblanks.data length = 32675
No truncation and hence no error
===> testing trailing blanks(using setString) length = 32675
No truncation and hence no error
===> testing trailing blanks(using setObject) length = 32675
No truncation and hence no error
===> testing trailing blanks using concatenation
No truncation and hence no error.
===> testing(using setAsciiStream) extin/char32675.data length = 32675
expected exception for data > 32672 in length
===> testing(using setCharacterStream) extin/char32675.data length = 32675
expected exception for data > 32672 in length
===> testing trailing non-blanks(using setString) length = 32675
expected exception for data > 32672 in length
===> testing trailing non-blanks(using setObject) length = 32675
expected exception for data > 32672 in length
===> testing trailing non-blank characters using concatenation
expected exception for data > 32672 in length
===> verified length 32672
===> verified length 32672
===> verified length 32672
===> verified length 32672
===> verified length 32672
Test 12 - varchar truncation tests end in here
Test 13 - long varchar truncation tests start from here
===> testing(using setAsciiStream) extin/char32703trailingblanks.data length = 32703
expected exception for data > 32700 in length
===> testing(using setCharacterStream) extin/char32703trailingblanks.data length = 32703
expected exception for data > 32700 in length
===> testing trailing blanks(using setString) length = 32703
expected exception for data > 32700 in length
===> testing trailing blanks(using setObject) length = 32703
expected exception for data > 32700 in length
===> testing(using setAsciiStream) extin/char32703.data length = 32703
expected exception for data > 32700 in length
===> testing(using setCharacterStream) extin/char32703.data length = 32703
expected exception for data > 32700 in length
===> testing trailing non-blanks(using setString) length = 32703
expected exception for data > 32700 in length
===> testing trailing non-blanks(using setObject) length = 32703
expected exception for data > 32700 in length
Test 13 - long varchar truncation tests end in here
======================================
START  DERBY-500 TEST 
Inserting rows 
Rows inserted =10
Rows selected =10
Update qualifies many rows + streams
EXPECTED EXCEPTION - streams cannot be re-used
EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown
EXPECTED SQL Exception: (XJ001) Java exception: 'Stream has already been read and end-of-file reached and cannot be re-used.: java.io.EOFException'.
Rows selected =10
DERBY500 #2 Rows updated  =1
Rows selected =1
DERBY500 #3 Rows deleted =10
Rows selected =0
DERBY500 #4 Rows deleted  =0
Rows selected =0
EXPECTED EXCEPTION - streams cannot be re-used
EXPECTED SQL Exception: (XSDA4) An unexpected exception was thrown
EXPECTED SQL Exception: (XJ001) Java exception: 'Stream has already been read and end-of-file reached and cannot be re-used.: java.io.EOFException'.
END  DERBY-500 TEST 
======================================
======================================
START  DERBY-500 TEST for varchar 
Rows inserted =10
Rows selected =10
DERBY500 for varchar #1 Rows updated  =11
Rows selected =10
DERBY500 for varchar #2 Rows updated  =1
Rows selected =1
DERBY500 for varchar #3 Rows deleted =11
Rows selected =0
DERBY500 for varchar #4 Rows deleted  =0
Rows selected =0
END  DERBY-500 TEST  for varchar
======================================
Test streamingColumn finished