Reproducing incorrect order with order by in a subquery

Поиск
Список
Период
Сортировка
От Ruslan Zakirov
Тема Reproducing incorrect order with order by in a subquery
Дата
Msg-id CAMOxC8tBBR8DK3c73zUWSWRzTPP2FHv5+sLFqL2ZWWwLqGmzhw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Reproducing incorrect order with order by in a subquery
Список pgsql-general
Дерево обсуждения
Hello,

For example I have a query:

SELECT main.*, count(*) OVER () FROM (SELECT DISTINCT ... ORDER BY X) main;

So the `ORDER BY` clause ended up in a subquery. Most of the time ordering works until it doesn't.

Can you help me create a set of test tables with some data to reproduce this problem more repeatedly? I just want to write a regression test to make sure it doesn't happen again. 

--
Best regards, Ruslan.

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

Предыдущее
От: "Wen Yi"
Дата:
Сообщение: Re: How to trace the postgres?
Следующее
От: "Wen Yi"
Дата:
Сообщение: [Beginner Question] Will the backup wal file take too much storage space?