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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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;
^
From | Date | Subject | |
---|---|---|---|
Next Message | MATSUDA, Daiki | 2009-03-31 05:57:28 | BUG #4743: potential bug between int and uint |
Previous Message | Tom Lane | 2009-03-31 00:29:37 | Re: shared_buffers/SHMMAX defaults? |