Postgres Pro
Downloads
Home   >   mailing lists

Reproducing incorrect order with order by in a subquery - Mailing list pgsql-general

From Ruslan Zakirov
Subject Reproducing incorrect order with order by in a subquery
Date
Msg-id CAMOxC8tBBR8DK3c73zUWSWRzTPP2FHv5+sLFqL2ZWWwLqGmzhw@mail.gmail.com
Whole thread Raw
Responses Re: Reproducing incorrect order with order by in a subquery  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Tree view
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 by date:

Previous
From: "Wen Yi"
Date:
Subject: Re: How to trace the postgres?
Next
From: "Wen Yi"
Date:
Subject: [Beginner Question] Will the backup wal file take too much storage space?