只報改一行，為何漏了兩個觸發寫入？

先核來源與已訂規則

本例 UPDATE 改一父行，觸發程序再插兩子行。語句直接變更數不包括這些間接寫入。此小結構的受影響行總數，須直接數加真正子行增量；所附 fanout 只有 0 或 2。

已填假設輸入
紀錄	輸入 JSON
原例輸入	{"id":1,"fanout":2}

下載可編輯 CSV ↓

比較兩條實際路徑

直接數 1 本身按窄意思是對，拿來代表全部結果才錯。更正是 1+2=3，並列出兩個實際子行。

錯誤與更正路徑的輸出
路徑	輸出 JSON
錯誤路徑	{"directChanges":1,"children":[{"n":1},{"n":2}],"reportedEffects":1}
更正路徑	{"directChanges":1,"children":[{"n":1},{"n":2}],"reportedEffects":3}

下載可編輯 CSV ↓

本地 Node.js 程序：22.23.3 或 24.14.1

import {DatabaseSync} from 'node:sqlite';
import {TextDecoder} from 'node:util';
import {inflateSync} from 'node:zlib';
import {posix} from 'node:path';
import {createHash} from 'node:crypto';
const rows=(db,sql)=>db.prepare(sql).all().map(r=>({...r}));
const failed=(action)=>{try{action();return null;}catch(e){return {code:e.errcode??e.code??e.name};}};

import assert from 'node:assert/strict';
const run=function run(i,corrected=true){
    const db=new DatabaseSync(':memory:');try{db.exec('CREATE TABLE parent(id INTEGER PRIMARY KEY,value INTEGER);CREATE TABLE child(n INTEGER);INSERT INTO parent VALUES(1,0);');
      if(i.fanout===2)db.exec('CREATE TRIGGER fanout AFTER UPDATE ON parent BEGIN INSERT INTO child VALUES(1);INSERT INTO child VALUES(2);END;');
      const before=db.prepare('SELECT COUNT(*) AS n FROM child').get().n;
      const directChanges=Number(db.prepare('UPDATE parent SET value=value+1 WHERE id=?').run(i.id).changes);
      const children=rows(db,'SELECT * FROM child ORDER BY n');
      return {directChanges,children,reportedEffects:directChanges+(corrected?children.length-before:0)};
    }finally{db.close();}
  };
const cases=[{"label":"misleading base","input":{"id":1,"fanout":2},"expected":{"directChanges":1,"children":[{"n":1},{"n":2}],"reportedEffects":1},"corrected":false},{"label":"corrected base","input":{"id":1,"fanout":2},"expected":{"directChanges":1,"children":[{"n":1},{"n":2}],"reportedEffects":3},"corrected":true},{"label":"no triggered writes","input":{"id":1,"fanout":0},"expected":{"directChanges":1,"children":[],"reportedEffects":1},"corrected":true},{"label":"no matched direct row","input":{"id":2,"fanout":2},"expected":{"directChanges":0,"children":[],"reportedEffects":0},"corrected":true}];
for(const test of cases){
  const actual=run(test.input,test.corrected);
  assert.deepEqual(actual,test.expected,test.label);
  console.log(test.label,actual);
}

下載可執行例子 ↓

下次載入前核邊界

沒有觸發寫入就總 1；父未配對則直接、子寫入均沒有，總 0。

可編輯邊界紀錄及預期輸出
情況	輸入 JSON	預期輸出 JSON
沒有觸發子寫入	{"id":1,"fanout":0}	{"directChanges":1,"children":[],"reportedEffects":1}
沒有配對父行	{"id":2,"fanout":2}	{"directChanges":0,"children":[],"reportedEffects":0}

下載可編輯 CSV ↓

原例整體受影響行數應多少？

查看參考答案

3，一父行直接更新加兩子行插入；directChanges1 保作另有範圍的數字。

先核來源與已訂規則

比較兩條實際路徑

下次載入前核邊界

相關資源