Solaris 11.4/x86 with GCC 13.2.0

same as with other issues. We don't have Solaris in CI, but if you'll provide a patch, we'll apply it (providing it won't break anything else)

MDEV-33091-pcre2.patch

Since the pcre2 headers live in `/usr/include/pcre` on Solaris and so far `pcre.cmake` only checks for the existance of the libraries, not for the headers, that `cmake` check needs to be revamped:

• Like e.g. `libxml2`(`FindLibXml2.cmake` bundled with `cmake`), the test now uses `PKG_CHECK_MODULES` (i.e. `pkg-config`) to check for `pcre2` headers and libraries.
• In addition, it uses separate calls to `find_path` (which supports `PATH_SUFFIXES` to handle headers in subdirs of `/usr/include`) and `find_library`)
• If the `pkg-config` check found a separate include directory for the `pcre2` headers, that one is assigned to `PCRE_INCLUDES` which is already used so those headers are found when a bundled version of `pcre2` is used.

Again, tested on Solaris 11.4/amd64 (which needs that separate `pcre` subdir) and Linux/x86_64 (which doesn't).

why do you need find_path and find_library in your patch? pkg-config is supposed to provide all paths, you shouldn't need to search manually after it.

I'd expect it to be just pkg_check_modules(PCRE ${required} libpcre2-8) and then use PCRE_LIBRARIES, PCRE_INCLUDE_DIRS, etc (here ${required} is REQUIRED if WITH_PCRE is "system")

I've followed `cmake's `FindLibXml2.cmake here. I suppose they use both `pkg_check_modules and `find_path/`find_library to allow for configurations with and without `pkg-config files.

rorth, please check commit 37beb8b8bc0 — does it work for you?

I just gave the bb-10.6-serg branch a try on Solaris 11.4: the errors not finding the pcre errors are gone. Thanks.