Fix SPLIT PARTITION range bound validation with DEFAULT
Alexander Korotkov <akorotkov@postgresql.org>
Author:
Alexander Korotkov <akorotkov@postgresql.org>
Date: 2026-05-19T10:54:55Z
Releases:
19 (unreleased)
Fix SPLIT PARTITION range bound validation with DEFAULT When splitting a range partition and defining a new DEFAULT partition, the validation checked the lower bound of the first explicit partition and the upper bound of explicit partitions only when they were not first. If there was exactly one explicit non-DEFAULT partition, its upper bound was therefore not checked. This could allow the replacement partition to extend beyond the upper bound of the partition being split, potentially overlapping another existing partition. Fix this by checking the upper bound whenever the explicit partition is the last one. Add a regression test covering the single explicit partition plus DEFAULT case. Author: Chao Li <lic@highgo.com> Reviewed-by: Kirill Reshke <reshkekirill@gmail.com> Reviewed-by: Zhenwei Shang <a934172442@gmail.com> Reviewed-by: Dmitry Koval <d.koval@postgrespro.ru> Reviewed-by: Alexander Korotkov <aekorotkov@gmail.com> Discussion: https://postgr.es/m/C18878AB-DEB2-4A61-9995-A035DD644B81@gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/partitioning/partbounds.c | modified | +2 −1 |
| src/test/regress/expected/partition_split.out | modified | +16 −0 |
| src/test/regress/sql/partition_split.sql | modified | +15 −0 |
Discussion
- Fix SPLIT PARTITION bound-overlap bug and other improvements 20 messages · 2026-05-13 → 2026-05-25