Re: pgsql: Improve BRIN minmax-multi opclass test coverage

These new tests introduced a few new calls of the md5() function. This
should be avoided (see commit 208bf364a9). You can replace these easily
with the fipshash() function instead, but I think you then also need to
change some of the constants in the tests. Could you look at this again?

On 02.07.23 10:34, Tomas Vondra wrote:
> Improve BRIN minmax-multi opclass test coverage
>
> Per the code coverage report, the existing regression tests did not
> exercice some a couple important BRIN minmax-multi code paths.
>
> - The tests focused on testing planning with a range of scan key
> strategies, but not the execution. Fixed by adding queries that
> actually test query execution for both equality and inequality.
>
> - All tests created indexes after inserting data, but this only
> exercises the CREATE INDEX strategy that sees all values at once, not
> incremental summary updates. The new tests flip the order and create
> the index before adding data.
>
> - The assert check(s) validating correctness of expanded ranges were
> present only in the "union" code path, which is not covered by
> regression tests at all (as it requires concurrency etc.). Fixed by
> adding the asserts to a couple more places.
>
> Reviewed-by: Heikki Linnakangas
> Discussion: https://postgr.es/m/57020b2e-d9c9-9bc7-4892-b36d9bb07563%40enterprisedb.com
>
> Branch
> ------
> master
>
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/0457109344b46f481f9bf09b85674695ba57c8e4
>
> Modified Files
> --------------
> src/backend/access/brin/brin_minmax_multi.c | 9 +
> src/test/regress/expected/brin_multi.out | 357 ++++++++++++++++++++++++++++
> src/test/regress/sql/brin_multi.sql | 165 +++++++++++++
> 3 files changed, 531 insertions(+)
>