-- If no third argument (length) is provided, the length to the end of the
-- string is assumed.
SELECT substr(f1, 99995) from toasttest;
! ERROR: Could not begin transaction on data nodes.
-- If start plus length is > string length, the result is truncated to
-- string length
SELECT substr(f1, 99995, 10) from toasttest;
! ERROR: Unexpected response from the data nodes for 'T' message, current request type 1
! ERROR: Unexpected response from the data nodes, result = 2, request type 2
DROP TABLE toasttest;
+ ERROR: Could not begin transaction on data nodes
--
-- test substr with toasted bytea value
Need continuous regression test to run without dropping the database. The test is assigned to Taka and will determine who to assign after we find concrete way to reproduce the problem.
This has been fixed since COPY BINARY correction is in, so close it.
Coupled with bug 3518449 also.