Tests: Extend FindHDF5 tests to link and run executables
Verify that this works using both targets and variables.
In Fedora's HDF5 packages for OpenMPI and MPICH, the h5pfc
compiler
wrappers for Fortran use the wrong search path for their Fortran
modules. Patch them locally in CI jobs until it is fixed in Fedora
upstream.