OLD | NEW |
1 # 2007 June 26 | 1 # 2007 June 26 |
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 #*********************************************************************** |
11 # This file implements regression tests for SQLite library. The | 11 # This file implements regression tests for SQLite library. The |
12 # focus of this file is testing the ALTER TABLE ... RENAME TO | 12 # focus of this file is testing the ALTER TABLE ... RENAME TO |
13 # command on virtual tables. | 13 # command on virtual tables. |
14 # | 14 # |
15 # $Id: vtab_alter.test,v 1.3 2007/12/13 21:54:11 drh Exp $ | 15 # $Id: vtab_alter.test,v 1.3 2007/12/13 21:54:11 drh Exp $ |
16 | 16 |
17 set testdir [file dirname $argv0] | 17 set testdir [file dirname $argv0] |
18 source $testdir/tester.tcl | 18 source $testdir/tester.tcl |
19 | 19 |
20 ifcapable !vtab { | 20 ifcapable !vtab||!altertable { |
21 finish_test | 21 finish_test |
22 return | 22 return |
23 } | 23 } |
24 | 24 |
25 # Register the echo module. | 25 # Register the echo module. |
26 # | 26 # |
27 # This test uses a special feature of the echo module. If the name | 27 # This test uses a special feature of the echo module. If the name |
28 # of the virtual table is a prefix of the name of the underlying | 28 # of the virtual table is a prefix of the name of the underlying |
29 # real table (for example if the v-table is "tbl" and the real table | 29 # real table (for example if the v-table is "tbl" and the real table |
30 # is "tbl_base"), then the name of the real table is modified | 30 # is "tbl_base"), then the name of the real table is modified |
(...skipping 63 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
94 # | 94 # |
95 do_test vtab_alter-3.1 { | 95 do_test vtab_alter-3.1 { |
96 execsql { CREATE TABLE y_base(a, b, c) } | 96 execsql { CREATE TABLE y_base(a, b, c) } |
97 catchsql { ALTER TABLE x RENAME TO y } | 97 catchsql { ALTER TABLE x RENAME TO y } |
98 } {1 {SQL logic error or missing database}} | 98 } {1 {SQL logic error or missing database}} |
99 do_test vtab_alter-3.2 { | 99 do_test vtab_alter-3.2 { |
100 execsql { SELECT * FROM x } | 100 execsql { SELECT * FROM x } |
101 } {1 2 3} | 101 } {1 2 3} |
102 | 102 |
103 finish_test | 103 finish_test |
OLD | NEW |