René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite: statement iterator state is corrupted by coincident statement execution","articleBody":"Statement iterators that have not finished iterating are not invalidated when the statement is reset.\n\n```js\nconst { DatabaseSync } = require('node:sqlite');\nconst db = new DatabaseSync(':memory:')\ndb.exec('CREATE TABLE test (value INTEGER NOT NULL)');\nfor (let i = 0; i \u003c 10; i++) {\n  db.prepare('INSERT INTO test (value) VALUES (?)').run(i);\n}\n\nconst stmt = db.prepare('SELECT * FROM test');\n\nconst it = stmt.iterate();\nit.next().value; // { value: 0 }\nit.next().value; // { value: 1 }\nit.next().value; // { value: 2 }\n\n// resets, executes and re-resets statement\nstmt.get(); // { value: 0 }\n\n// sqlite3_step restarts from beginning of result\nit.next().value; // { value: 0 }\nit.next().value; // { value: 1 }\nit.next().value; // { value: 2 }\n\n// these will race\nconst it2 = stmt.iterate();\nit.next().value; // { value: 0 }\nit2.next().value; // { value: 1 }\nit.next().value; // { value: 2 }\nit2.next().value; // { value: 3 }\n```\n\nIf the statement iterator is not done and the statement is reset, then the iterator should be invalidated and subsequent calls to `.next()` should throw.","author":{"url":"https://github.com/Renegade334","@type":"Person","name":"Renegade334"},"datePublished":"2026-02-14T17:09:06.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/61819/node/issues/61819"}