Re: BUG #15380: Sorting paging data loss

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: 1726002692(at)qq(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15380: Sorting paging data loss
Date: 2018-09-12 03:30:40
Message-ID: 1694.1536723040@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> [ underspecified ORDER BY produces variable row ordering ]

I don't see a bug here. If you want consistent row ordering, you
need to give an ORDER BY that uniquely orders the rows.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message 周正中 (德歌) 2018-09-12 05:02:48 回复：`pg_trgm` not recognizing Chinese characters in macOS
Previous Message PG Bug reporting form 2018-09-12 03:09:29 BUG #15380: Sorting paging data loss