Calling `Statement::excecute` multiple times does not change the parameter binding

[bikeshedder]

When calling Connection::prepare once and using the Statement to execute multiple times with varying parameters it causes the query to be executed with the first bound parameters.

Minimal reproduction example:

#[tokio::main]
async fn main() -> Result<(), Box<dyn std::error::Error>> {
    let database = libsql::Builder::new_local("example.db").build().await?;
    let conn = database.connect()?;
    conn.execute_batch("CREATE TABLE domain (fqdn TEXT NOT NULL PRIMARY KEY)").await?;
    let mut stmt = conn.prepare("INSERT INTO domain VALUES (?1)").await?;
    for domain in ["example.com", "example.org"] {
        println!("{}", domain);
        stmt.execute([domain]).await?;
    }
    Ok(())
}

Output:

example.com
example.org
Error: SqliteFailure(1555, "UNIQUE constraint failed: domain.fqdn")

I just released the first version of deadpool-libsql and ran into this issue in my first application I'm trying to build with libsql.

When moving the Connection::prepare call inside the loop it does the right thing. But that's really not how I would expect prepared statements to work.

[bikeshedder]

When I remove the PRIMARY KEY constraint from the fqdn column and run the code I end up with the following DB contents:

$ sqlite3 example.db "SELECT * FROM domain"
example.com
example.com

[bikeshedder]

Here are two unit tests:

#[tokio::test]
async fn test_reuse_statement_insert() {
    let database = libsql::Builder::new_local(":memory:").build().await.unwrap();
    let conn = database.connect().unwrap();
    conn.execute_batch("CREATE TABLE thing (name TEXT NOT NULL PRIMARY KEY)").await.unwrap();
    let stmt = conn.prepare("INSERT INTO thing VALUES (?1)").await.unwrap();
    for name in ["a", "b"] {
        stmt.execute([name]).await.unwrap();
    }
}

#[tokio::test]
async fn test_reuse_statement_select() {
    let database = libsql::Builder::new_local(":memory:").build().await.unwrap();
    let conn = database.connect().unwrap();
    let mut stmt = conn.prepare("SELECT (?1)").await.unwrap();
    for name in ["a", "b"] {
        let row = stmt.query_row([name]).await.unwrap();
        let value = row.get_str(0).unwrap();
        assert_eq!(name, value);
    }
}