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

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: BUG #17068: Incorrect ordering of a particular row.
Дата
Msg-id CAApHDvoKk=NO7H6p8UNjSXbio8vq9yUjZhHO_Xr=C14WMs9i+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17068: Incorrect ordering of a particular row.  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: BUG #17068: Incorrect ordering of a particular row.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Wed, 23 Jun 2021 at 01:26, Thomas Munro <thomas.munro@gmail.com> wrote:
> If you change the SELECT list to output alias3::text, there's a
> different value there:

Yeah, if I change it to ORDER BY alias3.lastname, nullnamesb.id;
instead of ORDER BY alias3.*, nullnamesb.id; then the tie break using
btint4fastcmp() is called more often.  It's also getting called with
the missing 4s which I mentioned upthread.

See the two outputs.  That points me towards something weird going on
in record_cmp().

David

Вложения

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #17066: Cache lookup failed when null (iso-8859-1) is passed as anycompatiblemultirange
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17068: Incorrect ordering of a particular row.