BUG #10201: Invalid input accepted with IN expression

Поиск
Список
Период
Сортировка
От dbaston@gmail.com
Тема BUG #10201: Invalid input accepted with IN expression
Дата
Msg-id 20140502200127.1403.20569@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #10201: Invalid input accepted with IN expression
Re: BUG #10201: Invalid input accepted with IN expression
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      10201
Logged by:          Daniel Baston
Email address:      dbaston@gmail.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)

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #10189: Limit in 9.3.4 no longer works when ordering using a composite multi-type index
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #10201: Invalid input accepted with IN expression