diff options
author | Michael Paquier <michael@paquier.xyz> | 2023-03-02 14:03:21 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2023-03-02 14:03:21 +0900 |
commit | 5ad63eee13e70eeff9659bcee024e8249b6bf68c (patch) | |
tree | d034ef97e7e2cc1882280db5ba36b8349994f056 /contrib/pageinspect/expected/gist.out | |
parent | 1a9356f657e19ae1abeb0ffea0b7edaf69e315cb (diff) |
pageinspect: Fix crash with gist_page_items()
Attempting to use this function with a raw page not coming from a GiST
index would cause a crash, as it was missing the same sanity checks as
gist_page_items_bytea(). This slightly refactors the code so as all the
basic validation checks for GiST pages are done in a single routine,
in the same fashion as the pageinspect functions for hash and BRIN.
This fixes an issue similar to 076f4d9. A test is added to stress for
this case. While on it, I have added a similar test for
brin_page_items() with a combination make of a valid GiST index and a
raw btree page. This one was already protected, but it was not tested.
Reported-by: Egor Chindyaskin
Author: Dmitry Koval
Discussion: https://postgr.es/m/17815-fc4a2d3b74705703@postgresql.org
Backpatch-through: 14
Diffstat (limited to 'contrib/pageinspect/expected/gist.out')
-rw-r--r-- | contrib/pageinspect/expected/gist.out | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/contrib/pageinspect/expected/gist.out b/contrib/pageinspect/expected/gist.out index 469fc5eabf6..3f2e720d024 100644 --- a/contrib/pageinspect/expected/gist.out +++ b/contrib/pageinspect/expected/gist.out @@ -66,14 +66,16 @@ SELECT itemoffset, ctid, itemlen FROM gist_page_items_bytea(get_raw_page('test_g 7 | (7,65535) | 40 (7 rows) --- Failure with non-GiST index. +-- Suppress the DETAIL message, to allow the tests to work across various +-- page sizes and architectures. +\set VERBOSITY terse +-- Failures with non-GiST index. CREATE INDEX test_gist_btree on test_gist(t); SELECT gist_page_items(get_raw_page('test_gist_btree', 0), 'test_gist_btree'); ERROR: "test_gist_btree" is not a GiST index +SELECT gist_page_items(get_raw_page('test_gist_btree', 0), 'test_gist_idx'); +ERROR: input page is not a valid GiST page -- Failure with various modes. --- Suppress the DETAIL message, to allow the tests to work across various --- page sizes and architectures. -\set VERBOSITY terse -- invalid page size SELECT gist_page_items_bytea('aaa'::bytea); ERROR: invalid page size |