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

White, Ian Keith <ian.white@ncratleos.com>

From: "White, Ian Keith" <Ian.White@ncratleos.com>
To: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-10-01T15:12:22Z
Lists: pgsql-bugs

Attachments

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.png@01DC32EB.03FF0420]

First query  errors as expected , Second executes with out error! Returning A & F .
[cid:image002.png@01DC32EC.6DCD8B50]

Details of server .
[cid:image004.png@01DC32EC.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.White@ncratleos.com