[BUGS] BUG #14883: Syntax SQL error (42601),but should be a different error no - Mailing list pgsql-bugs

From stefan.hanenberg@googlemail.com
Subject [BUGS] BUG #14883: Syntax SQL error (42601),but should be a different error no
Date
Msg-id 20171031003601.17181.3817@wrigleys.postgresql.org
Whole thread Raw
Responses Re: [BUGS] BUG #14883: Syntax SQL error (42601), but should be adifferent error no
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14883
Logged by:          Stefan Hanenberg
Email address:      stefan.hanenberg@googlemail.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.




--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Gavin Flower
Date:
Subject: Re: [BUGS] BUG #14882: pgadmin 4
Next
From: David Rowley
Date:
Subject: Re: [BUGS] BUG #14883: Syntax SQL error (42601), but should be adifferent error no