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 |