better-sqlite3 trigger bug

build_schema.sql

CREATE TABLE Test (
	id integer primary key autoincrement,
	data text not null,
	_last_updated datetime default current_timestamp
);

CREATE TRIGGER update_test_timestamp
AFTER UPDATE ON Test BEGIN
UPDATE Test SET _last_updated = datetime("now") WHERE id = new.id;
END;

INSERT INTO Test(data) VALUES("blah blah blah");

failToUpdateDB.js

const connect = require('better-sqlite3')

const db = connect('test.db', { fileMustExist: true })

db.prepare('UPDATE Test SET data=? WHERE id=?').run('blah blah 3.0', 1)

package.json

{
  "name": "sqlite-bug",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "",
  "license": "ISC",
  "dependencies": {
    "better-sqlite3": "^7.0.1"
  }
}