IN clause behaving badly with missing comma and line break

Поиск
Список
Период
Сортировка
От Roman Cervenak
Тема IN clause behaving badly with missing comma and line break
Дата
Msg-id CAGjExY3rn0YEYnCiRkJ+R9czsmz6Fa4xkYaOaY35x6B-UC_53A@mail.gmail.com
обсуждение исходный текст
Ответы Re: IN clause behaving badly with missing comma and line break
Re: IN clause behaving badly with missing comma and line break
Список pgsql-bugs
Hello,
if you use IN() clause (I've tested in WHERE and CASE) and you forget comma between values, it is syntax error (correct behaviour). But if there is newline between those two values, suddenly it is not syntax error (query will run successfully), and all values are simply ignored. 

Examples:

WITH sample AS (SELECT 'c' AS t) SELECT CASE WHEN t IN ('a','b') THEN 1 WHEN t IN ('c'
  'd') THEN 2 END FROM sample;

WITH sample AS (SELECT 'c' AS t)
SELECT * FROM sample WHERE t IN ('a'
'c');

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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: DROP DATABASE deadlocks with logical replication worker in PG 15.1
Следующее
От: David Rowley
Дата:
Сообщение: Re: IN clause behaving badly with missing comma and line break