mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 07:29:41 +00:00
ad79ef48a2
* add tests * add bench
14 lines
522 B
Plaintext
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'
|