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


  CREATE TABLE t0 (c0, c1);
  CREATE INDEX i0 ON t0(c1, c1 + 1 DESC);
  INSERT INTO t0(c0) VALUES (1);


  SELECT MIN(t0.c1), t0.c0 FROM t0 WHERE t0.c1 ISNULL; 


  CREATE TABLE t1 (a, b);
  INSERT INTO t1 VALUES(123, NULL);
  CREATE INDEX i1 ON t1(a, b DESC);


  SELECT MIN(a) FROM t1 WHERE a=123;


  CREATE TABLE t1(a, b, c);
  INSERT INTO t1 VALUES(NULL, 1, 'x');
  CREATE INDEX i1 ON t1(a);


  SELECT min(a), b, c FROM t1 WHERE c='x';


  INSERT INTO t1 VALUES(1,    2, 'y');


  SELECT min(a), b, c FROM t1 WHERE c='x';


  CREATE TABLE t0(c0 UNIQUE, c1);
  INSERT INTO t0(c1) VALUES (0);
  INSERT INTO t0(c0) VALUES (0);
  CREATE VIEW v0(c0, c1) AS 
      SELECT t0.c1, t0.c0 FROM t0 WHERE CAST(t0.rowid AS INT) = 1;


  SELECT c0, c1 FROM v0;


  SELECT v0.c0, MIN(v0.c1) FROM v0;