sqlite3_commit_hook bugs?
(1) By anonymous on 2021-09-24 14:01:59 [link] [source]
I try use sqlite3_commit_hook to log query, get this issue:
every auto commit transaction made the callback execute once except your next call is BEGIN TRANSACTION.
For example:
INSERT INTO t(v) VALUES(1);
INSERT INTO t(v) VALUES(2);
BEGIN TRANSACTION;
INSERT INTO t(v) VALUES(3);
INSERT INTO t(v) VALUES(4);
COMMIT;
The callback should fired 3 times, but it only fire 2 times. the second query is skiped.
Test on master branch.
(2) By anonymous on 2021-09-24 15:09:39 in reply to 1 [source]
Sorry, this is my mistake, I use it wrong.