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