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

git projects / postgresql.git / commit

Fix handling of clauses incompatible with extended statistics

author Tomas Vondra <tomas.vondra@postgresql.org>

Tue, 6 Apr 2021 14:12:37 +0000 (16:12 +0200)

committer Tomas Vondra <tomas.vondra@postgresql.org>

Tue, 6 Apr 2021 14:56:06 +0000 (16:56 +0200)

commit 518442c7f334f3b05ea28b7ef50f1b551cfcc23e

tree 5a24b7e2dea054ed0fb094afbb8dcbd7fa441d70 tree

parent 7ab96cf6b312cfcd79cdc1a69c6bdb75de0ed30f commit | diff

Fix handling of clauses incompatible with extended statistics

Handling of incompatible clauses while applying extended statistics was
a bit confused - while handling a mix of compatible and incompatible
clauses it sometimes incorrectly treated the incompatible clauses as
compatible, resulting in a crash.

Fixed by reworking the code applying the selected statistics object to
make it easier to understand, and adding a proper compatibility check.

Reported-by: David Rowley
Discussion: https://postgr.es/m/CAApHDvpYT10-nkSp8xXe-nbO3jmoaRyRFHbzh-RWMfAJynqgpQ%40mail.gmail.com

src/backend/statistics/extended_stats.c diff | blob | blame | history

src/backend/statistics/mcv.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