[BATCH] AUTO_INCREMENT double jumps when inserting int to a varchar column type followed by a string on the last row

[mavyfaby]

The problem

As per the title

The table

CREATE TABLE my_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    other_id INT NOT NULL,
    name VARCHAR(32) NOT NULL,
    value VARCHAR(32) NOT NULL
);

Consider this data

const data = [
    [1, "1.0", 3],
    [1, "2.0", 5],
    [1, "3.0", 6],
    [1, "4.0", 7],
    [1, "5.0", "im a string"],
];

Insertion process

await conn.batch("INSERT INTO my_table (other_id, name, value) VALUES (?, ?, ?)", data);

Result

Current result

The last row auto increment ID doubled, in this case it's 8 (which should be 5)

Expected result

[mavyfaby]

:))