René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite: re-filtering a virtual-table cursor skips generator cleanup","articleBody":"### Version\n\nmain\n\n### Platform\n\n```text\nN/A\n```\n\n### Subsystem\n\nsqlite\n\n### What steps will reproduce the bug?\n\n```js\nimport { DatabaseSync } from 'node:sqlite';\n\nconst db = new DatabaseSync(':memory:');\n\nlet cleaned = 0;\ndb.createModule('m', {\n  columns: [{ name: 'input', type: 'INTEGER', hidden: true }],\n  *rows(input) {\n    try { yield [input]; } finally { cleaned++; }\n  },\n});\n\ndb.exec('CREATE TABLE t(a); INSERT INTO t VALUES (1), (2)');\ndb.prepare('SELECT a FROM t WHERE EXISTS(SELECT 1 FROM m(t.a))').all();\nconsole.log(cleaned);  // 1, expected 2\n```\n\n### How often does it reproduce? Is there a required condition?\n\nAlways\n\n### What is the expected behavior? Why is that the expected behavior?\n\nBoth `rows()` calls (for `t.a = 1` and `t.a = 2`) run their `finally`, so `cleaned` is `2`.\n\n### What do you see instead?\n\n`cleaned` is `1`; the first generator is suspended and discarded by the re-filter and its `finally` never runs.\n\n### Additional information\n\n_No response_","author":{"url":"https://github.com/trivikr","@type":"Person","name":"trivikr"},"datePublished":"2026-09-22T05:28:13Z","url":"https://github.com/nodejs/node/issues/66193"}