From: | "White, Ian Keith" <Ian(dot)White(at)ncratleos(dot)com> |
---|---|
To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | IN List operator , where list of values are over a number of lines |
Date: | 2025-10-01 15:12:22 |
Message-ID: | BLAPR05MB732983A314F87764704DB5E4E5E6A@BLAPR05MB7329.namprd05.prod.outlook.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi
We have noticed a quirk in the IN list operator where the list of values are over several lines , but some have missing comma separators.
The command should fail, however it executes only returning certain values.
Create table, insert vales, show values , select using IN List
[cid:image001(dot)png(at)01DC32EB(dot)03FF0420]
First query errors as expected , Second executes with out error! Returning A & F .
[cid:image002(dot)png(at)01DC32EC(dot)6DCD8B50]
Details of server .
[cid:image004(dot)png(at)01DC32EC(dot)D2ED7400]
Attached is the sql that I ran
Please investigate
Many Thanks Ian White
Member British Computer Society
[ncr corporation]
Oracle & Postgres Database Administrator & Perfomance Expert.
Based London
Ian(dot)White(at)ncratleos(dot)com
Attachment | Content-Type | Size |
---|---|---|
IN List operator , where list of values are over a number of lines.docx | application/vnd.openxmlformats-officedocument.wordprocessingml.document | 15.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Oommen Anish | 2025-10-01 15:55:53 | [Bug] Usage of stale dead_items pointer in parallel vacuum |
Previous Message | Etsuro Fujita | 2025-10-01 10:53:51 | Re: TRAP: failed Assert("outerPlan != NULL") in postgres_fdw.c |