0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-12 11:39:28 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/pragma3.test
2024-05-27 12:59:10 +02:00

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;