mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
29 lines
428 B
Plaintext
29 lines
428 B
Plaintext
|
|
CREATE VIRTUAL TABLE f1 USING fts3;
|
|
INSERT INTO f1 VALUES('a b c');
|
|
|
|
|
|
BEGIN;
|
|
INSERT INTO f1 VALUES('d e f');
|
|
SAVEPOINT one;
|
|
INSERT INTO f1 VALUES('g h i');
|
|
DROP TABLE f1;
|
|
ROLLBACK TO one;
|
|
COMMIT;
|
|
|
|
|
|
SELECT * FROM f1;
|
|
|
|
|
|
BEGIN;
|
|
INSERT INTO f1 VALUES('g h i');
|
|
SAVEPOINT one;
|
|
INSERT INTO f1 VALUES('j k l');
|
|
DROP TABLE f1;
|
|
RELEASE one;
|
|
ROLLBACK;
|
|
|
|
|
|
SELECT * FROM f1;
|
|
|