After line: UPDATE foo SET bar=5678; put this sql command: COMMIT;
If you execute all statements in one sql (except last), they are executed in one transaction. Regards Radovan Adam Goldman je 27.10.2016 ob 11:52 napisal:
Hi, I expected the test case below to print 5679, but it prints 1235 instead. I tested under a few versions including 3.15.0. It's a bit of a corner case and I worked around it in my application, but I guess it's a bug. CREATE TABLE foo (bar INTEGER PRIMARY KEY AUTOINCREMENT); INSERT INTO foo (bar) VALUES(1234); UPDATE foo SET bar=5678; DELETE FROM foo; INSERT INTO foo DEFAULT VALUES; SELECT * FROM foo; -- Adam _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users