On Mon, Dec 23, 2024 at 1:02 PM Peter Geoghegan <p...@bowt.ie> wrote: > Attached patch fixes the problem by moving detection of RowCompare > unsatisfiable-due-to-NULL cases into _bt_fix_scankey_strategy.
Attached is v2, which adds several new regression tests, giving certain relevant nbtree code paths test coverage. v2 also makes some small tweaks to _bt_check_rowcompare(), the actual comparator used by scans with a RowCompare qual. We no longer need to account for the possibility that the first row member from a RowCompare scan key contains a null once the scan is underway (we know that _bt_preprocess_keys would have recognized the qual as unsatisfiable had the RowCompare looked like that). -- Peter Geoghegan
v2-0001-Improve-nbtree-unsatisfiable-RowCompare-detection.patch
Description: Binary data
