SUBSTRING on long blobs truncates result to 32767 if third argument not present [CORE3245] #3615
Submitted by: @paulvink
Is related to QA285
If the third argument is not present, SUBSTRING should return from <startpos> to the end of the string.
But with long text blobs, it returns a maximum of 32767 characters, as the following query demonstrates:
with q (s) as (
The result is (98304, 'jkl', 90305, 'jkl', 32767, ' ').
Columns 5 and 6 should be the same as 3 and 4: 90305, 'jkl'.
The text was updated successfully, but these errors were encountered: