Fixes for multirange selectivity estimation
authorAlexander Korotkov <akorotkov@postgresql.org>
Tue, 29 Jun 2021 20:18:09 +0000 (23:18 +0300)
committerAlexander Korotkov <akorotkov@postgresql.org>
Tue, 29 Jun 2021 20:18:59 +0000 (23:18 +0300)
commit322e82b77ef4acb9697c6e4259292f5671cb85bb
treeb490d5775aeb75ed9bc59a9f598a53bfc34db1aa
parent690339fcd58759d213523f87071f992c4402e980
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
src/backend/utils/adt/multirangetypes_selfuncs.c
src/test/regress/expected/multirangetypes.out
src/test/regress/sql/multirangetypes.sql