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
93
94
95
96
97
98
99


  CREATE TABLE t1(
    xi INTEGER,
    xr REAL,
    xb BLOB,
    xn NUMERIC,
    xt TEXT
  );
  INSERT INTO t1(rowid,xi,xr,xb,xn,xt) VALUES(1,1,1,1,1,1);
  INSERT INTO t1(rowid,xi,xr,xb,xn,xt) VALUES(2,'2','2','2','2','2');
  INSERT INTO t1(rowid,xi,xr,xb,xn,xt) VALUES(3,'03','03','03','03','03');



  SELECT xi, typeof(xi) FROM t1 ORDER BY rowid;


  SELECT xr, typeof(xr) FROM t1 ORDER BY rowid;


  SELECT xb, typeof(xb) FROM t1 ORDER BY rowid;


  SELECT xn, typeof(xn) FROM t1 ORDER BY rowid;


  SELECT xt, typeof(xt) FROM t1 ORDER BY rowid;


  SELECT rowid, xi==xt, xi==xb, xi==+xt FROM t1 ORDER BY rowid;


  SELECT rowid, xr==xt, xr==xb, xr==+xt FROM t1 ORDER BY rowid;


  SELECT rowid, xn==xt, xn==xb, xn==+xt FROM t1 ORDER BY rowid;


  SELECT rowid, xt==+xi, xt==xi, xt==xb FROM t1 ORDER BY rowid;


  CREATE TABLE ttt(c0, c1);
  CREATE INDEX ii ON ttt(CAST(c0 AS NUMERIC)); 
  INSERT INTO ttt VALUES('abc', '-1');


  SELECT * FROM ttt WHERE CAST(c0 AS NUMERIC) > c1 GROUP BY rowid; 


  SELECT * FROM ttt INDEXED BY ii WHERE CAST(c0 AS NUMERIC) > c1 GROUP BY rowid;


  CREATE TABLE t3(a, b, c INTEGER);
  CREATE INDEX t3ac ON t3(a, c-1);
  INSERT INTO t3 VALUES(1, 1, 1);
  INSERT INTO t3 VALUES(2, 1, 0);
  INSERT INTO t3 VALUES(3, 1, 1);
  INSERT INTO t3 VALUES(4, 1, 0);
  INSERT INTO t3 VALUES(5, 1, 1);


  SELECT * FROM t3 WHERE c='0' ORDER BY a;


  DROP TABLE IF EXISTS t0;
  CREATE TABLE t0(c0 TEXT UNIQUE, c1);
  INSERT INTO t0(c0) VALUES (-1);
  SELECT quote(- x'ce'), quote(t0.c0), quote(- x'ce' >= t0.c0) FROM t0;


  SELECT * FROM t0 WHERE - x'ce' >= t0.c0;


  SELECT quote(+-+x'ce'), quote(t0.c0), quote(+-+x'ce' >= t0.c0) FROM t0;


  SELECT * FROM t0 WHERE +-+x'ce' >= t0.c0;


  SELECT quote(- 'ce'), quote(t0.c0), quote(- 'ce' >= t0.c0) FROM t0;


  SELECT * FROM t0 WHERE - 'ce' >= t0.c0;


  SELECT quote(+-+'ce'), quote(t0.c0), quote(+-+'ce' >= t0.c0) FROM t0;


  SELECT * FROM t0 WHERE +-+'ce' >= t0.c0;


    DROP TABLE IF EXISTS t0;
    CREATE TABLE t0(c0 REAL UNIQUE);
    INSERT INTO t0(c0) VALUES (3175546974276630385);
    SELECT 3175546974276630385 < c0 FROM t0;
  

    SELECT 1 FROM t0 WHERE 3175546974276630385 < c0;