| 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 |