PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15839
PG Version10.6
OSUbuntu 18.04.1
Opened2019-06-07 14:30:08+00
Reported byАлександр Черников
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15839
Logged by:          Александр Черников
Email address:      (redacted)
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

Messages

DateAuthorSubject
2019-06-07 14:30:08+00PG Bug reporting formBUG #15839: Using text field for sorting in prepared query leads to wrong result
2019-06-07 16:06:44+00"David G(dot) Johnston"Re: BUG #15839: Using text field for sorting in prepared query leads to wrong result