BUG #14883: Syntax SQL error (42601), but should be a different error no

From: stefan(dot)hanenberg(at)googlemail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Cc: stefan(dot)hanenberg(at)googlemail(dot)com
Subject: BUG #14883: Syntax SQL error (42601), but should be a different error no
Date: 2017-10-31 00:36:01
Message-ID: 20171031003601.17181.3817@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: 14883
Logged by: Stefan Hanenberg
Email address: stefan(dot)hanenberg(at)googlemail(dot)com
PostgreSQL version: 10.0
Operating system: Windows 10/64
Description:

I am not 100% sure whether this is really a bug, I report it anyway.

The following SQL statement leads to an error 42601 (syntax error), although
the error is not a syntax error.

create table t1 (a integer,b integer);
create table t2 (a integer,b integer,c integer);
select * from t1 union select * from t2;

We are currently running automated tests on hundreds of thousands SQL in
order to check, what kind of errors they contain. It is really problematic
for us that the error is a 42601 error, although it seems rather as if it is
a type error.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2017-10-31 01:35:17 Re: BUG #14883: Syntax SQL error (42601), but should be a different error no
Previous Message Gavin Flower 2017-10-31 00:35:13 Re: BUG #14882: pgadmin 4