Re: `order by random()` makes select-list `random()` invocations deterministic

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: `order by random()` makes select-list `random()` invocations deterministic
Дата
Msg-id CAKFQuwYo+EV4=o8Uc6wH=Ko+V8hgiqqOK=a9EC5G90HYx9+POw@mail.gmail.com
обсуждение исходный текст
Ответ на `order by random()` makes select-list `random()` invocations deterministic  ("Dian Fay" <di@nmfay.com>)
Ответы Re: `order by random()` makes select-list `random()` invocations deterministic  ("Dian Fay" <di@nmfay.com>)
Список pgsql-bugs
Дерево обсуждения
On Wednesday, February 28, 2024, Dian Fay <di@nmfay.com> wrote:

Every `random()` invocation in the select list uses a single consistent
value within each returned row. Remove the `order by random()` and
values become randomized as expected, but it gets a bit stranger:

 
This seems to be one of those “won’t fix” bugs that stems from the parser being a bit too liberal in what it accepts as valid SQL.


The fact that the gs involving expression is seen differently than the ones not involving gs doesn’t surprise me.

David J.

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #18363: Assert !ReindexIsProcessingIndex falsified with expression index over select from table
Следующее
От: "feichanghong"
Дата:
Сообщение: Re:BUG #18371: There are wrong constraint residues when detach hash partiton concurrently