enum usage causes 'Incorrect arguments to mysqld_stmt_execute' error

[omikuji]

Hello, everyone ❤️

I'm currently trying to INSERT records into a table with an enum field, but I'm encountering an 'Incorrect arguments to mysqld_stmt_execute' error.

Here is the MySQL table schema.

CREATE TABLE
  `user` (
    `id` BIGINT (11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR (100) NOT NULL,
    `status` ENUM (
      'provisional_registration',
      'official_registration'
    ) NOT NULL,
    `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;

Here is the Rust code I used for validation.

#[derive(Debug, Clone, sqlx::Type)]
#[sqlx(rename_all = "snake_case")]
pub enum Status {
    ProvisionalRegistration,
    OfficialRegistration,
}

#[tokio::main(worker_threads = 10)]
async fn main() {
    let db_pool = sqlx::mysql::MySqlPoolOptions::new()
        .connect("mysql://dev:dev@localhost:13306/dev")
        .await
        .unwrap();

    sqlx::query!(
        r#"
        INSERT INTO user (
            name,
            status,
            created_at
        ) VALUES (?, ?, now());
        "#,
        "sample".to_string(),
        Status::ProvisionalRegistration
    )
    .execute(&db_pool)
    .await
    .unwrap();
}

Here is the Cargo.toml

[package]
name = "example"
version = "0.1.0"
edition = "2021"

[dependencies]
sqlx = { version = "0.7.0", features = ["mysql", "runtime-tokio-rustls", "chrono", "bigdecimal"] }
futures = "0.3"
chrono = { version = "0.4", features = ["serde"] }
chrono-tz = "0.6"
tokio = { version = "1.0", features = ["full"] }
tokio-util = { version = "0.7", features = ["io"] }

Here is the error message.

$ cargo run
   Compiling example v0.1.0 (/Users/omikuji/dev/omikuji/try-sqlx-0.7)
    Finished dev [unoptimized + debuginfo] target(s) in 0.79s
     Running `target/debug/example`
thread 'main' panicked at 'called `Result::unwrap()` on an `Err` value: Database(MySqlDatabaseError { code: Some("HY000"), number: 1210, message: "Incorrect arguments to mysqld_stmt_execute" })', src/main.rs:28:6
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace

I've created a sample project below. You can verify its operation by running docker compose up followed by cargo run.
https://github.com/omikuji/try-sqlx-0.7

Thank you ;)

[gitAwa1]

これ私も同じ現象なりました