Re: [BUGS] Improper const-evaluation of HAVING with grouping sets and subquery pullup

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: [BUGS] Improper const-evaluation of HAVING with grouping sets and subquery pullup
Дата
Msg-id 87po9mjec0.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: [BUGS] Improper const-evaluation of HAVING with grouping sets and subquery pullup  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-bugs
Дерево обсуждения 
>>>>> "Andrew" == Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
Andrew> To my knowledge this is the correct result. (Though neitherAndrew> version of the query is legal per the SQL
spec;allowingAndrew> expressions and aliases in GROUP BY are nonstandardAndrew> extensions.)
 

And neither Oracle nor MSSQL (at least the versions available on
sqlfiddle) allow either query, so there's nothing I can compare against.

-- 
Andrew (irc:RhodiumToad)


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: [BUGS] Improper const-evaluation of HAVING with grouping sets and subquery pullup
Следующее
От: boatcoder@gmail.com
Дата:
Сообщение: [BUGS] BUG #14859: Config file parsing is allergic to spaces on last line offile