0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 20:20:20 +00:00
ad hoc ad79ef48a2
libsql wal tests (#1408)
* add tests

* add bench
2024-05-24 13:59:17 +00:00

65 lines
1.7 KiB
Plaintext

CREATE TABLE t1(a, b, c);
ATTACH 'test.db2' AS aux;
CREATE TABLE aux.t2(d, e, f);
PRAGMA table_info = t1
PRAGMA table_info = t2
PRAGMA table_info(t1)
PRAGMA table_info(t2)
CREATE TABLE t1(a, b, c);
ATTACH 'test.db2' AS aux;
CREATE TABLE aux.t2(d, e, f);
SELECT * FROM pragma_table_info('t1')
SELECT * FROM pragma_table_info('t2')
SELECT * FROM pragma_table_info('t1')
SELECT * FROM pragma_table_info('t2')
CREATE TABLE t1(a, b, c);
CREATE INDEX i1 ON t1(b);
ATTACH 'test.db2' AS aux;
CREATE TABLE aux.t2(d, e, f);
CREATE INDEX aux.i2 ON t2(e);
SELECT * FROM pragma_index_info('i1')
SELECT * FROM pragma_index_info('i2')
SELECT * FROM pragma_index_info('i1')
SELECT * FROM pragma_index_info('i2')
CREATE INDEX main.i1 ON t1(b, c);
CREATE INDEX aux.i2 ON t2(e, f);
SELECT * FROM pragma_index_list('t1')
SELECT * FROM pragma_index_list('t2')
SELECT * FROM pragma_index_list('t1')
SELECT * FROM pragma_index_list('t2')
CREATE UNIQUE INDEX main.i1 ON t1(a);
CREATE UNIQUE INDEX aux.i2 ON t2(d);
CREATE TABLE main.c1 (a, b, c REFERENCES t1(a));
CREATE TABLE aux.c2 (d, e, r REFERENCES t2(d));
SELECT * FROM pragma_foreign_key_list('c1')
SELECT * FROM pragma_foreign_key_list('c2')
SELECT * FROM pragma_foreign_key_list('c1')
SELECT * FROM pragma_foreign_key_list('c2')
CREATE TABLE main.c1 (a, b, c REFERENCES t1(a));
CREATE TABLE aux.c2 (d, e, r REFERENCES t2(d));
INSERT INTO main.c1 VALUES(1, 2, 3);
INSERT INTO aux.c2 VALUES(4, 5, 6);
pragma foreign_key_check('c1')
pragma foreign_key_check('c2')
pragma foreign_key_check('c1')
CREATE TABLE t4(a DEFAULT 'abc' /* comment */, b DEFAULT -1 -- comment
, c DEFAULT +4.0 /* another comment */
);
PRAGMA table_info = t4;