Re: BUG #17068: Incorrect ordering of a particular row.

On Wed, Jun 23, 2021 at 1:07 AM David Rowley <dgrowleyml@gmail.com> wrote:
> I've attached an SQL file to make it easier to reproduce.

If you change the SELECT list to output alias3::text, there's a
different value there:

 id |  alias3
----+----------
  1 | (Burn)
  1 | (Burn)
  1 | (Burn)
  3 | (Burn)
  3 | (Burn)
  3 | (Burn)
  3 | (Burn)
  5 | (Burn)
  1 | (Cool)
  1 | (Cool)
  1 | (Cool)
  3 | (Cool)
  3 | (Cool)
  3 | (Cool)
  3 | (Cool)
  5 | (Cool)
  1 | (Killer)
  1 | (Killer)
  1 | (Killer)
  3 | (Killer)
  3 | (Killer)
  3 | (Killer)
  3 | (Killer)
  5 | (Killer)
  1 | (Nikon)
  1 | (Nikon)
  1 | (Nikon)
  3 | (Nikon)
  3 | (Nikon)
  3 | (Nikon)
  3 | (Nikon)
  5 | (Nikon)
  1 | ()
  1 | ()
  1 | ()
  3 | ()
  3 | ()
  3 | ()
  3 | ()
  5 | ()
  4 |
  4 |
  4 |
  4 |
(44 rows)