BUG #4247: (Possible) SQL miscontruct not flagged

Поиск
Список
Период
Сортировка
От J6M
Тема BUG #4247: (Possible) SQL miscontruct not flagged
Дата
Msg-id 200806171713.m5HHDKJ5018306@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4247: (Possible) SQL miscontruct not flagged
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      4247
Logged by:          J6M
Email address:      j6m@adm.estp.fr
PostgreSQL version: 8.1.13
Operating system:   Linux x86-64
Description:        (Possible) SQL miscontruct not flagged
Details:

Hi,

This European afternoon, I was trying to count how many distinct values of a
row in a table exists and put this result in another table.

Instead of writing :

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

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).

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

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: BUG #4245: Product Name...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4247: (Possible) SQL miscontruct not flagged