IN List operator , where list of values are over a number of lines - Mailing list 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

First query  errors as expected , Second executes with out error! Returning A & F . 

Details of server .

Attached is the sql that I ran

Please investigate

Many Thanks Ian White

Member British Computer Society

Oracle & Postgres Database Administrator & Perfomance Expert.

Based London

Ian.White@ncratleos.com