| OLD | NEW |
| 1 # 2009 August 1 | 1 # 2009 August 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 44 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 55 } | 55 } |
| 56 catchsql { | 56 catchsql { |
| 57 SELECT * FROM t3; | 57 SELECT * FROM t3; |
| 58 } | 58 } |
| 59 } {0 {}} | 59 } {0 {}} |
| 60 | 60 |
| 61 # Trigger still exists in the sqlite_temp_master table, but now it is | 61 # Trigger still exists in the sqlite_temp_master table, but now it is |
| 62 # an orphan. | 62 # an orphan. |
| 63 # | 63 # |
| 64 do_test tkt3810-4 { | 64 do_test tkt3810-4 { |
| 65 execsql {SELECT name FROM sqlite_temp_master ORDER BY name} | 65 execsql {SELECT name FROM temp.sqlite_master ORDER BY name} |
| 66 } {r1} | 66 } {r1} |
| 67 | 67 |
| 68 # Because it is an orphan, it cannot be dropped. | 68 # Because it is an orphan, it cannot be dropped. |
| 69 # | 69 # |
| 70 do_test tkt3810-5 { | 70 do_test tkt3810-5 { |
| 71 catchsql {DROP TRIGGER r1} | 71 catchsql {DROP TRIGGER r1} |
| 72 } {1 {no such trigger: r1}} | 72 } {1 {no such trigger: r1}} |
| 73 | 73 |
| 74 # Create a table t1 then drop the table in order to drop the orphaned | 74 # Create a table t1 then drop the table in order to drop the orphaned |
| 75 # trigger. | 75 # trigger. |
| 76 # | 76 # |
| 77 do_test tkt3810-6 { | 77 do_test tkt3810-6 { |
| 78 execsql {CREATE TABLE t1(x)} db2 | 78 execsql {CREATE TABLE t1(x)} db2 |
| 79 execsql {DROP TABLE t1} | 79 execsql {DROP TABLE t1} |
| 80 execsql { | 80 execsql { |
| 81 SELECT name FROM sqlite_temp_master; | 81 SELECT name FROM sqlite_temp_master; |
| 82 } | 82 } |
| 83 } {} | 83 } {} |
| 84 | 84 |
| 85 db2 close | 85 db2 close |
| 86 | 86 |
| 87 finish_test | 87 finish_test |
| OLD | NEW |