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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: andreas(dot)imboden(at)bl(dot)ch
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14394: No error raised in IN-clause when commas are missing
Date: 2016-10-24 14:44:21
Message-ID: 20161024144420.iuso6q32q2npgnkb@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Oct 24, 2016 at 02:28:41PM +0000, andreas(dot)imboden(at)bl(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-10-24 14:46:31 Re: BUG #14394: No error raised in IN-clause when commas are missing
Previous Message andreas.imboden 2016-10-24 14:28:41 BUG #14394: No error raised in IN-clause when commas are missing