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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: bc049d0) | patch
Skip system attributes when applying mvdistinct stats
2019年11月16日 00:17:15 +0000 (01:17 +0100)
2019年11月16日 00:58:38 +0000 (01:58 +0100)
commit 25a9ff6cadbb2099a5f53876d9e29f35a080df43
Skip system attributes when applying mvdistinct stats

When estimating number of distinct groups, we failed to ignore system
attributes when matching the group expressions to mvdistinct stats,
causing failures like

ERROR: negative bitmapset member not allowed

Fix that by simply skipping anything that is not a regular attribute.
Backpatch to PostgreSQL 10, where the extended stats were introduced.

Bug: #16111
Reported-by: Tuomas Leikola
Author: Tomas Vondra
Backpatch-through: 10
Discussion: https://postgr.es/m/16111-687799584c3a7e73@postgresql.org
src/backend/utils/adt/selfuncs.c diff | blob | blame | history
src/test/regress/expected/stats_ext.out diff | blob | blame | history
src/test/regress/sql/stats_ext.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /