BUG #18239: select position ('' in 'A') returns 1

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18239: select position ('' in 'A') returns 1
Дата
Msg-id 18239-50b7f8e43ec7be76@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18239: select position ('' in 'A') returns 1  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      18239
Logged by:          Luc Van Linden
Email address:      lucvanlind.en@gmail.com
PostgreSQL version: 15.3
Operating system:   windows 10 64 bit
Description:

We simplified the bug, or maybe undocumented behavior to its simplest
testcase.

select position ('' in 'A') returns 1

Thus, case a field has an empty string while, checking positions in another
string, it seems to always fit the position 1.

Not sure if this is intended or not, at least we experience this as a bug.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: jian he
Дата:
Сообщение: Re: BUG #18238: Cross-partitition MERGE/UPDATE with delete-preventing trigger leads to incorrect memory access
Следующее
От: jian he
Дата:
Сообщение: Re: BUG #18238: Cross-partitition MERGE/UPDATE with delete-preventing trigger leads to incorrect memory access