Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: BUG #14394: No error raised in IN-clause when commas are missing
Date
Msg-id 20161024144420.iuso6q32q2npgnkb@depesz.com
Whole thread Raw
In response to BUG #14394: No error raised in IN-clause when commas are missing  (andreas.imboden@bl.ch)
List pgsql-bugs
Tree view 
On Mon, Oct 24, 2016 at 02:28:41PM +0000, andreas.imboden@bl.ch wrote:
> bug description:
> in list with new line instead of comma produces incorrect result.
> should instead report a syntax error message

This is not a bug.

Please check:
https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
Specifically part: 4.1.2.1. String Constants.

depesz

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14394: No error raised in IN-clause when commas are missing
Next
From: Erik Rijkers
Date:
Subject: Re: BUG #14394: No error raised in IN-clause when commas are missing