Error reading from database after upgrade to 3.7.1 (MySQL 8.0.2)

Setup

1. Use a MySQL 8.0.2 server. Docker would be the simplest way to do this.

   docker run --name mysql802 -p 3307:3306 -e MYSQL_ROOT_PASSWORD=moodle -d mysql:8.0.2 --character-set-server=utf8mb4 --collation-server=utf8mb4_bin

   Note: We're using port 3307 just in case there's already another MySQL server running on your machine.

2. Connect to the MySQL8 server.

   mysql -h 127.0.0.1 -P 3307 -uroot -pmoodle

3. Create a new database schema for your Moodle instance.

   CREATE SCHEMA `integration[VERSION]` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

   where "[VERSION]" is the version of the instance you're testing.

Test

1. Go to your moodle instance's page and proceed with the install
2. On the Database settings page, enter the following details:

   Database host	127.0.0.1
   Database name	integration[VERSION]
   Database user	root
   Database password	moodle
   Tables prefix
   Database port	3307

3. Proceed with the install.
4. Confirm that the installation completes successfully.
5. Proceed to set up the Moodle instance.
6. Confirm that you can successfully set up your Moodle instance.
7. Create a course, enrol some students.
8. Auto-create some groups.
9. Confirm that groups auto-creation works as expected.
10. Edit one of the created groups and save the changes.
11. Confirm that the group is successfully updated.
12. Delete one of the groups.
13. Confirm that the selected group gets successfully deleted.