I have found these related issues/pull requests

Dependabot opened a PR to update sqlx and we are seeing test failures in CI with the following errori (running MySQL 8.0):

failed to connect to setup test database: Database(MySqlDatabaseError { code: Some("42000"), number: 1170, message: "BLOB/TEXT column 'db_name' used in key specification without a key length" })

I tried to replicate locally (running MySQL 8.4), and I get a different error in the same place:

failed to connect to setup test database: Database(MySqlDatabaseError { code: Some("42000"), number: 1064, message: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\"_sqlx_test_Ylj2v2hx__h1aECWV42suiB3FA7wWvFMWM8xQ0Hk3Y_zXr6_hQg2\"' at line 1" })

Description

Error setting up test fixture database.

Reproduction steps

Run cargo test on a codebase that includes a fixture while running MySQL 8.0+.

SQLx version

0.8.4

Enabled SQLx features

mysql,migrate,runtime-tokio,chrono,tls-rustls

Database server and version

MySQL

Operating system

Linux / MacOS

Rust version

1.86.0