pgsql: Avoid nbtree index scan SAOP scanBehind confusion.

2024-12-19 Thread Peter Geoghegan
Avoid nbtree index scan SAOP scanBehind confusion. Consistently reset so->scanBehind at the beginning of nbtree array advancement, even during sktrig_required=false calls (calls where array advancement is triggered by an unsatisfied non-required array scan key). Otherwise, it's possible for querie

pgsql: Avoid nbtree index scan SAOP scanBehind confusion.

2024-12-19 Thread Peter Geoghegan
Avoid nbtree index scan SAOP scanBehind confusion. Consistently reset so->scanBehind at the beginning of nbtree array advancement, even during sktrig_required=false calls (calls where array advancement is triggered by an unsatisfied non-required array scan key). Otherwise, it's possible for querie