Fix nbtree lookahead overflow bug.
Peter Geoghegan <pg@bowt.ie>
Fix nbtree lookahead overflow bug. Add bounds checking to nbtree's lookahead/skip-within-a-page mechanism. Otherwise it's possible for cases with lots of before-array-keys tuples to overflow an int16 variable, causing the mechanism to generate an out of bounds page offset number. Oversight in commit 5bf748b8, which enhanced nbtree ScalarArrayOp execution. Reported-By: Alexander Lakhin <exclusion@gmail.com> Discussion: https://postgr.es/m/6c68ac42-bbb5-8b24-103e-af0e279c536f@gmail.com Backpatch: 17-, where nbtree SAOP execution was enhanced.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/nbtree/nbtutils.c | modified | +1 −1 |
Discussion
- Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan 78 messages · 2023-07-25 → 2024-08-26