BUG #14748: Invalid statement should raise parse error, but ignores invalid part instead

From: johnthuss(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: johnthuss(at)gmail(dot)com
Subject: BUG #14748: Invalid statement should raise parse error, but ignores invalid part instead
Date: 2017-07-17 14:51:26
Message-ID: 20170717145126.9231.80296@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14748
Logged by: John Huss
Email address: johnthuss(at)gmail(dot)com
PostgreSQL version: 9.6.1
Operating system: Linux
Description:

This statement is invalid because the 'AND' should be a WHERE or a comma:

update mytable set active = false and foreign_ID = 18984

But when executed it doesn't raise a parse error and simply ignores the
'and' and everything after it.

The result of the statement is that every row in the table is updated with
active=false.

I would expect this to throw a parse error.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2017-07-17 14:58:11 Re: BUG #14748: Invalid statement should raise parse error, but ignores invalid part instead
Previous Message durgas009 2017-07-17 07:20:15 BUG #14747: Postgres installation failing as non-root user