Re: BUG #14394: No error raised in IN-clause when commas are missing

On Mon, Oct 24, 2016 at 7:28 AM, <andreas.imboden@bl.ch> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      14394
> Logged by:          Andreas Imboden
> Email address:      andreas.imboden@bl.ch
> PostgreSQL version: 9.6.0
> Operating system:   Red Hat Entreprise Linux
> Description:
>
> /*
> pg-version:
> "PostgreSQL 9.6.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
> 201506
> (...)""
>
> bug description:
> in list with new line instead of comma produces incorrect result.
> should instead report a syntax error message
>
> */
> =E2=80=8B[...]=E2=80=8B
>
>     'two'
>     'three',
>

 =E2=80=8BWorking as designed
=E2=80=8B and mandated by the SQL standard.=E2=80=8B

The above resolve
=E2=80=8Bs=E2=80=8B
into
=E2=80=8Ba single string =E2=80=8B
"two
=E2=80=8Bthree=E2=80=8B
"
=E2=80=8B.

https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNT=
AX-CONSTANTS

David J.
=E2=80=8B
=E2=80=8B