📄 concatetests.out
字号:
Successful CHAR () FOR BIT DATA read of 254 bytesSuccessful CHAR () FOR BIT DATA read of 254 bytesTest2b boundary test - CHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string = 255datatype of concatenated string is : VARCHAR () FOR BIT DATAprecision of concatenated string is : 255Successful VARCHAR () FOR BIT DATA read of 255 bytesSuccessful VARCHAR () FOR BIT DATA read of 255 bytesTest2b - CHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string > 254datatype of concatenated string is : VARCHAR () FOR BIT DATAprecision of concatenated string is : 264Successful VARCHAR () FOR BIT DATA read of 264 bytesSuccessful VARCHAR () FOR BIT DATA read of 264 bytesTest2c - CHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string < 4001datatype of concatenated string is : VARCHAR () FOR BIT DATAprecision of concatenated string is : 4000Successful VARCHAR () FOR BIT DATA read of 4000 bytesSuccessful VARCHAR () FOR BIT DATA read of 4000 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4000 bytesTest2d - VARCHAR FOR BIT DATA and CHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string < 4001datatype of concatenated string is : VARCHAR () FOR BIT DATAprecision of concatenated string is : 4000Successful VARCHAR () FOR BIT DATA read of 4000 bytesSuccessful VARCHAR () FOR BIT DATA read of 4000 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4000 bytesTest2e boundary test - CHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA when concatenated string > 4000datatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 4001 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4001 bytesTest2f boundary test - VARCHAR FOR BIT DATA and CHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA when concatenated string > 4000datatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 4001 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4001 bytesTest2g - CHAR FOR BIT DATA and LONG VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATAdatatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 4002 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4002 bytesTest2h - VARCHAR FOR BIT DATA and LONG VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATAdatatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 4266 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4266 bytesTest2i - VARCHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string < 4001datatype of concatenated string is : VARCHAR () FOR BIT DATAprecision of concatenated string is : 528Successful VARCHAR () FOR BIT DATA read of 528 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 528 bytesTest2j boundary test - VARCHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA when concatenated string = 4001datatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 4001 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4001 bytesTest2j - VARCHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA when concatenated string > 4000datatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 4264 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 4264 bytesTest2k - LONG VARCHAR FOR BIT DATA and LONG VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATAdatatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 8528 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 8528 bytesTest2l - CHAR FOR BIT DATA and LONGVARCHAR FOR BIT DATA concatenation resulting in concatenated string > 32700datatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 32738 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 32738 bytesTest2m - VARCHAR FOR BIT DATA and LONGVARCHAR FOR BIT DATA concatenation resulting in concatenated string > 32700datatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 33002 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 33002 bytesTest2n - LONGVARCHAR FOR BIT DATA and LONGVARCHAR FOR BIT DATA concatenation resulting in concatenated string > 32700datatype of concatenated string is : LONG VARCHAR FOR BIT DATAprecision of concatenated string is : 32700Successful LONG VARCHAR FOR BIT DATA read of 41530 bytesSuccessful LONG VARCHAR FOR BIT DATA read of 41530 bytesTest2o - CHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(A+B) when A+B<2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 266Successful BLOB read of 20 bytesSuccessful BLOB read of 20 bytesTest2p - BLOB(A) and CHAR(B) FOR BIT DATA concatenations will give result type of BLOB(A+B) when A+B<2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 266Successful BLOB read of 30 bytesSuccessful BLOB read of 30 bytesTest2q - CHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(2G) when A+B>2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 2147483647Successful BLOB read of 20 bytesSuccessful BLOB read of 20 bytesTest2r - BLOB(A) and CHAR(B) FOR BIT DATA concatenations will give result type of BLOB(2G) when A+B>2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 2147483647Successful BLOB read of 30 bytesSuccessful BLOB read of 30 bytesTest2s - VARCHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(A+B) when A+B<2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 356Successful BLOB read of 40 bytesSuccessful BLOB read of 40 bytesTest2t - BLOB(A) and VARCHAR(B) FOR BIT DATA concatenations will give result type of BLOB(A+B) when A+B<2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 356Successful BLOB read of 50 bytesSuccessful BLOB read of 50 bytesTest2u - VARCHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(2G) when A+B>2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 2147483647Successful BLOB read of 40 bytesSuccessful BLOB read of 40 bytesTest2v - BLOB(A) and VARCHAR(B) FOR BIT DATA concatenations will give result type of BLOB(2G) when A+B>2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 2147483647Successful BLOB read of 50 bytesSuccessful BLOB read of 50 bytesTest2w - LONG VARCHAR FOR BIT DATA and BLOB(A) concatenations will give result type of BLOB(A+32K) when A+32K<2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 33024Successful BLOB read of 60 bytesSuccessful BLOB read of 60 bytesTest2x - BLOB(A) and LONG VARCHAR FOR BIT DATA concatenations will give result type of BLOB(A+32K) when A+32K<2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 33024Successful BLOB read of 70 bytesSuccessful BLOB read of 70 bytesTest2y - LONG VARCHAR FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(2G) when A+32K>2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 2147483647Successful BLOB read of 60 bytesSuccessful BLOB read of 60 bytesTest2z - BLOB(A) and LONG VARCHAR FOR BIT DATA concatenations will give result type of BLOB(2G) when A+32K>2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 2147483647Successful BLOB read of 70 bytesSuccessful BLOB read of 70 bytesTest21a - BLOB(A) and BLOB(B) concatenations will give result type of BLOB(A+B) when A+B<2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 1048832Successful BLOB read of 80 bytesSuccessful BLOB read of 80 bytesTest21b - BLOB(A) and BLOB(B) concatenations will give result type of BLOB(2G) when A+B>2Gdatatype of concatenated string is : BLOBprecision of concatenated string is : 2147483647Successful BLOB read of 150 bytesSuccessful BLOB read of 150 bytesTest22 - try 2 empty char for bit data concatenation and verify that length comes back as 0 for the resultdatatype of concatenated string is : CHAR () FOR BIT DATAprecision of concatenated string is : 0Test23 - Derby-124 try concatenation in a prepared statement with one operand casted to BLOB and other as ? parameter Prior to Derby-124 fix, ? parameter was getting bound to VARCHAR TO BIT DATA of length 32672 rather than BLOB. That caused truncation exception when ? parameter was set to > 32672 bytes preapre statement with blob||?Successful BLOB read of 32702 bytes Test - preapre statement with blob||cast(? to BLOB)Successful BLOB read of 32702 bytesTest2 finished - CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, LONGVARCHAR FOR BIT DATA and BLOB concatenation tests⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -