Re: BUG #15262: "unexpected end of tuplestore" error when using newGROUPS window function clause

Поиск
Список
Период
Сортировка
От Lukas Eder
Тема Re: BUG #15262: "unexpected end of tuplestore" error when using newGROUPS window function clause
Дата
Msg-id CAB4ELO6eoBx=PcwuFkHFq-_diRK-opcmZc5V9avhFZmxyWzB8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15262: "unexpected end of tuplestore" error when using new GROUPS window function clause  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения


Am Di., 10. Juli 2018 um 00:29 Uhr schrieb Tom Lane <tgl@sss.pgh.pa.us>:
I think what we really should be doing here is giving a parse error.

Yes, I agree. That's also what the SQL standard says. 

ISO/IEC 9075-2:2016(E)
7.15 <window clause>
13 c) If GROUPS is specified, then: 
i) Either WDEF shall contain a <window order clause>, or WDEF shall specify an <existing window name> that identifies a window structure descriptor that includes a window ordering clause.
 
What would you expect GROUPS mode to do without an ORDER BY to define the grouping?

I had no expectations, was just playing around with the new syntax. 

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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Extension relocation vs. schema qualification
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15271: Documentation / Error reporting on GUC parameter change