mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-05-22 07:48:15 +00:00
37 lines
573 B
Plaintext
37 lines
573 B
Plaintext
|
|
||
|
|
PRAGMA data_version;
|
||
|
|
|
||
|
|
|
||
|
|
PRAGMA temp.data_version;
|
||
|
|
|
||
|
|
|
||
|
|
PRAGMA main.data_version=1234;
|
||
|
|
PRAGMA main.data_version;
|
||
|
|
|
||
|
|
|
||
|
|
PRAGMA data_version;
|
||
|
|
BEGIN IMMEDIATE;
|
||
|
|
PRAGMA data_version;
|
||
|
|
CREATE TABLE t1(a);
|
||
|
|
INSERT INTO t1 VALUES(100),(200),(300);
|
||
|
|
PRAGMA data_version;
|
||
|
|
COMMIT;
|
||
|
|
SELECT * FROM t1;
|
||
|
|
PRAGMA data_version;
|
||
|
|
|
||
|
|
|
||
|
|
PRAGMA data_version;
|
||
|
|
BEGIN IMMEDIATE;
|
||
|
|
PRAGMA data_version;
|
||
|
|
INSERT INTO t1 VALUES(400),(500);
|
||
|
|
PRAGMA data_version;
|
||
|
|
COMMIT;
|
||
|
|
SELECT * FROM t1;
|
||
|
|
PRAGMA data_version;
|
||
|
|
PRAGMA shrink_memory;
|
||
|
|
|
||
|
|
|
||
|
|
SELECT * FROM t1;
|
||
|
|
PRAGMA data_version;
|
||
|
|
|