Home
last modified time | relevance | path

Searched refs:main (Results 1 – 25 of 353) sorted by relevance

12345678910>>...15

/sqlite-3.40.0/test/
H A Dmain.test25 do_test main-1.1 {
28 do_test main-1.2.0 {
32 do_test main-1.2.1 {
35 do_test main-1.3.0 {
40 do_test main-1.3.1 {
62 do_test main-1.5 {
65 do_test main-1.6 {
68 do_test main-1.7 {
71 do_test main-1.8 {
74 do_test main-1.9 {
[all …]
H A De_droptrigger.test104 2 t2 "DROP TRIGGER tr1" {main.tr1 main.tr2} {main.tr1 main.tr2}
108 5 t2 "DROP TRIGGER tr2" {main.tr1 main.tr2} {main.tr1}
112 8 t2 "DROP TRIGGER tr3" {main.tr1 main.tr2} {main.tr1 main.tr2}
142 2 t2 "DROP TRIGGER tr1" {main.tr1 main.tr2} {main.tr1 main.tr2}
146 5 t2 "DROP TRIGGER tr2" {main.tr1 main.tr2} {main.tr1}
150 8 t2 "DROP TRIGGER tr3" {main.tr1 main.tr2} {main.tr1 main.tr2}
169 2 t2 "DROP TRIGGER tr1" {main.tr1 main.tr2} {main.tr1 main.tr2}
173 5 t2 "DROP TRIGGER tr2" {main.tr1 main.tr2} {main.tr1}
177 8 t2 "DROP TRIGGER tr3" {main.tr1 main.tr2} {main.tr1 main.tr2}
206 } {main.tr1 main.tr2 aux.tr1 aux.tr2 aux.tr3}
[all …]
H A Dauth2.test124 SQLITE_READ t2 x main v2
125 SQLITE_READ t2 y main v2
126 SQLITE_READ t2 y main v2
127 SQLITE_READ t2 z main v2
128 SQLITE_READ v2 a main {}
129 SQLITE_READ v2 b main {}
142 SQLITE_READ t2 x main v2
143 SQLITE_READ t2 y main v2
144 SQLITE_READ t2 y main v2
145 SQLITE_READ t2 z main v2
[all …]
H A Dhook.test184 INSERT main t1 4 \
185 DELETE main t1 2 \
186 UPDATE main t1 1 \
187 UPDATE main t1 3 \
188 DELETE main t1 1 \
189 DELETE main t1 3 \
190 DELETE main t1 4 \
528 } {INSERT main t1 2 2 b a INSERT main t1 3 3 d c}
531 } {INSERT main t1 4 4 a b INSERT main t1 5 5 c d}
999 } {preupdate {INSERT main t3 0 0} preupdate {INSERT main t3 0 0}}
[all …]
H A De_dropview.test28 INSERT INTO t1 VALUES('a main', 'b main');
82 1 "DROP VIEW v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3}
84 3 "DROP VIEW main.v1" {main.v2 temp.v1 aux.v1 aux.v2 aux.v3}
85 4 "DROP VIEW main.v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
86 5 "DROP VIEW IF EXISTS v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3}
88 7 "DROP VIEW IF EXISTS main.v1" {main.v2 temp.v1 aux.v1 aux.v2 aux.v3}
99 } {{a main} {b main} {a main} {b main}}
131 do_execsql_test 3.2.0 { SELECT * FROM v1 } {{a main} {b main}}
137 do_execsql_test 3.3.0 { SELECT * FROM v2 } {{a main} {b main}}
170 2 "DROP VIEW main.xx" main.xx
[all …]
H A De_blobopen.test35 INSERT INTO main.t1 VALUES(1, 'main one', X'0101');
36 INSERT INTO main.t1 VALUES(2, 'main two', X'0102');
37 INSERT INTO main.t1 VALUES(3, 'main three', X'0103');
38 INSERT INTO main.t1 VALUES(4, 'main four', X'0104');
39 INSERT INTO main.t1 VALUES(5, 'main five', X'0105');
41 INSERT INTO main.x1 VALUES(1, 'x main one', X'000101');
42 INSERT INTO main.x1 VALUES(2, 'x main two', X'000102');
44 INSERT INTO main.x1 VALUES(4, 'x main four', X'000104');
86 do_test 1.1.1 { read_blob main t1 b 1 } "main one"
93 do_test 1.2.1 { read_blob main t1 b 4 } "main four"
[all …]
H A Dhook2.test60 INSERT main t1 0 0 one 1
70 DELETE main t1 0 0 one 2
100 INSERT main t2 0 0 4 1 1
112 INSERT main t2 0 0 1 2 3
145 DELETE main t2 0 0 4 1 1
147 INSERT main t2 0 0 4 32 33
166 DELETE main t2 0 0 1 2 3
198 DELETE main t3 0 0 4 bb c
205 DELETE main t3 0 0 2 2 2
212 DELETE main t3 0 0 1 1 2
[all …]
H A De_blobclose.test64 } {main reserved temp closed}
68 } {main reserved temp closed}
72 } {main reserved temp closed}
76 } {main shared temp closed}
80 } {main unlocked temp closed}
85 } {main reserved temp closed}
90 } {main reserved temp closed}
94 } {main unlocked temp closed}
104 } {main reserved temp closed}
108 } {main unlocked temp closed}
[all …]
H A Dalterauth2.test58 {SQLITE_ALTER_TABLE main t1 {} {}}
63 {SQLITE_READ sqlite_master name main {}}
64 {SQLITE_READ sqlite_master sql main {}}
82 {SQLITE_ALTER_TABLE main t2 {} {}}
87 {SQLITE_READ sqlite_master name main {}}
88 {SQLITE_READ sqlite_master sql main {}}
90 {SQLITE_READ sqlite_master type main {}}
102 {SQLITE_ALTER_TABLE main t2 c {}}
107 {SQLITE_READ sqlite_master name main {}}
108 {SQLITE_READ sqlite_master sql main {}}
[all …]
H A Dcolmeta.test20 # Set up a schema in the main and temp test databases.
47 1 {main abc a} {0 {{} BINARY 0 0 0}}
54 13 {main abc rowid} {0 {INTEGER BINARY 0 1 0}}
55 14 {main abc3 rowid} {0 {INTEGER BINARY 0 1 0}}
57 20 {main abc5 w} {0 {{} BINARY 0 0 0}}
58 21 {main abc5 x} {0 {{} BINARY 1 1 0}}
59 22 {main abc5 y} {0 {{} BINARY 0 0 0}}
60 23 {main abc5 z} {0 {{} BINARY 1 1 0}}
62 30 {main abc6 rowid} {0 {TEXT rtrim 0 0 0}}
63 31 {main abc6 oid} {0 {REAL BINARY 0 0 0}}
[all …]
H A Dbackup.test71 test_contents backup-1.2 db main db main
78 sqlite3_backup B db2 main db main
91 sqlite3_backup B db2 main db main
309 sqlite3_backup B db main db2 main
348 sqlite3_backup B db2 main db main
454 sqlite3_backup B db2 main db main
665 sqlite3_backup B db2 main db main
723 sqlite3_backup B db2 main db main
761 sqlite3_backup B db2 main db main
791 sqlite3_backup B2 db2 main db main
[all …]
H A Dwalmode.test32 execsql { PRAGMA main.journal_mode }
136 execsql { PRAGMA main.journal_mode } db2
148 execsql { PRAGMA main.journal_mode } db
156 execsql { PRAGMA main.journal_mode } db
176 execsql { PRAGMA main.journal_mode } db
190 execsql { PRAGMA main.journal_mode }
202 PRAGMA main.journal_mode;
212 PRAGMA main.journal_mode;
223 execsql { PRAGMA main.journal_mode }
235 PRAGMA main.journal_mode;
[all …]
H A Dsnapshot.test121 snapshot_open db main $snapshot
150 snapshot_open db main $snapshot
174 snapshot_open db main $snapshot
231 snapshot_open db main $snapshot
288 snapshot_open db main $snapshot
320 snapshot_open db main $snapshot
445 set p1 [snapshot_get db main]
451 set p2 [snapshot_get db main]
467 set p1 [snapshot_get db main]
475 set p2 [snapshot_get db main]
[all …]
H A Dcapi2.test698 } [list {main tab1 col2} {main tab1 col1}]
701 } [list {main tab1 col2} {main tab1 col1}]
706 } [list {main tab1 col2} {main tab1 col1}]
709 } [list {main tab1 col2} {main tab1 col1}]
712 } [list {main tab1 col2} {main tab1 col1}]
715 } [list {main tab1 col1} {main tab1 col2}]
718 } [list {main tab1 col1} {main tab1 col2}]
729 } [list {main tab1 col2} {main tab1 col1}]
732 } [list {main tab1 col2} {main tab1 col1}]
735 } [list {main tab1 col2} {main tab1 col1}]
[all …]
H A De_resolve.test30 CREATE TABLE main.n1(x, y); INSERT INTO main.n1 VALUES('main', 'n1');
31 CREATE TABLE main.n2(x, y); INSERT INTO main.n2 VALUES('main', 'n2');
32 CREATE INDEX main.n3 ON n2(y, x);
33 CREATE TRIGGER main.n4 BEFORE INSERT ON n2 BEGIN SELECT 1; END;
64 do_execsql_test 1.2 { SELECT * FROM n2 } {main n2}
69 # object reference, it must be either "main", or "temp" or the
75 do_execsql_test 2.1.1 { SELECT * FROM main.n1 } {main n1}
86 do_execsql_test 3.1 { SELECT * FROM MAIN.n1 } {main n1}
95 do_catchsql_test 4.2 { SELECT * FROM main.n2 } {0 {main n2}}
125 do_catchsql_test 6.2.2 { SELECT * FROM main.t1 } {0 {}}
[all …]
H A Dattach2.test72 } {0 main 2 t2}
95 SELECT name FROM main.sqlite_master;
194 # db - shared(main)
198 lock_status 4.2.1 db {main shared temp closed file2 unlocked}
206 lock_status 4.3.1 db {main shared temp closed file2 unlocked}
234 # db - shared(main)
247 # db - shared(main), shared(file2)
272 lock_status 4.7.1 db {main shared temp closed file2 shared}
280 lock_status 4.8.1 db {main shared temp closed file2 shared}
290 lock_status 4.9.1 db {main shared temp closed file2 shared}
[all …]
H A De_update.test136 DELETE FROM main.t1;
153 DELETE FROM main.t1;
178 DELETE FROM main.t1;
362 } "main.t4"
384 SELECT 'main', tbl_name FROM main.sqlite_master WHERE type = 'table';
388 main t1
389 main t2
390 main t3
391 main t6
398 DELETE FROM main.t6;
[all …]
H A Dsnapshot2.test56 string length [sqlite3_snapshot_get_blob db main]
100 sqlite3_snapshot_open_blob db main $snap
117 sqlite3_snapshot_recover db main
119 sqlite3_snapshot_open_blob db main $snap
134 sqlite3_snapshot_recover db main
153 sqlite3_snapshot_recover db main
165 sqlite3_snapshot_recover db main
176 sqlite3_snapshot_recover db main
216 set snap [sqlite3_snapshot_get_blob db2 main]
222 sqlite3_snapshot_open_blob db2 main $snap
[all …]
H A Dsnapshot_up.test40 set ::snap1 [sqlite3_snapshot_get db main]
44 set ::snap2 [sqlite3_snapshot_get db main]
48 set ::snap3 [sqlite3_snapshot_get db main]
58 sqlite3_snapshot_open db main $::snap1
63 sqlite3_snapshot_open db main $::snap2
77 list [catch { sqlite3_snapshot_open db main $::snap1 } msg] $msg
96 set ::snap4 [sqlite3_snapshot_get db main]
110 sqlite3_snapshot_open db main $::snap4
150 set ::snap1 [sqlite3_snapshot_get db main]
154 set ::snap2 [sqlite3_snapshot_get db main]
[all …]
H A De_insert.test57 2 "INSERT INTO main.a1 DEFAULT VALUES" {}
58 3 "INSERT OR ROLLBACK INTO main.a1 DEFAULT VALUES" {}
60 5 "INSERT OR ABORT INTO main.a1 DEFAULT VALUES" {}
62 7 "INSERT OR REPLACE INTO main.a1 DEFAULT VALUES" {}
64 9 "INSERT OR FAIL INTO main.a1 DEFAULT VALUES" {}
66 11 "INSERT OR FAIL INTO main.a1 DEFAULT VALUES" {}
69 14 "REPLACE INTO main.a1 DEFAULT VALUES" {}
71 16 "INSERT INTO main.a1 VALUES(1, 2)" {}
72 17 "INSERT OR ROLLBACK INTO main.a1 VALUES(1, 2)" {}
74 19 "INSERT OR ABORT INTO main.a1 VALUES(1, 2)" {}
[all …]
H A Dtrace2.test131 "-- DELETE FROM 'main'.'x1_segdir' WHERE level = ?"
132 "-- INSERT INTO 'main'.'x1_content' VALUES(?,(?))"
133 "-- REPLACE INTO 'main'.'x1_docsize' VALUES(?,?)"
134 "-- SELECT value FROM 'main'.'x1_stat' WHERE id=?"
135 "-- REPLACE INTO 'main'.'x1_stat' VALUES(?,?)"
136 "-- SELECT (SELECT max(idx) FROM 'main'.'x1_segdir' WHERE level = ?) + 1"
138 "-- REPLACE INTO 'main'.'x1_segdir' VALUES(?,?,?,?,?,?)"
146 "-- SELECT ? UNION SELECT level / (1024 * ?) FROM 'main'.'x1_segdir'"
148 "-- SELECT max(level) FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?"
150 "-- DELETE FROM 'main'.'x1_segdir' WHERE level BETWEEN ? AND ?"
[all …]
H A Dsync2.test61 do_execsql_test 1.2.1 { PRAGMA main.synchronous = NORMAL }
62 do_execsql_test 1.2.2 { PRAGMA main.synchronous } 1
66 do_execsql_test 1.3.1 { PRAGMA main.synchronous = OFF }
67 do_execsql_test 1.3.2 { PRAGMA main.synchronous } 0
72 do_execsql_test 1.4.1 { PRAGMA main.synchronous = FULL }
73 do_execsql_test 1.4.2 { PRAGMA main.synchronous } 2
89 do_execsql_test 1.8.1 { PRAGMA main.synchronous = NORMAL }
90 do_execsql_test 1.8.2 { PRAGMA main.synchronous } 1
97 do_execsql_test 1.10.1 { PRAGMA main.synchronous = OFF }
118 do_execsql_test 1.11.3 { PRAGMA main.synchronous } 1
[all …]
H A Dinsert5.test70 uses_temp_table { INSERT INTO b SELECT * FROM main }
76 uses_temp_table { INSERT INTO b SELECT (SELECT id FROM b), id1 FROM main }
79 uses_temp_table { INSERT INTO b SELECT id1, (SELECT id FROM b) FROM main }
84 SELECT * FROM main WHERE id = (SELECT id1 FROM b WHERE main.id = b.id) }
95 SELECT * FROM main WHERE id > 10 AND max(id1, (SELECT id FROM b)) > 10;
99 # UPDATE: Using a column from the outer query (main.id) in the GROUP BY
105 # SELECT * FROM main
106 # WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
112 SELECT * FROM main
113 WHERE id > 10 AND (SELECT count(*) FROM v2 GROUP BY main.id)
[all …]
H A Dshmlock.test82 set rc [vfs_shmlock db$i main shared lock 4 1]
86 vfs_shmlock db255 main shared lock 4 1
90 do_test 2.2 { vfs_shmlock db0 main shared unlock 4 1 } SQLITE_OK
91 do_test 2.3 { vfs_shmlock db255 main shared lock 4 1 } SQLITE_OK
92 do_test 2.4 { vfs_shmlock db255 main shared unlock 4 1 } SQLITE_OK
97 set rc [vfs_shmlock db255 main exclusive lock 4 1]
99 set rc [vfs_shmlock db$i main shared unlock 4 1]
103 vfs_shmlock db255 main exclusive lock 4 1
106 vfs_shmlock db255 main exclusive unlock 4 1
131 vfs_shmlock db$idx main [lindex $L($idx) $iSlot] unlock $iSlot 1
[all …]
H A Dpragma2.test22 # pragma2-1.*: Test freelist_count pragma on the main database.
67 PRAGMA main.freelist_count;
108 PRAGMA main.freelist_count;
138 PRAGMA main.cache_size=2000;
141 PRAGMA main.cache_spill;
147 PRAGMA main.cache_spill;
182 } {main exclusive temp unknown} ;# EXCLUSIVE lock due to cache spill
213 PRAGMA main.cache_spill;
223 PRAGMA main.cache_spill;
243 } {main unlocked temp unknown aux1 reserved}
[all …]

12345678910>>...15