BUG #10201: Invalid input accepted with IN expression

From: dbaston(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10201: Invalid input accepted with IN expression
Date: 2014-05-02 20:01:27
Message-ID: 20140502200127.1403.20569@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10201
Logged by: Daniel Baston
Email address: dbaston(at)gmail(dot)com
PostgreSQL version: 9.2.2
Operating system: Windows Server 2012
Description:

If two items in an IN expression are separated by a newline instead of a
comma, those items will be ignored with no error.

CREATE TABLE testing (id varchar(1));
INSERT INTO testing VALUES ('1'), ('2'), ('3'), ('4'), ('5');

-- Missing comma produces a syntax error
SELECT * FROM testing WHERE id IN ('1' '2', '3');

-- Unless there is a newline
SELECT * FROM testing WHERE id IN ('1'
'2', '3');

id
----
3
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2014-05-02 20:05:55 Re: BUG #10201: Invalid input accepted with IN expression
Previous Message Tom Lane 2014-05-02 19:08:30 Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index