diff options
| author | Alexander Korotkov | 2020-12-30 17:19:15 +0000 |
|---|---|---|
| committer | Alexander Korotkov | 2020-12-30 17:31:15 +0000 |
| commit | 62097a4cc8c725fa86d3170396a8f30609acd0d3 (patch) | |
| tree | cbbf7e3fc3f7722abf19f29fec592e7d4ac5df3e /src/backend | |
| parent | 860fe27ee1e2a4a1c36c2f874c37656533cccce9 (diff) | |
Fix selectivity estimation @> (anymultirange, anyrange) operator
Attempt to get selectivity estimation for @> (anymultirange, anyrange) operator
caused an error in buildfarm, because this operator was missed in switch()
of calc_hist_selectivity(). Fix that and also make regression tests reliably
check that selectivity estimation for (multi)ranges doesn't fall. Previously,
whether we test selectivity estimation for (multi)ranges depended on
whether autovacuum managed to gather concurrently to the test.
Reported-by: Michael Paquier
Discussion: https://postgr.es/m/X%2BwmgjRItuvHNBeV%40paquier.xyz
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/utils/adt/multirangetypes_selfuncs.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/backend/utils/adt/multirangetypes_selfuncs.c b/src/backend/utils/adt/multirangetypes_selfuncs.c index bb016b6e987..14283e4503a 100644 --- a/src/backend/utils/adt/multirangetypes_selfuncs.c +++ b/src/backend/utils/adt/multirangetypes_selfuncs.c @@ -649,6 +649,7 @@ calc_hist_selectivity(TypeCacheEntry *typcache, VariableStatData *vardata, case OID_MULTIRANGE_RANGE_CONTAINED_OP: case OID_MULTIRANGE_MULTIRANGE_CONTAINED_OP: + case OID_RANGE_MULTIRANGE_CONTAINED_OP: if (const_lower.infinite) { /* |