Remove incidental md5() function uses from main regression tests
authorPeter Eisentraut <[email protected]>
Mon, 13 Mar 2023 09:15:44 +0000 (10:15 +0100)
committerPeter Eisentraut <[email protected]>
Mon, 13 Mar 2023 09:53:28 +0000 (10:53 +0100)
commit208bf364a9cc80cc586d060726d076ba7d0c8dec
tree81ac11419672fdcf89bfcccdb3401cb46d3b80e3
parentd72900bdedc60fe20bc50d5d0e7dcb4bc0eb304e
Remove incidental md5() function uses from main regression tests

Most of these calls were to generate some random data.  These can be
replaced by appropriately adapted sha256() calls.  To keep the diff
smaller, we wrap this into a helper function that produces the same
output format and length as the md5() call.

This will eventually allow these tests to pass in OpenSSL FIPS mode
(which does not allow MD5 use).

Similar work for other test suites will follow later.

Reviewed-by: Tom Lane <[email protected]>
Discussion: https://www.postgresql.org/message-id/flat/dbbd927f-ef1f-c9a1-4ec6-c759778ac852@enterprisedb.com
26 files changed:
src/test/regress/expected/arrays.out
src/test/regress/expected/brin.out
src/test/regress/expected/brin_multi.out
src/test/regress/expected/compression.out
src/test/regress/expected/compression_1.out
src/test/regress/expected/inherit.out
src/test/regress/expected/largeobject.out
src/test/regress/expected/largeobject_1.out
src/test/regress/expected/matview.out
src/test/regress/expected/memoize.out
src/test/regress/expected/plpgsql.out
src/test/regress/expected/rowsecurity.out
src/test/regress/expected/stats_ext.out
src/test/regress/expected/test_setup.out
src/test/regress/sql/arrays.sql
src/test/regress/sql/brin.sql
src/test/regress/sql/brin_multi.sql
src/test/regress/sql/compression.sql
src/test/regress/sql/inherit.sql
src/test/regress/sql/largeobject.sql
src/test/regress/sql/matview.sql
src/test/regress/sql/memoize.sql
src/test/regress/sql/plpgsql.sql
src/test/regress/sql/rowsecurity.sql
src/test/regress/sql/stats_ext.sql
src/test/regress/sql/test_setup.sql