|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 1 for 2147483647) from rdb$database;
-- 'abcdef'
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 2 for 2147483647) from rdb$database;
-- ''
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 3 for 2147483647) from rdb$database;
-- 'cd'
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 3 for 2147483646) from rdb$database;
-- ''
i.e. the problem occurs when (offset + length) overflows the 32-bit signed value.
|
|
Description
|
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 1 for 2147483647) from rdb$database;
-- 'abcdef'
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 2 for 2147483647) from rdb$database;
-- ''
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 3 for 2147483647) from rdb$database;
-- 'cd'
select substring(cast('abcdef' as blob sub_type text character set utf8)
from 3 for 2147483646) from rdb$database;
-- ''
i.e. the problem occurs when (offset + length) overflows the 32-bit signed value. |
Show » |
| There are no comments yet on this issue.
|
|
Bug
Closed
Minor
Wrong results (internal wrapping occured) for the multi-byte blob SUBSTRING function and its boundary arguments
