BUG #16804: substring() function returns "negative substring length" error when using a large length argument
От
PG Bug reporting form
Тема
BUG #16804: substring() function returns "negative substring length" error when using a large length argument
Дата
Msg-id
16804-f4eeeb6c11ba71d4@postgresql.org
Список
Дерево обсуждения
BUG #16804: substring() function returns "negative substring length" error when using a large length argument PG Bug reporting form <noreply@postgresql.org>
Re: BUG #16804: substring() function returns "negative substring length" error when using a large length argument Pavel Stehule <pavel.stehule@gmail.com>
Re: BUG #16804: substring() function returns "negative substring length" error when using a large length argument Jerry Sievert <jerry@legitimatesounding.com>
Re: BUG #16804: substring() function returns "negative substring length" error when using a large length argument Pavel Stehule <pavel.stehule@gmail.com>
Re: BUG #16804: substring() function returns "negative substring length" error when using a large length argument Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16804: substring() function returns "negative substring length" error when using a large length argument Rafi Shamim <rafiss@gmail.com>
Re: BUG #16804: substring() function returns "negative substring length" error when using a large length argument Tom Lane <tgl@sss.pgh.pa.us>
The following bug has been logged on the website:
Bug reference: 16804
Logged by: Rafi Shamim
Email address: rafiss@gmail.com
PostgreSQL version: 13.1
Operating system: MacOS 10.15.7
Description:
Reproduction steps:
1. Connect to any PostgreSQL database.
2. Run this query:
> select substring('string' from 2 for 2147483646);
Actual result:
2021-01-04 12:43:13.145 EST [85734] ERROR: negative substring length not
allowed
2021-01-04 12:43:13.145 EST [85734] STATEMENT: select substring('string'
from 2 for 2147483646)
negative substring length not allowed
Expected result:
I don't know if this is covered by these docs:
https://www.postgresql.org/docs/13/functions-string.html
But I would expect one of the following:
1. There should be no error message, and the result should be 'tring'.
(Meaning it just goes to the end of the string.)
2. An error message that says that the length argument is too long.
I don't know what the SQL standard says, but when I try similar queries with
SQLite and MSSQL, the result is 'tring'.
В списке pgsql-bugs по дате отправления
От: PG Bug reporting form
Дата:
От: Alexander Lakhin
Дата: