Build failures in Ubuntu 22.04 LTS

[jng]

Building FDO when trying to use all available system libs fails in Ubuntu 22.04 LTS due to the following environmental/lib changes:

FDOCommon:

• System xalan-c is now 1.12, which removes several macros that break compilation of TransformerXalan.cpp
• Usage of FILE internal implementation details for testing read/write capabilities in FdoIoFileStream that are no longer valid in this environment.

MySQL Provider:

• System libmysqlclient no longer ships the my_global.h header and no longer defines my_bool (see: ​https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-1.html#mysqld-8-0-1-compiling)

OWS:

• References to the long deprecated std::auto_ptr that should now be std::unique_ptr

WMS/WFS Provider:

• Link failure in UnitTest executable on pthread_nonshared. We can probably just get rid of these link references.

[jng]

In 8174:

Fix an assortment of issues discovered building FDO on Ubuntu 22.04 LTS:

FDO Common

• Fix TransformerXalan to work with system-installed xalan-c 1.12 (internal thirdparty ver is 1.11)
• Fix undefined _IO_NO_READS and _IO_NO_WRITES in FdoIoFileStream

MySQL Provider

• Add CMake test in MySQL module to see if my_global.h exists, if it does define a HAVE_MY_GLOBAL_H preprocessor symbol
• Polyfill my_bool typedef if my_global.h is not found (using the HAVE_MY_GLOBAL_H symbol)
• Fix undefined mysql_is_null when my_global.h is not found due to function declaration and implementation signature mismatch

OWS

• Replace std::auto_ptr with std::unique_ptr

WFS/WMS

• Don't link to pthread/pthread_nonshared in UnitTest executables

Fixes #999

[jng]

Re-opening to fix failing unit tests and other problems