Re: Making Row Comparison NULL row member handling more robust during skip scans

2025-06-19 Thread Peter Geoghegan
On Wed, Jun 18, 2025 at 8:41 PM Peter Geoghegan wrote: > Attached patch shows how this could work. It refines the rules around > NULL row comparison members in _bt_check_rowcompare, and in _bt_first. > The fundamental idea here is to make _bt_check_rowcompare *consistent* > with _bt_first. That wa

Making Row Comparison NULL row member handling more robust during skip scans

2025-06-18 Thread Peter Geoghegan
There's one aspect of my recent bugfix commit 5f4d98d4 that still doesn't sit well with me: the way that it taught _bt_set_startikey to completely back out of applying any of its optimization in the presence of a RowCompare. Without this "row compare back out" behavior, there are obscure cases wher