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

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

15 lines
621 B
Plaintext

CREATE VIRTUAL TABLE t2 USING FTS4;
INSERT INTO t2 VALUES('it was the first time in history');
UPDATE t2_content SET c0content = X'1234'
DROP TABLE t2
CREATE VIRTUAL TABLE t3 USING FTS4(a, b);
INSERT INTO t3 VALUES('no gestures', 'another intriguing discovery by observing the hand gestures (called beats) people make while speaking. Research has shown that such gestures do more than add visual emphasis to our words (many people gesture while they''re on the telephone, for example); it seems they actually help our brains find words');
CREATE VIRTUAL TABLE ft4 USING fts4(x);
CREATE TABLE t4(x);