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
- IN List operator , where list of values are over a number of lines.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document)
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