[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-committers
Subject: pgsql: Fixes for multirange selectivity estimation
From: Alexander Korotkov <akorotkov () postgresql ! org>
Date: 2021-06-29 20:19:20
Message-ID: E1lyKCW-00023f-ED () gemulon ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (text/plain)]
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
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/178ec460db0a0ced46ac5a01a28a704ca6251e53
Modified Files
--------------
src/backend/utils/adt/multirangetypes_selfuncs.c | 38 ++--
src/test/regress/expected/multirangetypes.out | 210 +++++++++++++++++++++++
src/test/regress/sql/multirangetypes.sql | 37 ++++
3 files changed, 272 insertions(+), 13 deletions(-)
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic