diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2024-08-16 17:14:32 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2024-08-16 17:25:57 +0200 |
| commit | 47b47a5617fa0c49e5d8788d5f1150c21485f3ff (patch) | |
| tree | 0cee6d792d94589669d14283f23bd9ea92069737 | |
| parent | 68f199cea3b190ba0bc2c83d92d17e7e1792a141 (diff) | |
| download | postgresql-47b47a5617fa0c49e5d8788d5f1150c21485f3ff.tar.gz postgresql-47b47a5617fa0c49e5d8788d5f1150c21485f3ff.zip | |
Remove incidental md5() function use from test
To allow test to pass in OpenSSL FIPS mode, similar to 657f5f223e, for
a new test that has been added since.
Reviewed-by: Tomas Vondra <tomas@vondra.me>
Discussion: https://www.postgresql.org/message-id/86763810-70a1-4872-8ba7-1676f788e5a2@eisentraut.org
| -rw-r--r-- | contrib/pageinspect/expected/brin.out | 10 | ||||
| -rw-r--r-- | contrib/pageinspect/sql/brin.sql | 2 |
2 files changed, 6 insertions, 6 deletions
diff --git a/contrib/pageinspect/expected/brin.out b/contrib/pageinspect/expected/brin.out index 3a9d9125e42..b6a43bbb01b 100644 --- a/contrib/pageinspect/expected/brin.out +++ b/contrib/pageinspect/expected/brin.out @@ -114,7 +114,7 @@ CREATE TABLE brin_parallel_test (a int, b text, c bigint) WITH (fillfactor=40); -- for the different opclasses we build later). INSERT INTO brin_parallel_test SELECT (CASE WHEN (mod(i,231) = 0) OR (i BETWEEN 3500 AND 4000) THEN NULL ELSE i END), - (CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3750 AND 4250) THEN NULL ELSE md5(i::text) END), + (CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3750 AND 4250) THEN NULL ELSE encode(sha256(i::text::bytea), 'hex') END), (CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3850 AND 4500) THEN NULL ELSE (i/100) + mod(i,8) END) FROM generate_series(1,5000) S(i); -- Build an index with different opclasses - minmax, bloom and minmax-multi. @@ -152,8 +152,8 @@ SELECT relname, relpages ORDER BY relname; relname | relpages ------------------------+---------- - brin_test_parallel_idx | 3 - brin_test_serial_idx | 3 + brin_test_parallel_idx | 4 + brin_test_serial_idx | 4 (2 rows) -- Check that (A except B) and (B except A) is empty, which means the indexes @@ -186,8 +186,8 @@ SELECT relname, relpages ORDER BY relname; relname | relpages ------------------------+---------- - brin_test_parallel_idx | 3 - brin_test_serial_idx | 3 + brin_test_parallel_idx | 4 + brin_test_serial_idx | 4 (2 rows) SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx') diff --git a/contrib/pageinspect/sql/brin.sql b/contrib/pageinspect/sql/brin.sql index aadbf0529f2..4edf17b5a45 100644 --- a/contrib/pageinspect/sql/brin.sql +++ b/contrib/pageinspect/sql/brin.sql @@ -62,7 +62,7 @@ CREATE TABLE brin_parallel_test (a int, b text, c bigint) WITH (fillfactor=40); -- for the different opclasses we build later). INSERT INTO brin_parallel_test SELECT (CASE WHEN (mod(i,231) = 0) OR (i BETWEEN 3500 AND 4000) THEN NULL ELSE i END), - (CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3750 AND 4250) THEN NULL ELSE md5(i::text) END), + (CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3750 AND 4250) THEN NULL ELSE encode(sha256(i::text::bytea), 'hex') END), (CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3850 AND 4500) THEN NULL ELSE (i/100) + mod(i,8) END) FROM generate_series(1,5000) S(i); |