SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select sqlite_version();

sqlite_version()

3.39.1

CREATE TABLE t(id INTEGER PRIMARY KEY AUTOINCREMENT, a VARCHAR);
✓
INSERT INTO t(a) VALUES('u'), ('v');
✓
SELECT * FROM t;

id
a

1
u

2
v

SELECT * FROM SQLITE_SEQUENCE;

name
seq

t
2

BEGIN;
✓
INSERT INTO t(a) VALUES('foo');
✓
SELECT * FROM SQLITE_SEQUENCE;

name
seq

t
3

SAVEPOINT x;
✓
INSERT INTO t(a) VALUES('foo');
✓
SELECT * FROM SQLITE_SEQUENCE; -- expected AI = 4 - ok

name
seq

t
4

ROLLBACK TO SAVEPOINT x;
✓
SELECT * FROM SQLITE_SEQUENCE; -- expected AI = 4

name
seq

t
3

ROLLBACK;
✓
SELECT * FROM SQLITE_SEQUENCE; -- expected AI = 4;

name
seq

t
2