Feature Request: Add MySQL 9.6 (Innovation Release) CI testing

[timvaillancourt]

Feature Description

Add CI coverage for MySQL 9.6.0 (Innovation Release) so we can catch compatibility issues before the next MySQL major release lands.

Use Case(s)

MySQL's innovation track moves fast — having a preview/canary in CI lets us know what's going to break before it becomes a problem.

[arthurschreiber]

I think it's okay to just keep this in a long-running PR where we merge main into from time to time to see what breaks. Enabling the additional CI runs on all branches might be too much overhead for a MySQL version that we don't want to support anyway. Obviously that changes once 9.7 is released (which will become a LTS release if I understand correctly).

[timvaillancourt]

In hindsight, let's wait for a 9.7 RC - this adds a lot of CI jobs I didn't quite expect