Fix selectivity estimation @> (anymultirange, anyrange) operator
authorAlexander Korotkov
Wed, 30 Dec 2020 17:19:15 +0000 (20:19 +0300)
committerAlexander Korotkov
Wed, 30 Dec 2020 17:31:15 +0000 (20:31 +0300)
commit62097a4cc8c725fa86d3170396a8f30609acd0d3
treecbbf7e3fc3f7722abf19f29fec592e7d4ac5df3e
parent860fe27ee1e2a4a1c36c2f874c37656533cccce9
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
src/backend/utils/adt/multirangetypes_selfuncs.c
src/test/regress/expected/multirangetypes.out
src/test/regress/expected/rangetypes.out
src/test/regress/sql/multirangetypes.sql
src/test/regress/sql/rangetypes.sql