Pivot query broken in MySQL 8.0.27 and later

[jas88]

The pivot query in unit tests fails when run against Oracle MySQL 8.0.27 and later, but not latest MariaDB. Issue initially discussed here when it was thought to be a CI issue: #150