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


    CREATE TABLE t(a);
    CREATE INDEX ta ON t(a);
    INSERT INTO t(a) VALUES(1),(2);
    SELECT * FROM t ORDER BY a;
    SELECT * FROM t WHERE a<2 OR a<3 ORDER BY a;
    PRAGMA count_changes=ON;
    DELETE FROM t WHERE a<2 OR a<3;
    SELECT * FROM t;
    PRAGMA count_changes=OFF;
    DROP TABLE t;
  

    CREATE TABLE t(a);
    CREATE INDEX ta ON t(a);
    INSERT INTO t(a) VALUES(1),(2);
    SELECT * FROM t ORDER BY a;
    SELECT * FROM t WHERE a<2 OR a<3 ORDER BY a;
    PRAGMA count_changes=ON;
    DELETE FROM t WHERE a<2 OR a<3;
    SELECT * FROM t;
    PRAGMA count_changes=OFF;
    DROP TABLE t;
  

  CREATE TABLE t301 (
      c8 INTEGER PRIMARY KEY,
      c6 INTEGER,
      c4 INTEGER,
      c7 INTEGER,
      FOREIGN KEY (c4) REFERENCES series(c4)
  );
  CREATE INDEX t301_c6 on t301(c6);
  CREATE INDEX t301_c4 on t301(c4);
  CREATE INDEX t301_c7 on t301(c7);
  
  CREATE TABLE t302 (
      c1 INTEGER PRIMARY KEY,
      c8 INTEGER,
      c5 INTEGER,
      c3 INTEGER,
      c2 INTEGER,
      c4 INTEGER,
      FOREIGN KEY (c8) REFERENCES t301(c8)
  );
  CREATE INDEX t302_c3 on t302(c3);
  CREATE INDEX t302_c8_c3 on t302(c8, c3);
  CREATE INDEX t302_c5 on t302(c5);


  CREATE TABLE t0(w);
  INSERT INTO t0(w) VALUES(1);
  CREATE TABLE t1(x INT, y INT PRIMARY KEY, z); 
  INSERT INTO t1 VALUES(0,111,222);
  CREATE INDEX t1zxy ON t1(z,x,y);
  SELECT y FROM t1
   WHERE (z=222 OR y=111)
     AND (false OR EXISTS(SELECT 1 FROM t0 WHERE t1.y));