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
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118


  WITH c(x) AS (VALUES('{a:5,b:6

  SELECT '[7,null,{a:5,b:6

  SELECT '{ $123 : 789 

  SELECT '{ _123$xyz : 789 

  SELECT '{ MNO_123$xyz : 789 

  SELECT json('{ MNO_123$xyz : 789 

  SELECT '{ MNO_123æxyz : 789 

  WITH c(x) AS (VALUES('{"a":5, "b":6, 

  SELECT '{a:5, b:6 , 

  WITH c(x) AS (VALUES('[5, 6,]'))
  SELECT x->>1, json(x), json_valid(x), NOT json_error_position(x) FROM c;


  SELECT '[5, 6 , ]'->>1;


  WITH c(x) AS (VALUES('{"a": ''abcd''

  SELECT '{b: 123, ''a'': ''ab\''cd''

  WITH c(x) AS (VALUES('{a: "abc'||char(0x5c,0x0a)||'xyz"

  SELECT ('{a: "abc'||char(0x5c,0x0d)||'xyz"

  SELECT ('{a: "abc'||char(0x5c,0x0d,0x0a)||'xyz"

  SELECT ('{a: "abc'||char(0x5c,0x2028)||'xyz"

  SELECT ('{a: "abc'||char(0x5c,0x2029)||'xyz"

  SELECT ('{a: "abc'||char(0x5c,0x27)||'xyz"

  SELECT ('{a: "abc'||char(0x5c,0x22)||'xyz"

  SELECT ('{a: "abc'||char(0x5c,0x5c)||'xyz"

  SELECT hex(('{a: "abc\bxyz"

  SELECT hex(('{a: "abc\f\n\r\t\vxyz"

  SELECT hex(('{a: "abc\0xyz"

  SELECT '{a: "abc\x35\x4f\x6Exyz"

  SELECT '{a: "\x6a\x6A\x6b\x6B\x6c\x6C\x6d\x6D\x6e\x6E\x6f\x6F"

  SELECT '{a: 0x0

  SELECT '{a: -0x0

  SELECT '{a: +0x0

  SELECT '{a: 0xabcdef

  SELECT '{a: -0xaBcDeF

  SELECT '{a: +0xABCDEF

  WITH c(x) AS (VALUES('{x: 4.

  WITH c(x) AS (VALUES('{x: +4.

  WITH c(x) AS (VALUES('{x: -4.

  WITH c(x) AS (VALUES('{x: .5

  WITH c(x) AS (VALUES('{x: -.5

  WITH c(x) AS (VALUES('{x: +.5

  WITH c(x) AS (VALUES('{x: 4.e0

  WITH c(x) AS (VALUES('{x: +4.e1

  WITH c(x) AS (VALUES('{x: -4.e2

  WITH c(x) AS (VALUES('{x: .5e3

  WITH c(x) AS (VALUES('{x: -.5e-1

  WITH c(x) AS (VALUES('{x: +.5e-2

  WITH c(x) AS (VALUES('{x: +Infinity

  WITH c(x) AS (VALUES('{x: -Infinity

  WITH c(x) AS (VALUES('{x: Infinity

  WITH c(x) AS (VALUES('{x: NaN

  SELECT '{a: +123

  SELECT ' /* abc */ { /*def*/ aaa /* xyz */ : // to the end of line
          123 /* xyz */ , /* 123 */ 

  SELECT (char(0x09,0x0a,0x0b,0x0c,0x0d,0x20,0xa0,0x2028,0x2029)
          || '{a: "xyz"

  SELECT ('{a:' || char(0x09,0x0a,0x0b,0x0c,0x0d,0x20,0xa0,0x2028,0x2029)
          || '"xyz"

  SELECT (char(0x1680,0x2000,0x2001,0x2002,0x2003,0x2004,0x2005,
               0x2006,0x2007,0x2008,0x2009,0x200a,0x3000,0xfeff)
          || '{a: "xyz"

  SELECT ('{a: ' ||char(0x1680,0x2000,0x2001,0x2002,0x2003,0x2004,0x2005,
                        0x2006,0x2007,0x2008,0x2009,0x200a,0x3000,0xfeff)
          || ' "xyz"