BUG #15839: Using text field for sorting in prepared query leads to wrong result

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15839: Using text field for sorting in prepared query leads to wrong result
Дата
Msg-id 15839-87a2feb8a1ebb84f@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15839: Using text field for sorting in prepared query leadsto wrong result  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      15839
Logged by:          Александр Черников
Email address:      me@helld.ru
PostgreSQL version: 10.6
Operating system:   Ubuntu 18.04.1
Description:

Example request:
select * from orders where ClientId=$1 and Moment >= $2 and Moment < $3
order by $4 desc, ClientId limit $5 offset ($5-1)*$6;
Field in question is $4
Expected result - poor performance or clear error that dynamic sorting
cannot be used

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

Предыдущее
От: Gabríel Arthúr Pétursson
Дата:
Сообщение: GiST index corruption with large tuples
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #15839: Using text field for sorting in prepared query leadsto wrong result