📄 concatetests.out
字号:
Test1 - CHAR, VARCHAR, LONGVARCHAR and CLOB concatenation testsTest1a - CHAR concatenations will give result type of CHAR when concatenated string < 255datatype of concatenated string is : CHARprecision of concatenated string is : 254Successful CHAR read of 254 charactersSuccessful CHAR read of 254 charactersTest1b boundary test - CHAR concatenations will give result type of VARCHAR when concatenated string = 255datatype of concatenated string is : VARCHARprecision of concatenated string is : 255Successful VARCHAR read of 255 charactersSuccessful VARCHAR read of 255 charactersTest1b - CHAR concatenations will give result type of VARCHAR when concatenated string > 254datatype of concatenated string is : VARCHARprecision of concatenated string is : 264Successful VARCHAR read of 264 charactersSuccessful VARCHAR read of 264 charactersTest1c - CHAR and VARCHAR concatenations will give result type of VARCHAR when concatenated string < 4001datatype of concatenated string is : VARCHARprecision of concatenated string is : 4000Successful VARCHAR read of 4000 charactersSuccessful VARCHAR read of 4000 charactersSuccessful LONG VARCHAR read of 4000 charactersTest1d - VARCHAR and CHAR concatenations will give result type of VARCHAR when concatenated string < 4001datatype of concatenated string is : VARCHARprecision of concatenated string is : 4000Successful VARCHAR read of 4000 charactersSuccessful VARCHAR read of 4000 charactersSuccessful LONG VARCHAR read of 4000 charactersTest1e boundary test - CHAR and VARCHAR concatenations will give result type of LONG VARCHAR when concatenated string = 4001datatype of concatenated string is : LONG VARCHARprecision of concatenated string is : 32700Successful LONG VARCHAR read of 4001 charactersSuccessful LONG VARCHAR read of 4001 charactersTest1f boundary test - VARCHAR and CHAR concatenations will give result type of LONG VARCHAR when concatenated string = 4001datatype of concatenated string is : LONG VARCHARprecision of concatenated string is : 32700Successful LONG VARCHAR read of 4001 charactersSuccessful LONG VARCHAR read of 4001 charactersTest1g - CHAR and LONG VARCHAR concatenations will give result type of LONG VARCHARdatatype of concatenated string is : LONG VARCHARprecision of concatenated string is : 32700Successful LONG VARCHAR read of 4002 charactersSuccessful LONG VARCHAR read of 4002 charactersTest1h - VARCHAR and LONG VARCHAR concatenations will give result type of LONG VARCHARdatatype of concatenated string is : LONG VARCHARprecision of concatenated string is : 32700Successful LONG VARCHAR read of 4266 charactersSuccessful LONG VARCHAR read of 4266 charactersTest1i - VARCHAR and VARCHAR concatenations will give result type of VARCHAR when concatenated string < 4001datatype of concatenated string is : VARCHARprecision of concatenated string is : 528Successful VARCHAR read of 528 charactersSuccessful LONG VARCHAR read of 528 charactersTest1j boundary test - VARCHAR and VARCHAR concatenations will give result type of LONG VARCHAR when concatenated string = 4001datatype of concatenated string is : LONG VARCHARprecision of concatenated string is : 32700Successful LONG VARCHAR read of 4001 charactersSuccessful LONG VARCHAR read of 4001 charactersTest1j - VARCHAR and VARCHAR concatenations will give result type of LONG VARCHAR when concatenated string > 4000datatype of concatenated string is : LONG VARCHARprecision of concatenated string is : 32700Successful LONG VARCHAR read of 4264 charactersSuccessful LONG VARCHAR read of 4264 charactersTest1k - LONG VARCHAR and LONG VARCHAR concatenations will give result type of LONG VARCHARdatatype of concatenated string is : LONG VARCHARprecision of concatenated string is : 32700Successful LONG VARCHAR read of 8528 charactersSuccessful LONG VARCHAR read of 8528 charactersTest1l - CHAR and LONGVARCHAR concatenation resulting in concatenated string > 32700 will give errorexpected exception The length resulting from CONCAT operation is greater than 32700.expected exception The length resulting from CONCAT operation is greater than 32700.Test1m - VARCHAR and LONGVARCHAR concatenation resulting in concatenated string > 32700 will give errorexpected exception The length resulting from CONCAT operation is greater than 32700.expected exception The length resulting from CONCAT operation is greater than 32700.Test1n - LONGVARCHAR and LONGVARCHAR concatenation resulting in concatenated string > 32700 will give errorexpected exception The length resulting from CONCAT operation is greater than 32700.expected exception The length resulting from CONCAT operation is greater than 32700.Test1o - CHAR(A) and CLOB(B) concatenations will give result type of CLOB(A+B) when A+B<2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 266Successful CLOB read of 37 charactersSuccessful CLOB read of 37 charactersTest1p - CLOB(A) and CHAR(B) concatenations will give result type of CLOB(A+B) when A+B<2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 266Successful CLOB read of 47 charactersSuccessful CLOB read of 47 charactersTest1q - CHAR(A) and CLOB(B) concatenations will give result type of CLOB(2G) when A+B>2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 2147483647Successful CLOB read of 25 charactersSuccessful CLOB read of 25 charactersTest1r - CLOB(A) and CHAR(B) concatenations will give result type of CLOB(2G) when A+B>2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 2147483647Successful CLOB read of 35 charactersSuccessful CLOB read of 35 charactersTest1s - VARCHAR(A) and CLOB(B) concatenations will give result type of CLOB(A+B) when A+B<2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 356Successful CLOB read of 62 charactersSuccessful CLOB read of 62 charactersTest1t - CLOB(A) and VARCHAR(B) concatenations will give result type of CLOB(A+B) when A+B<2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 356Successful CLOB read of 77 charactersSuccessful CLOB read of 77 charactersTest1u - VARCHAR(A) and CLOB(B) concatenations will give result type of CLOB(2G) when A+B>2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 2147483647Successful CLOB read of 50 charactersSuccessful CLOB read of 50 charactersTest1v - CLOB(A) and VARCHAR(B) concatenations will give result type of CLOB(2G) when A+B>2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 2147483647Successful CLOB read of 65 charactersSuccessful CLOB read of 65 charactersTest1w - LONG VARCHAR and CLOB(A) concatenations will give result type of CLOB(A+32K) when A+32K<2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 33024Successful CLOB read of 97 charactersSuccessful CLOB read of 97 charactersTest1x - CLOB(A) and LONG VARCHAR concatenations will give result type of CLOB(A+32K) when A+32K<2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 33024Successful CLOB read of 117 charactersSuccessful CLOB read of 117 charactersTest1y - LONG VARCHAR and CLOB(B) concatenations will give result type of CLOB(2G) when A+32K>2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 2147483647Successful CLOB read of 85 charactersSuccessful CLOB read of 85 charactersTest1z - CLOB(A) and LONG VARCHAR concatenations will give result type of CLOB(2G) when A+32K>2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 2147483647Successful CLOB read of 105 charactersSuccessful CLOB read of 105 charactersTest11a - CLOB(A) and CLOB(B) concatenations will give result type of CLOB(A+B) when A+B<2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 1048832Successful CLOB read of 132 charactersSuccessful CLOB read of 132 charactersTest11b - CLOB(A) and CLOB(B) concatenations will give result type of CLOB(2G) when A+B>2Gdatatype of concatenated string is : CLOBprecision of concatenated string is : 2147483647Successful CLOB read of 237 charactersSuccessful CLOB read of 237 charactersTest12 - try 2 empty string concatenation and verify that length comes back as 0 for the resultdatatype of concatenated string is : CHARprecision of concatenated string is : 0Successful CHAR read of 0 charactersTest13 - Prepared statement with CLOB(A) and ? concatenations will give result type of CLOB(A+length of ?) Prior to Derby-124 fix, ? parameter was getting bound to VARCHAR of length 32672 rather than CLOB. preapre statement with clob||?Successful CLOB read of 32702 characters Test - preapre statement with clob||cast(? to cLOB)Successful CLOB read of 32702 charactersTest1 finished - CHAR, VARCHAR, LONGVARCHAR and CLOB concatenation testsTest2 - CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, LONGVARCHAR FOR BIT DATA and BLOB concatenation testsTest2a - CHAR FOR BIT DATA concatenations will give result type of CHAR FOR BIT DATA when concatenated string < 255datatype of concatenated string is : CHAR () FOR BIT DATAprecision of concatenated string is : 254⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -