libsql-wal 0.1.0-alpha.1

wal implementation for libsql
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92


  CREATE TABLE cc(a, b, c);

 SELECT name FROM sqlite_master 
 DROP TABLE t1 

  CREATE VIRTUAL TABLE t2 USING fts4(x, y, notindexed=x);

 SELECT x FROM t2 WHERE t2 MATCH '2' 
 SELECT x FROM t2 WHERE t2 MATCH '1' 
 SELECT x FROM t2 WHERE t2 MATCH 'x' 
 SELECT x FROM t2 WHERE t2 MATCH 'x 1' 
 DROP TABLE t2 

  CREATE VIRTUAL TABLE t2 USING fts4(poi, addr, notindexed=poi);
  INSERT INTO t2 VALUES(114, 'x x x');
  INSERT INTO t2 VALUES(X'1234', 'y y y');
  INSERT INTO t2 VALUES(NULL, 'z z z');
  INSERT INTO t2 VALUES(113.2, 'w w w');
  INSERT INTO t2 VALUES('poi', 'v v v');

 SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'x' 
 SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'y' 
 SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'z' 
 SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'w' 
 SELECT typeof(poi) FROM t2 WHERE t2 MATCH 'v' 
 DROP TABLE t2 

  CREATE VIRTUAL TABLE t2 USING fts4(
      notindexed="three", one, two, three, notindexed="one",
  );
  INSERT INTO t2 VALUES('a', 'b', 'c');
  INSERT INTO t2 VALUES('c', 'a', 'b');
  INSERT INTO t2 VALUES('b', 'c', 'a');

 SELECT docid FROM t2 WHERE t2 MATCH 'a' 
 SELECT docid FROM t2 WHERE t2 MATCH 'b' 
 SELECT docid FROM t2 WHERE t2 MATCH 'c' 
 DROP TABLE t2 

  CREATE VIRTUAL TABLE t1 USING fts4(
    poiCategory, poiCategoryId, notindexed=poiCategoryId
  );
  INSERT INTO t1(poiCategory, poiCategoryId) values ('Restaurant', 6021);


  SELECT * FROM t1 WHERE t1 MATCH 'restaurant';


  SELECT * FROM t1 WHERE t1 MATCH 're*';


  SELECT * FROM t1 WHERE t1 MATCH '6021';


  SELECT * FROM t1 WHERE t1 MATCH '60*';


  DROP TABLE t1;
  CREATE VIRTUAL TABLE t1 USING fts4(
    poiCategory, poiCategoryId, notindexed=poiCategory
  );
  INSERT INTO t1(poiCategory, poiCategoryId) values ('Restaurant', 6021);


  SELECT * FROM t1 WHERE t1 MATCH 'restaurant';


  SELECT * FROM t1 WHERE t1 MATCH 're*';


  SELECT * FROM t1 WHERE t1 MATCH '6021';


  SELECT * FROM t1 WHERE t1 MATCH '60*';


  DROP TABLE t1;
  CREATE VIRTUAL TABLE t1 USING fts4(abc, ab, a, notindexed=abc);
  CREATE VIRTUAL TABLE t2 USING fts4(a, ab, abc, notindexed=abc);

  INSERT INTO t1 VALUES('no', 'yes', 'yep');
  INSERT INTO t2 VALUES('yep', 'yes', 'no');

  SELECT count(*) FROM t1 WHERE t1 MATCH 'no';
  SELECT count(*) FROM t1 WHERE t1 MATCH 'yes';
  SELECT count(*) FROM t1 WHERE t1 MATCH 'yep';

  SELECT count(*) FROM t2 WHERE t2 MATCH 'no';
  SELECT count(*) FROM t2 WHERE t2 MATCH 'yes';
  SELECT count(*) FROM t2 WHERE t2 MATCH 'yep';