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

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

14 lines
522 B
Plaintext

CREATE VIRTUAL TABLE t1 USING fts4;
SELECT docid FROM t1 WHERE docid = 5
SELECT docid FROM t1 WHERE docid = '5'
SELECT docid FROM t1 WHERE docid = +5
SELECT docid FROM t1 WHERE docid = +'5'
SELECT docid FROM t1 WHERE docid < 5
SELECT docid FROM t1 WHERE docid < '5'
SELECT rowid FROM t1 WHERE rowid = 5
SELECT rowid FROM t1 WHERE rowid = '5'
SELECT rowid FROM t1 WHERE rowid = +5
SELECT rowid FROM t1 WHERE rowid = +'5'
SELECT rowid FROM t1 WHERE rowid < 5
SELECT rowid FROM t1 WHERE rowid < '5'