| /external/chromium_org/third_party/sqlite/src/test/ |
| D | e_createtable.test | 28 # e_createtable-2.*: Test "CREATE TABLE AS" statements.
41 # CREATE TABLE t1(x);
42 # CREATE TEMP TABLE t2(x);
43 # CREATE TEMP TABLE t3(x);
66 1 "CREATE TABLE t1(c1 one)" {}
67 2 "CREATE TABLE t1(c1 one two)" {}
68 3 "CREATE TABLE t1(c1 one two three)" {}
69 4 "CREATE TABLE t1(c1 one two three four)" {}
70 5 "CREATE TABLE t1(c1 one two three four(14))" {}
71 6 "CREATE TABLE t1(c1 one two three four(14, 22))" {}
[all …]
|
| D | fkey_malloc.test | 25 CREATE TABLE t1(a PRIMARY KEY, b UNIQUE);
26 CREATE TABLE t2(x REFERENCES t1 ON UPDATE CASCADE ON DELETE CASCADE);
36 CREATE TABLE t1(a, b, UNIQUE(a, b));
38 CREATE TABLE t2(x, y,
53 CREATE TABLE t1(x INTEGER PRIMARY KEY);
54 CREATE TABLE t2(y DEFAULT 14 REFERENCES t1(x) ON UPDATE SET DEFAULT);
55 CREATE TABLE t3(y REFERENCES t1 ON UPDATE SET NULL);
79 CREATE TABLE t1(x INTEGER PRIMARY KEY, y UNIQUE);
80 CREATE TABLE t2(z REFERENCES t1(x), a REFERENCES t1(y));
81 CREATE TABLE t3(x);
[all …]
|
| D | schema3.test | 42 1 { CREATE TABLE t1(a, b) } { SELECT * FROM t1 }
43 2 { CREATE TABLE t2(a, b) } { UPDATE t2 SET a = b }
44 3 { CREATE TABLE t3(a, b) } { DELETE FROM t3 }
45 4 { CREATE TABLE t4(a, b) } { INSERT INTO t4 VALUES(1, 2) }
46 5 { CREATE TABLE t5(a, b) } { DROP TABLE t5 }
47 6 { CREATE TABLE t6(a, b) } { CREATE INDEX i1 ON t6(a) }
54 12 { ALTER TABLE t6 ADD COLUMN c } { CREATE INDEX i2 ON t6(c) }
56 CREATE TRIGGER tr1 AFTER UPDATE OF d ON t6 BEGIN
61 14 { CREATE INDEX i3 ON t1(a) } { DROP INDEX i3 }
62 15 { CREATE INDEX i4 ON t2(a) } {
[all …]
|
| D | exists.test | 25 # This block of tests is targeted at CREATE XXX IF NOT EXISTS statements.
33 sql2 { CREATE TABLE t1(x) }
34 sql1 { CREATE TABLE IF NOT EXISTS t1(a, b) }
36 sql1 { CREATE TABLE IF NOT EXISTS t1(a, b) }
41 sql2 { CREATE TABLE t2(x) }
42 sql1 { CREATE TABLE IF NOT EXISTS t2 AS SELECT * FROM t1 }
44 sql1 { CREATE TABLE IF NOT EXISTS t2 AS SELECT * FROM t1 }
52 sql2 { CREATE INDEX i1 ON t1(a) }
53 sql1 { CREATE INDEX IF NOT EXISTS i1 ON t1(a, b) }
55 sql1 { CREATE INDEX IF NOT EXISTS i1 ON t1(a, b) }
[all …]
|
| D | fkey1.test | 28 CREATE TABLE t1(
40 CREATE TABLE t2(
48 CREATE TABLE t3(
58 CREATE TABLE t4(a integer primary key);
59 CREATE TABLE t5(x references t4);
60 CREATE TABLE t6(x references t4);
61 CREATE TABLE t7(x references t4);
62 CREATE TABLE t8(x references t4);
63 CREATE TABLE t9(x references t4);
64 CREATE TABLE t10(x references t4);
[all …]
|
| D | schema4.test | 30 CREATE TABLE log(x, a, b);
31 CREATE TABLE tbl(a, b);
33 CREATE TABLE t1(a, b);
34 CREATE VIEW v1 AS SELECT * FROM tbl;
35 CREATE INDEX i1 ON tbl(a);
39 CREATE TRIGGER t1 AFTER INSERT ON tbl BEGIN
42 CREATE TRIGGER v1 AFTER UPDATE ON tbl BEGIN
45 CREATE TRIGGER i1 AFTER DELETE ON tbl BEGIN
84 CREATE TABLE t1(a, b);
85 CREATE VIEW v1 AS SELECT * FROM tbl;
[all …]
|
| D | recover0.test | 28 CREATE TABLE backing (t TEXT);
31 CREATE TABLE backing2 (id INTEGER PRIMARY KEY, t TEXT);
38 CREATE VIRTUAL TABLE temp.syntax USING recover(
49 CREATE VIRTUAL TABLE temp.syntax USING recover(
60 CREATE VIRTUAL TABLE temp.syntax USING recover(
75 CREATE VIRTUAL TABLE syntax USING recover(
86 CREATE VIRTUAL TABLE temp.syntax USING recover(
97 CREATE VIRTUAL TABLE temp.syntax USING recover(
108 CREATE VIRTUAL TABLE temp.syntax USING recover(
119 CREATE VIRTUAL TABLE temp.syntax USING recover(
[all …]
|
| D | table.test | 12 # focus of this file is testing the CREATE TABLE statement.
23 CREATE TABLE test1 (
31 } {{CREATE TABLE test1 (
71 execsql {CREATE TABLE "create" (f1 int)}
79 execsql {CREATE TABLE test1("f1 ho" int)}
92 execsql {CREATE TABLE TEST2(one text)}
93 catchsql {CREATE TABLE test2(two text default 'hi')}
96 catchsql {CREATE TABLE "test2" (two)}
99 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
105 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
[all …]
|
| D | trigger7.test | 29 CREATE TABLE t1(x, y);
32 CREATE TEMP TRIGGER main.r1 AFTER INSERT ON t1 BEGIN
39 CREATE TRIGGER not_a_db.r1 AFTER INSERT ON t1 BEGIN
52 CREATE TRIGGER r1 AFTER UPDATE OF x ON t1 BEGIN
55 CREATE TRIGGER r2 AFTER UPDATE OF y ON t1 BEGIN
89 CREATE TABLE t2(x,y,z);
90 CREATE TRIGGER t2r1 AFTER INSERT ON t2 BEGIN SELECT 1; END;
91 CREATE TRIGGER t2r2 BEFORE INSERT ON t2 BEGIN SELECT 1; END;
92 CREATE TRIGGER t2r3 AFTER UPDATE ON t2 BEGIN SELECT 1; END;
93 CREATE TRIGGER t2r4 BEFORE UPDATE ON t2 BEGIN SELECT 1; END;
[all …]
|
| D | triggerD.test | 30 CREATE TABLE t1(rowid, oid, _rowid_, x);
31 CREATE TABLE log(a,b,c,d,e);
32 CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
35 CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
38 CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
42 CREATE TRIGGER r4 AFTER UPDATE ON t1 BEGIN
46 CREATE TRIGGER r5 BEFORE DELETE ON t1 BEGIN
49 CREATE TRIGGER r6 AFTER DELETE ON t1 BEGIN
81 CREATE TABLE t1(w,x,y,z);
82 CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
[all …]
|
| D | corrupt2.test | 37 CREATE TABLE abc(a, b, c);
133 CREATE INDEX a1 ON abc(a);
134 CREATE INDEX a2 ON abc(b);
137 SET name = 'a3', sql = 'CREATE INDEX a3' || substr(sql, 16, 10000)
161 CREATE TABLE t1(a, b, c);
162 CREATE TABLE t2(a, b, c);
211 CREATE TABLE t1(a, b, c);
212 CREATE TABLE t2(a, b, c);
291 CREATE TABLE t1(a, b);
308 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
[all …]
|
| D | fkey2.test | 92 CREATE TABLE t1(a PRIMARY KEY, b);
93 CREATE TABLE t2(c REFERENCES t1(a) /D/ , d);
95 CREATE TABLE t3(a PRIMARY KEY, b);
96 CREATE TABLE t4(c REFERENCES t3 /D/, d);
98 CREATE TABLE t7(a, b INTEGER PRIMARY KEY);
99 CREATE TABLE t8(c REFERENCES t7 /D/, d);
101 CREATE TABLE t9(a REFERENCES nosuchtable, b);
102 CREATE TABLE t10(a REFERENCES t9(c) /D/, b);
190 CREATE TABLE i(i INTEGER PRIMARY KEY);
191 CREATE TABLE j(j REFERENCES i);
[all …]
|
| D | view.test | 26 CREATE TABLE t1(a,b,c);
37 CREATE VIEW IF NOT EXISTS v1 AS SELECT a,b FROM t1;
49 CREATE VIEW v1 AS SELECT a,b FROM t1;
68 CREATE VIEW v1 AS SELECT a,b FROM t1;
80 CREATE TABLE t1(x,a,b,c);
97 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
145 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
151 CREATE VIEW v1b AS SELECT t1.a, b+c, t1.c FROM t1;
159 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
165 CREATE VIEW v4 AS
[all …]
|
| D | pcache.test | 54 CREATE TABLE t1(a, b, c);
55 CREATE TABLE t2(a, b, c);
56 CREATE TABLE t3(a, b, c);
57 CREATE TABLE t4(a, b, c);
58 CREATE TABLE t5(a, b, c);
65 CREATE TABLE t6(a, b, c);
66 CREATE TABLE t7(a, b, c);
67 CREATE TABLE t8(a, b, c);
68 CREATE TABLE t9(a, b, c);
93 CREATE INDEX i1 ON t1(a, b);
[all …]
|
| D | trigger1.test | 13 # 1. CREATE and DROP TRIGGER tests
39 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
48 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
56 CREATE TABLE t1(a);
60 CREATE TRIGGER trig UPDATE ON t1 FOR EACH STATEMENT BEGIN
66 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
72 CREATE TRIGGER IF NOT EXISTS tr1 DELETE ON t1 BEGIN
79 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
86 CREATE TRIGGER "tr1" DELETE ON t1 BEGIN
93 CREATE TRIGGER [tr1] DELETE ON t1 BEGIN
[all …]
|
| D | alter4.test | 33 # alter4-1.*: Test that ALTER TABLE correctly modifies the CREATE TABLE sql.
44 CREATE TEMP TABLE abc(a, b, c);
47 } {{CREATE TABLE abc(a, b, c)}}
53 } {{CREATE TABLE abc(a, b, c, d INTEGER)}}
59 } {{CREATE TABLE abc(a, b, c, d INTEGER, e)}}
62 CREATE TABLE temp.t1(a, b);
66 } {{CREATE TABLE t1(a, b, c)}}
72 } {{CREATE TABLE t1(a, b, c, d CHECK (a>d))}}
76 CREATE TEMP TABLE t2(a, b, UNIQUE(a, b));
81 } {{CREATE TABLE t2(a, b, c REFERENCES t1(c), UNIQUE(a, b))}}
[all …]
|
| D | trigger2.test | 66 {CREATE TABLE tbl (a, b);} \
67 {CREATE TABLE tbl (a INTEGER PRIMARY KEY, b);} \
68 {CREATE TABLE tbl (a, b PRIMARY KEY);} \
69 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);} \
73 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
74 lappend tbl_definitions {CREATE TEMP TABLE tbl (a, b);}
76 {CREATE TEMPORARY TABLE tbl (a INTEGER PRIMARY KEY, b);}
94 CREATE TABLE rlog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
95 CREATE TABLE clog (idx, old_a, old_b, db_sum_a, db_sum_b, new_a, new_b);
97 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
[all …]
|
| D | vtab8.test | 31 CREATE TABLE t2244(a, b);
32 CREATE VIRTUAL TABLE t2244e USING echo(t2244);
52 CREATE TABLE t2250(a, b);
54 CREATE VIRTUAL TABLE t2250e USING echo(t2250);
64 CREATE TABLE t2260a_real(a, b);
65 CREATE TABLE t2260b_real(a, b);
67 CREATE INDEX i2260 ON t2260a_real(a);
68 CREATE INDEX i2260x ON t2260b_real(a);
70 CREATE VIRTUAL TABLE t2260a USING echo(t2260a_real);
71 CREATE VIRTUAL TABLE t2260b USING echo(t2260b_real);
|
| D | alter3.test | 41 # alter3-1.*: Test that ALTER TABLE correctly modifies the CREATE TABLE sql.
59 CREATE TABLE abc(a, b, c);
62 } {{CREATE TABLE abc(a, b, c)}}
68 } {{CREATE TABLE abc(a, b, c, d INTEGER)}}
74 } {{CREATE TABLE abc(a, b, c, d INTEGER, e)}}
77 CREATE TABLE main.t1(a, b);
81 } {{CREATE TABLE t1(a, b, c)}}
87 } {{CREATE TABLE t1(a, b, c, d CHECK (a>d))}}
91 CREATE TABLE t2(a, b, UNIQUE(a, b));
95 } {{CREATE TABLE t2(a, b, c REFERENCES t1(c), UNIQUE(a, b))}}
[all …]
|
| D | trigger9.test | 43 CREATE TABLE t1(x, y, z);
47 CREATE TABLE t2(x);
54 CREATE TRIGGER trig1 BEFORE DELETE ON t1 BEGIN
69 CREATE TRIGGER trig1 BEFORE DELETE ON t1 BEGIN
84 CREATE TRIGGER trig1 BEFORE DELETE ON t1 WHEN old.x='1' BEGIN
99 CREATE TRIGGER trig1 BEFORE UPDATE ON t1 BEGIN
114 CREATE TRIGGER trig1 BEFORE UPDATE ON t1 BEGIN
129 CREATE TRIGGER trig1 BEFORE UPDATE ON t1 WHEN old.x>='2' BEGIN
143 CREATE TABLE t3(a, b);
152 CREATE VIEW v1 AS SELECT * FROM t3;
[all …]
|
| D | triggerC.test | 56 CREATE TABLE t1(a, b, c);
57 CREATE TABLE log(t, a1, b1, c1, a2, b2, c2);
58 CREATE TRIGGER trig1 BEFORE INSERT ON t1 BEGIN
61 CREATE TRIGGER trig2 AFTER INSERT ON t1 BEGIN
64 CREATE TRIGGER trig3 BEFORE UPDATE ON t1 BEGIN
67 CREATE TRIGGER trig4 AFTER UPDATE ON t1 BEGIN
71 CREATE TRIGGER trig5 BEFORE DELETE ON t1 BEGIN
74 CREATE TRIGGER trig6 AFTER DELETE ON t1 BEGIN
110 CREATE TABLE t4(a, b);
111 CREATE TRIGGER t4t AFTER DELETE ON t4 BEGIN
[all …]
|
| D | index.test | 12 # focus of this file is testing the CREATE INDEX statement.
22 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
23 execsql {CREATE INDEX index1 ON test1(f1)}
29 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
35 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
52 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
60 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int)}
61 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
68 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
80 execsql {CREATE TABLE test1(f1 int, f2 int, f3 int, f4 int, f5 int)}
[all …]
|
| D | dbstatus.test | 34 CREATE TABLE t1(x);
38 CREATE TABLE t2(y);
102 1 { CREATE TABLE t1(a, b) }
103 2 { CREATE TABLE t1(a PRIMARY KEY, b REFERENCES t1, c UNIQUE) }
105 CREATE TABLE t1(a, b);
106 CREATE INDEX i1 ON t1(a, b);
109 CREATE TABLE t1(a, b);
110 CREATE TABLE t2(c, d);
111 CREATE TRIGGER AFTER INSERT ON t1 BEGIN
117 CREATE TABLE t1(a, b);
[all …]
|
| D | e_fkey.test | 42 CREATE TABLE p(i PRIMARY KEY);
43 CREATE TABLE c(j REFERENCES p ON UPDATE CASCADE);
78 CREATE TABLE p(i PRIMARY KEY);
79 CREATE TABLE c(j REFERENCES p ON UPDATE CASCADE);
108 execsql { CREATE TABLE p(i PRIMARY KEY) }
109 catchsql { CREATE TABLE c(j REFERENCES p ON UPDATE CASCADE) }
114 execsql { CREATE TABLE c(j REFERENCES p) }
145 CREATE TABLE p(i PRIMARY KEY);
146 CREATE TABLE c(j REFERENCES p ON UPDATE CASCADE);
204 CREATE TABLE t1(a UNIQUE, b);
[all …]
|
| D | vacuum.test | 37 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
47 CREATE INDEX i1 ON t1(b,c);
48 CREATE UNIQUE INDEX i2 ON t1(c,a);
49 CREATE TABLE t2 AS SELECT * FROM t1;
84 CREATE TABLE t2 AS SELECT * FROM t1;
85 CREATE TABLE t3 AS SELECT * FROM t1;
86 CREATE VIEW v1 AS SELECT b, c FROM t3;
87 CREATE TRIGGER r1 AFTER DELETE ON t2 BEGIN SELECT 1; END;
95 regsub {CREATE VIEW} $sql_script {-- CREATE VIEW} sql_script
98 regsub {CREATE TRIGGER} $sql_script {-- CREATE TRIGGER} sql_script
[all …]
|