git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix selectivity estimation @> (anymultirange, anyrange) operator

author Alexander Korotkov <akorotkov@postgresql.org>

2020年12月30日 17:19:15 +0000 (20:19 +0300)

committer Alexander Korotkov <akorotkov@postgresql.org>

2020年12月30日 17:31:15 +0000 (20:31 +0300)

commit 62097a4cc8c725fa86d3170396a8f30609acd0d3

tree cbbf7e3fc3f7722abf19f29fec592e7d4ac5df3e tree

parent 860fe27ee1e2a4a1c36c2f874c37656533cccce9 commit | 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

src/backend/utils/adt/multirangetypes_selfuncs.c diff | blob | blame | history

src/test/regress/expected/multirangetypes.out diff | blob | blame | history

src/test/regress/expected/rangetypes.out diff | blob | blame | history

src/test/regress/sql/multirangetypes.sql diff | blob | blame | history

src/test/regress/sql/rangetypes.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom