BUG #4742: wrong resultset instead of syntax error

Поиск
Список
Период
Сортировка
От Slava Moudry
Тема BUG #4742: wrong resultset instead of syntax error
Дата
Msg-id 200903310034.n2V0YnXX021770@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4742: wrong resultset instead of syntax error
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4742
Logged by:          Slava Moudry
Email address:      smoudry@4info.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;
               ^

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: shared_buffers/SHMMAX defaults?
Следующее
От: "MATSUDA, Daiki"
Дата:
Сообщение: BUG #4743: potential bug between int and uint