Skip site navigation (1) Skip section navigation (2)

BUG #4742: wrong resultset instead of syntax error

From: "Slava Moudry" <smoudry(at)4info(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4742: wrong resultset instead of syntax error
Date: 2009-03-31 00:34:49
Message-ID: 200903310034.n2V0YnXX021770@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4742
Logged by:          Slava Moudry
Email address:      smoudry(at)4info(dot)net
PostgreSQL version: 8.3.0
Operating system:   linux
Description:        wrong resultset instead of syntax error
Details: 

I believe this is a parser error, it should fail rather than return all rows
from keyword since there is no keyword_id in carrier table. The same can be
illustrated with any other tables:

smslocate_edw=# select count(*) from keyword where keyword_id in (select
keyword_id from carrier)   
smslocate_edw-# ;
 count 
-------
 35749
(1 row)

smslocate_edw=# select keyword_id from carrier;                             
                     
ERROR:  column "keyword_id" does not exist
LINE 1: select keyword_id from carrier;
               ^

Responses

pgsql-bugs by date

Next:From: MATSUDA, DaikiDate: 2009-03-31 05:57:28
Subject: BUG #4743: potential bug between int and uint
Previous:From: Tom LaneDate: 2009-03-31 00:29:37
Subject: Re: shared_buffers/SHMMAX defaults?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group