Re: BUG #4247: (Possible) SQL miscontruct not flagged - Mailing list pgsql-bugs

"J6M" <j6m@adm.estp.fr> writes:
> PostgreSQL version: 8.1.13

> I wrote :

> select distinct(ean13),(select count(*) into zz from fiart where
> ean13=a.ean13) as n from fiart as a ;

> I am not an expert in the most intricate shades of the SQL language. Should
> the SQL interpreter not flag the query as a misconstruct statement and fire
> an ERROR (or at least a WARNING) message ? (I'd guess it should).

8.2 and up do complain about this:

regression=# create table fiart (ean13 int);
CREATE TABLE
regression=# select distinct(ean13),(select count(*) into zz from fiart where ean13=a.ean13) as n from fiart as a ;
ERROR:  bad query in sub-select

            regards, tom lane