]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Always commute strategy when preprocessing DESC keys.
authorPeter Geoghegan <pg@bowt.ie>
Fri, 12 Sep 2025 17:22:58 +0000 (13:22 -0400)
committerPeter Geoghegan <pg@bowt.ie>
Fri, 12 Sep 2025 17:22:58 +0000 (13:22 -0400)
commite457312c0d19b3d4e60f44f7260280a2788c1503
tree52c43dc099c9ce45b6a7c98e1044bcb60c0b8948
parent3c0018a6f417425b1e6f2516fe6493596d71bddf
Always commute strategy when preprocessing DESC keys.

A recently added nbtree preprocessing step failed to account for the
fact that DESC columns already had their B-Tree strategy number commuted
at this point in preprocessing.  As a result, preprocessing could output
a set of scan keys where one or more keys had the correct strategy
number, but used the wrong comparison routine.

To fix, make the faulty code path that looks up a more restrictive
replacement operator/comparison routine commute its requested inequality
strategy (while outputting the transformed strategy number as before).
This makes the final transformed scan key comport with the approach
preprocessing has always used to deal with DESC columns (which is
described by comments above _bt_fix_scankey_strategy).

Oversight in commit commit b3f1a13f, which made nbtree preprocessing
perform transformations on skip array inequalities that can reduce the
total number of index searches.

Author: Peter Geoghegan <pg@bowt.ie>
Reported-By: Natalya Aksman <natalya@timescale.com>
Discussion: https://postgr.es/m/19049-b7df801e71de41b2@postgresql.org
Backpatch-through: 18
src/backend/access/nbtree/nbtpreprocesskeys.c