forked from codeschool/sqlite-parser
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathbind-1.sql
More file actions
64 lines (63 loc) · 1.75 KB
/
bind-1.sql
File metadata and controls
64 lines (63 loc) · 1.75 KB
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
-- original: bind.test
-- credit: http://www.sqlite.org/src/tree?ci=trunk&name=test
CREATE TABLE t1(a,b,c)
;SELECT rowid, * FROM t1
;SELECT rowid, * FROM t1
;SELECT rowid, * FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT rowid, * FROM t1
;DELETE FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT rowid, * FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;DELETE FROM t1
;SELECT * FROM t1
;PRAGMA encoding
;SELECT hex(a), hex(b), hex(c) FROM t1
;SELECT hex(a), hex(b), hex(c) FROM t1
;SELECT hex(a), hex(b), hex(c) FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;SELECT rowid, * FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;SELECT * FROM t1
;SELECT hex(a), hex(b), hex(c) FROM t1
;SELECT hex(a), hex(b), hex(c) FROM t1
;SELECT hex(a), hex(b), hex(c) FROM t1
;SELECT typeof(a), typeof(b), typeof(c) FROM t1
;DELETE FROM t1
;CREATE TABLE t2(a,b,c,d,e,f)
;SELECT * FROM t2
;SELECT * FROM t2
;pragma encoding
;CREATE TABLE t3(x BLOB)
;SELECT typeof(x), length(x), quote(x),
length(cast(x AS BLOB)), quote(cast(x AS BLOB)) FROM t3
;SELECT quote(cast(x_coalesce(x) AS blob)) FROM t3
;CREATE TABLE t4(a,b,c,d,e,f,g,h)
;SELECT * FROM t4
;DELETE FROM t4
;SELECT * FROM t4
;DELETE FROM t4
;SELECT * FROM t4
;DELETE FROM t4
;SELECT * FROM t4;