From 9d924dbb37103b647c72a5252ad20770b8bae3a1 Mon Sep 17 00:00:00 2001 From: Peter Geoghegan Date: Wed, 30 Apr 2025 23:15:51 -0400 Subject: [PATCH] Adjust overstrong nbtree skip array assertion. Make an nbtree array preprocessing assertion account for scans that add fewer skip arrays than initially expected due to preprocessing finding an unsatisfiable array qual. Oversight in commit 92fe23d9. Author: Peter Geoghegan Reported-By: Mark Dilger Discussion: https://postgr.es/m/CAHgHdKtQMhHy5qcB3KqCcGiW-Rp8P7KzUFRa9ZMKUiv6zen7LQ@mail.gmail.com --- src/backend/access/nbtree/nbtpreprocesskeys.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/backend/access/nbtree/nbtpreprocesskeys.c b/src/backend/access/nbtree/nbtpreprocesskeys.c index 1cc99e6cdf2..a136e4bbfdf 100644 --- a/src/backend/access/nbtree/nbtpreprocesskeys.c +++ b/src/backend/access/nbtree/nbtpreprocesskeys.c @@ -1856,7 +1856,7 @@ _bt_preprocess_array_keys(IndexScanDesc scan, int *new_numberOfKeys) numArrayKeyData++; /* keep this scan key/array */ } - Assert(numSkipArrayKeys == 0); + Assert(numSkipArrayKeys == 0 || !so->qual_ok); /* Set final number of equality-type array keys */ so->numArrayKeys = numArrayKeys; -- 2.30.2