sqlite: statement iterator state is corrupted by coincident statement execution #61819

const { DatabaseSync } = require('node:sqlite');
const db = new DatabaseSync(':memory:')
db.exec('CREATE TABLE test (value INTEGER NOT NULL)');
for (let i = 0; i < 10; i++) {
  db.prepare('INSERT INTO test (value) VALUES (?)').run(i);
}

const stmt = db.prepare('SELECT * FROM test');

const it = stmt.iterate();
it.next().value; // { value: 0 }
it.next().value; // { value: 1 }
it.next().value; // { value: 2 }

// resets, executes and re-resets statement
stmt.get(); // { value: 0 }

// sqlite3_step restarts from beginning of result
it.next().value; // { value: 0 }
it.next().value; // { value: 1 }
it.next().value; // { value: 2 }

// these will race
const it2 = stmt.iterate();
it.next().value; // { value: 0 }
it2.next().value; // { value: 1 }
it.next().value; // { value: 2 }
it2.next().value; // { value: 3 }