| Test1 - CHAR, VARCHAR, LONGVARCHAR and CLOB concatenation tests |
| Test1a - CHAR concatenations will give result type of CHAR when concatenated string < 255 |
| datatype of concatenated string is : CHAR |
| precision of concatenated string is : 254 |
| Successful CHAR read of 254 characters |
| Successful CHAR read of 254 characters |
| Test1b boundary test - CHAR concatenations will give result type of VARCHAR when concatenated string = 255 |
| datatype of concatenated string is : VARCHAR |
| precision of concatenated string is : 255 |
| Successful VARCHAR read of 255 characters |
| Successful VARCHAR read of 255 characters |
| Test1b - CHAR concatenations will give result type of VARCHAR when concatenated string > 254 |
| datatype of concatenated string is : VARCHAR |
| precision of concatenated string is : 264 |
| Successful VARCHAR read of 264 characters |
| Successful VARCHAR read of 264 characters |
| Test1c - CHAR and VARCHAR concatenations will give result type of VARCHAR when concatenated string < 4001 |
| datatype of concatenated string is : VARCHAR |
| precision of concatenated string is : 4000 |
| Successful VARCHAR read of 4000 characters |
| Successful VARCHAR read of 4000 characters |
| Successful LONG VARCHAR read of 4000 characters |
| Test1d - VARCHAR and CHAR concatenations will give result type of VARCHAR when concatenated string < 4001 |
| datatype of concatenated string is : VARCHAR |
| precision of concatenated string is : 4000 |
| Successful VARCHAR read of 4000 characters |
| Successful VARCHAR read of 4000 characters |
| Successful LONG VARCHAR read of 4000 characters |
| Test1e boundary test - CHAR and VARCHAR concatenations will give result type of LONG VARCHAR when concatenated string = 4001 |
| datatype of concatenated string is : LONG VARCHAR |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR read of 4001 characters |
| Successful LONG VARCHAR read of 4001 characters |
| Test1f boundary test - VARCHAR and CHAR concatenations will give result type of LONG VARCHAR when concatenated string = 4001 |
| datatype of concatenated string is : LONG VARCHAR |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR read of 4001 characters |
| Successful LONG VARCHAR read of 4001 characters |
| Test1g - CHAR and LONG VARCHAR concatenations will give result type of LONG VARCHAR |
| datatype of concatenated string is : LONG VARCHAR |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR read of 4002 characters |
| Successful LONG VARCHAR read of 4002 characters |
| Test1h - VARCHAR and LONG VARCHAR concatenations will give result type of LONG VARCHAR |
| datatype of concatenated string is : LONG VARCHAR |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR read of 4266 characters |
| Successful LONG VARCHAR read of 4266 characters |
| Test1i - VARCHAR and VARCHAR concatenations will give result type of VARCHAR when concatenated string < 4001 |
| datatype of concatenated string is : VARCHAR |
| precision of concatenated string is : 528 |
| Successful VARCHAR read of 528 characters |
| Successful LONG VARCHAR read of 528 characters |
| Test1j boundary test - VARCHAR and VARCHAR concatenations will give result type of LONG VARCHAR when concatenated string = 4001 |
| datatype of concatenated string is : LONG VARCHAR |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR read of 4001 characters |
| Successful LONG VARCHAR read of 4001 characters |
| Test1j - VARCHAR and VARCHAR concatenations will give result type of LONG VARCHAR when concatenated string > 4000 |
| datatype of concatenated string is : LONG VARCHAR |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR read of 4264 characters |
| Successful LONG VARCHAR read of 4264 characters |
| Test1k - LONG VARCHAR and LONG VARCHAR concatenations will give result type of LONG VARCHAR |
| datatype of concatenated string is : LONG VARCHAR |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR read of 8528 characters |
| Successful LONG VARCHAR read of 8528 characters |
| Test1l - CHAR and LONGVARCHAR concatenation resulting in concatenated string > 32700 will give error |
| expected 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 error |
| expected 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 error |
| expected 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<2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 266 |
| Successful CLOB read of 37 characters |
| Successful CLOB read of 37 characters |
| Test1p - CLOB(A) and CHAR(B) concatenations will give result type of CLOB(A+B) when A+B<2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 266 |
| Successful CLOB read of 47 characters |
| Successful CLOB read of 47 characters |
| Test1q - CHAR(A) and CLOB(B) concatenations will give result type of CLOB(2G) when A+B>2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 2147483647 |
| Successful CLOB read of 25 characters |
| Successful CLOB read of 25 characters |
| Test1r - CLOB(A) and CHAR(B) concatenations will give result type of CLOB(2G) when A+B>2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 2147483647 |
| Successful CLOB read of 35 characters |
| Successful CLOB read of 35 characters |
| Test1s - VARCHAR(A) and CLOB(B) concatenations will give result type of CLOB(A+B) when A+B<2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 356 |
| Successful CLOB read of 62 characters |
| Successful CLOB read of 62 characters |
| Test1t - CLOB(A) and VARCHAR(B) concatenations will give result type of CLOB(A+B) when A+B<2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 356 |
| Successful CLOB read of 77 characters |
| Successful CLOB read of 77 characters |
| Test1u - VARCHAR(A) and CLOB(B) concatenations will give result type of CLOB(2G) when A+B>2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 2147483647 |
| Successful CLOB read of 50 characters |
| Successful CLOB read of 50 characters |
| Test1v - CLOB(A) and VARCHAR(B) concatenations will give result type of CLOB(2G) when A+B>2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 2147483647 |
| Successful CLOB read of 65 characters |
| Successful CLOB read of 65 characters |
| Test1w - LONG VARCHAR and CLOB(A) concatenations will give result type of CLOB(A+32K) when A+32K<2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 33024 |
| Successful CLOB read of 97 characters |
| Successful CLOB read of 97 characters |
| Test1x - CLOB(A) and LONG VARCHAR concatenations will give result type of CLOB(A+32K) when A+32K<2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 33024 |
| Successful CLOB read of 117 characters |
| Successful CLOB read of 117 characters |
| Test1y - LONG VARCHAR and CLOB(B) concatenations will give result type of CLOB(2G) when A+32K>2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 2147483647 |
| Successful CLOB read of 85 characters |
| Successful CLOB read of 85 characters |
| Test1z - CLOB(A) and LONG VARCHAR concatenations will give result type of CLOB(2G) when A+32K>2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 2147483647 |
| Successful CLOB read of 105 characters |
| Successful CLOB read of 105 characters |
| Test11a - CLOB(A) and CLOB(B) concatenations will give result type of CLOB(A+B) when A+B<2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 1048832 |
| Successful CLOB read of 132 characters |
| Successful CLOB read of 132 characters |
| Test11b - CLOB(A) and CLOB(B) concatenations will give result type of CLOB(2G) when A+B>2G |
| datatype of concatenated string is : CLOB |
| precision of concatenated string is : 2147483647 |
| Successful CLOB read of 237 characters |
| Successful CLOB read of 237 characters |
| Test12 - try 2 empty string concatenation and verify that length comes back as 0 for the result |
| datatype of concatenated string is : CHAR |
| precision of concatenated string is : 0 |
| Successful CHAR read of 0 characters |
| Test13 - 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 characters |
| Test1 finished - CHAR, VARCHAR, LONGVARCHAR and CLOB concatenation tests |
| Test2 - CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, LONGVARCHAR FOR BIT DATA and BLOB concatenation tests |
| Test2a - CHAR FOR BIT DATA concatenations will give result type of CHAR FOR BIT DATA when concatenated string < 255 |
| datatype of concatenated string is : CHAR () FOR BIT DATA |
| precision of concatenated string is : 254 |
| Successful CHAR () FOR BIT DATA read of 254 bytes |
| Successful CHAR () FOR BIT DATA read of 254 bytes |
| Test2b boundary test - CHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string = 255 |
| datatype of concatenated string is : VARCHAR () FOR BIT DATA |
| precision of concatenated string is : 255 |
| Successful VARCHAR () FOR BIT DATA read of 255 bytes |
| Successful VARCHAR () FOR BIT DATA read of 255 bytes |
| Test2b - CHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string > 254 |
| datatype of concatenated string is : VARCHAR () FOR BIT DATA |
| precision of concatenated string is : 264 |
| Successful VARCHAR () FOR BIT DATA read of 264 bytes |
| Successful VARCHAR () FOR BIT DATA read of 264 bytes |
| Test2c - CHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string < 4001 |
| datatype of concatenated string is : VARCHAR () FOR BIT DATA |
| precision of concatenated string is : 4000 |
| Successful VARCHAR () FOR BIT DATA read of 4000 bytes |
| Successful VARCHAR () FOR BIT DATA read of 4000 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4000 bytes |
| Test2d - VARCHAR FOR BIT DATA and CHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string < 4001 |
| datatype of concatenated string is : VARCHAR () FOR BIT DATA |
| precision of concatenated string is : 4000 |
| Successful VARCHAR () FOR BIT DATA read of 4000 bytes |
| Successful VARCHAR () FOR BIT DATA read of 4000 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4000 bytes |
| Test2e 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 > 4000 |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 4001 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4001 bytes |
| Test2f 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 > 4000 |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 4001 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4001 bytes |
| Test2g - CHAR FOR BIT DATA and LONG VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 4002 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4002 bytes |
| Test2h - VARCHAR FOR BIT DATA and LONG VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 4266 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4266 bytes |
| Test2i - VARCHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of VARCHAR FOR BIT DATA when concatenated string < 4001 |
| datatype of concatenated string is : VARCHAR () FOR BIT DATA |
| precision of concatenated string is : 528 |
| Successful VARCHAR () FOR BIT DATA read of 528 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 528 bytes |
| Test2j 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 = 4001 |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 4001 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4001 bytes |
| Test2j - VARCHAR FOR BIT DATA and VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA when concatenated string > 4000 |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 4264 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 4264 bytes |
| Test2k - LONG VARCHAR FOR BIT DATA and LONG VARCHAR FOR BIT DATA concatenations will give result type of LONG VARCHAR FOR BIT DATA |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 8528 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 8528 bytes |
| Test2l - CHAR FOR BIT DATA and LONGVARCHAR FOR BIT DATA concatenation resulting in concatenated string > 32700 |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 32738 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 32738 bytes |
| Test2m - VARCHAR FOR BIT DATA and LONGVARCHAR FOR BIT DATA concatenation resulting in concatenated string > 32700 |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 33002 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 33002 bytes |
| Test2n - LONGVARCHAR FOR BIT DATA and LONGVARCHAR FOR BIT DATA concatenation resulting in concatenated string > 32700 |
| datatype of concatenated string is : LONG VARCHAR FOR BIT DATA |
| precision of concatenated string is : 32700 |
| Successful LONG VARCHAR FOR BIT DATA read of 41530 bytes |
| Successful LONG VARCHAR FOR BIT DATA read of 41530 bytes |
| Test2o - CHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(A+B) when A+B<2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 266 |
| Successful BLOB read of 20 bytes |
| Successful BLOB read of 20 bytes |
| Test2p - BLOB(A) and CHAR(B) FOR BIT DATA concatenations will give result type of BLOB(A+B) when A+B<2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 266 |
| Successful BLOB read of 30 bytes |
| Successful BLOB read of 30 bytes |
| Test2q - CHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(2G) when A+B>2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 2147483647 |
| Successful BLOB read of 20 bytes |
| Successful BLOB read of 20 bytes |
| Test2r - BLOB(A) and CHAR(B) FOR BIT DATA concatenations will give result type of BLOB(2G) when A+B>2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 2147483647 |
| Successful BLOB read of 30 bytes |
| Successful BLOB read of 30 bytes |
| Test2s - VARCHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(A+B) when A+B<2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 356 |
| Successful BLOB read of 40 bytes |
| Successful BLOB read of 40 bytes |
| Test2t - BLOB(A) and VARCHAR(B) FOR BIT DATA concatenations will give result type of BLOB(A+B) when A+B<2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 356 |
| Successful BLOB read of 50 bytes |
| Successful BLOB read of 50 bytes |
| Test2u - VARCHAR(A) FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(2G) when A+B>2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 2147483647 |
| Successful BLOB read of 40 bytes |
| Successful BLOB read of 40 bytes |
| Test2v - BLOB(A) and VARCHAR(B) FOR BIT DATA concatenations will give result type of BLOB(2G) when A+B>2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 2147483647 |
| Successful BLOB read of 50 bytes |
| Successful BLOB read of 50 bytes |
| Test2w - LONG VARCHAR FOR BIT DATA and BLOB(A) concatenations will give result type of BLOB(A+32K) when A+32K<2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 33024 |
| Successful BLOB read of 60 bytes |
| Successful BLOB read of 60 bytes |
| Test2x - BLOB(A) and LONG VARCHAR FOR BIT DATA concatenations will give result type of BLOB(A+32K) when A+32K<2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 33024 |
| Successful BLOB read of 70 bytes |
| Successful BLOB read of 70 bytes |
| Test2y - LONG VARCHAR FOR BIT DATA and BLOB(B) concatenations will give result type of BLOB(2G) when A+32K>2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 2147483647 |
| Successful BLOB read of 60 bytes |
| Successful BLOB read of 60 bytes |
| Test2z - BLOB(A) and LONG VARCHAR FOR BIT DATA concatenations will give result type of BLOB(2G) when A+32K>2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 2147483647 |
| Successful BLOB read of 70 bytes |
| Successful BLOB read of 70 bytes |
| Test21a - BLOB(A) and BLOB(B) concatenations will give result type of BLOB(A+B) when A+B<2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 1048832 |
| Successful BLOB read of 80 bytes |
| Successful BLOB read of 80 bytes |
| Test21b - BLOB(A) and BLOB(B) concatenations will give result type of BLOB(2G) when A+B>2G |
| datatype of concatenated string is : BLOB |
| precision of concatenated string is : 2147483647 |
| Successful BLOB read of 150 bytes |
| Successful BLOB read of 150 bytes |
| Test22 - try 2 empty char for bit data concatenation and verify that length comes back as 0 for the result |
| datatype of concatenated string is : CHAR () FOR BIT DATA |
| precision of concatenated string is : 0 |
| Test23 - 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 bytes |
| Test2 finished - CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, LONGVARCHAR FOR BIT DATA and BLOB concatenation tests |