From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | lucvanlind(dot)en(at)gmail(dot)com |
Subject: | BUG #18239: select position ('' in 'A') returns 1 |
Date: | 2023-12-10 10:22:35 |
Message-ID: | 18239-50b7f8e43ec7be76@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18239
Logged by: Luc Van Linden
Email address: lucvanlind(dot)en(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | jian he | 2023-12-10 12:19:57 | Re: BUG #18238: Cross-partitition MERGE/UPDATE with delete-preventing trigger leads to incorrect memory access |
Previous Message | jian he | 2023-12-10 09:55:16 | Re: BUG #18238: Cross-partitition MERGE/UPDATE with delete-preventing trigger leads to incorrect memory access |