Fix test deprecations and failures #1463

Job	Run time
Windows - PHP 8.1 & SQL Server	2m 40s
cs-stan / Coding Standard & Static Analysis	41s
testsuite-linux (8.4, mariadb)	2m 7s
testsuite-linux (8.3, mysql)	1m 24s
testsuite-linux (8.4, pgsql)	1m 2s
testsuite-linux (8.1, mariadb)	1m 51s
testsuite-linux (8.4, sqlite)	54s
testsuite-linux (8.4, mysql)	1m 26s
testsuite-linux (8.1, sqlite)	1m 1s
testsuite-linux (8.3, pgsql)	1m 5s
testsuite-linux (8.1, sqlite, prefer-lowest)	58s
testsuite-linux (8.1, pgsql)	1m 11s
testsuite-linux (8.1, mysql)	1m 35s
	17m 55s

Provide feedback