OLD | NEW |
1 # 2010 November 30 | 1 # 2010 November 30 |
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 52 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
63 lappend res [list $x [db eval "SELECT * FROM $x"]] | 63 lappend res [list $x [db eval "SELECT * FROM $x"]] |
64 } | 64 } |
65 } | 65 } |
66 set res | 66 set res |
67 } | 67 } |
68 | 68 |
69 proc do_dropview_tests {nm args} { | 69 proc do_dropview_tests {nm args} { |
70 uplevel do_select_tests $nm $args | 70 uplevel do_select_tests $nm $args |
71 } | 71 } |
72 | 72 |
73 # EVIDENCE-OF: R-21739-51207 -- syntax diagram drop-view-stmt | 73 # -- syntax diagram drop-view-stmt |
74 # | 74 # |
75 # All paths in the syntax diagram for DROP VIEW are tested by tests 1.*. | 75 # All paths in the syntax diagram for DROP VIEW are tested by tests 1.*. |
76 # | 76 # |
77 do_dropview_tests 1 -repair { | 77 do_dropview_tests 1 -repair { |
78 dropview_reopen_db | 78 dropview_reopen_db |
79 } -tclquery { | 79 } -tclquery { |
80 list_all_views | 80 list_all_views |
81 } { | 81 } { |
82 1 "DROP VIEW v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3} | 82 1 "DROP VIEW v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3} |
83 2 "DROP VIEW v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3} | 83 2 "DROP VIEW v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3} |
(...skipping 99 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
183 } { | 183 } { |
184 1 "DROP VIEW IF EXISTS xx" 1 | 184 1 "DROP VIEW IF EXISTS xx" 1 |
185 2 "DROP VIEW IF EXISTS main.xx" 1 | 185 2 "DROP VIEW IF EXISTS main.xx" 1 |
186 3 "DROP VIEW IF EXISTS temp.v2" 1 | 186 3 "DROP VIEW IF EXISTS temp.v2" 1 |
187 } | 187 } |
188 | 188 |
189 | 189 |
190 | 190 |
191 | 191 |
192 finish_test | 192 finish_test |
OLD | NEW |