Horton

Fixes for multirange selectivity estimation

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 178ec460db0a0ced46ac5a01a28a704ca6251e53
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2021-06-29T20:18:22Z
Releases: 15.0 
Fixes for multirange selectivity estimation

 * Fix enumeration of the multirange operators in calc_multirangesel() and
   calc_multirangesel() switches.
 * Add more regression tests for matching to empty ranges/multiranges.

Reported-by: Alexander Lakhin
Discussion: https://postgr.es/m/c5269c65-f967-77c5-ff7c-15e621c47f6a%40gmail.com
Author: Alexander Korotkov
Backpatch-through: 14, where multiranges were introduced

Files

PathChange+/−
src/backend/utils/adt/multirangetypes_selfuncs.c modified +25 −13
src/test/regress/expected/multirangetypes.out modified +210 −0
src/test/regress/sql/multirangetypes.sql modified +37 −0

Discussion