IN List operator , where list of values are over a number of lines

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

Responses

Browse pgsql-bugs by date

  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