OLD | NEW |
1 # 2003 July 1 | 1 # 2003 July 1 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 189 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
200 | 200 |
201 ifcapable tempdb { | 201 ifcapable tempdb { |
202 # Try to trick SQLite into dropping the wrong temp trigger. | 202 # Try to trick SQLite into dropping the wrong temp trigger. |
203 do_test attach3-9.0 { | 203 do_test attach3-9.0 { |
204 execsql { | 204 execsql { |
205 CREATE TABLE main.t4(a, b, c); | 205 CREATE TABLE main.t4(a, b, c); |
206 CREATE TABLE aux.t4(a, b, c); | 206 CREATE TABLE aux.t4(a, b, c); |
207 CREATE TEMP TRIGGER tst_trigger BEFORE INSERT ON aux.t4 BEGIN | 207 CREATE TEMP TRIGGER tst_trigger BEFORE INSERT ON aux.t4 BEGIN |
208 SELECT 'hello world'; | 208 SELECT 'hello world'; |
209 END; | 209 END; |
210 SELECT count(*) FROM sqlite_temp_master; | 210 SELECT count(*) FROM temp.sqlite_master; |
211 } | 211 } |
212 } {1} | 212 } {1} |
213 do_test attach3-9.1 { | 213 do_test attach3-9.1 { |
214 execsql { | 214 execsql { |
215 DROP TABLE main.t4; | 215 DROP TABLE main.t4; |
216 SELECT count(*) FROM sqlite_temp_master; | 216 SELECT count(*) FROM sqlite_temp_master; |
217 } | 217 } |
218 } {1} | 218 } {1} |
219 do_test attach3-9.2 { | 219 do_test attach3-9.2 { |
220 execsql { | 220 execsql { |
221 DROP TABLE aux.t4; | 221 DROP TABLE aux.t4; |
222 SELECT count(*) FROM sqlite_temp_master; | 222 SELECT count(*) FROM temp.sqlite_master; |
223 } | 223 } |
224 } {0} | 224 } {0} |
225 } | 225 } |
226 } ;# endif trigger | 226 } ;# endif trigger |
227 | 227 |
228 # Make sure the aux.sqlite_master table is read-only | 228 # Make sure the aux.sqlite_master table is read-only |
229 do_test attach3-10.0 { | 229 do_test attach3-10.0 { |
230 catchsql { | 230 catchsql { |
231 INSERT INTO aux.sqlite_master VALUES(1, 2, 3, 4, 5); | 231 INSERT INTO aux.sqlite_master VALUES(1, 2, 3, 4, 5); |
232 } | 232 } |
(...skipping 111 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
344 do_test attach3-12.14 { | 344 do_test attach3-12.14 { |
345 execsql { | 345 execsql { |
346 DETACH ''; | 346 DETACH ''; |
347 } | 347 } |
348 db_list | 348 db_list |
349 } {main temp} | 349 } {main temp} |
350 | 350 |
351 } ;# ifcapable pragma | 351 } ;# ifcapable pragma |
352 | 352 |
353 finish_test | 353 finish_test |
OLD | NEW |