OLD | NEW |
1 # 2006 June 10 | 1 # 2006 June 10 |
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 116 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
127 # Test that it is impossible to create an index on a virtual table. | 127 # Test that it is impossible to create an index on a virtual table. |
128 # | 128 # |
129 do_test vtab5.4.1 { | 129 do_test vtab5.4.1 { |
130 catchsql { | 130 catchsql { |
131 CREATE INDEX echo_strings_i ON echo_strings(str); | 131 CREATE INDEX echo_strings_i ON echo_strings(str); |
132 } | 132 } |
133 } {1 {virtual tables may not be indexed}} | 133 } {1 {virtual tables may not be indexed}} |
134 | 134 |
135 # Test that it is impossible to add a column to a virtual table. | 135 # Test that it is impossible to add a column to a virtual table. |
136 # | 136 # |
137 do_test vtab5.4.2 { | 137 ifcapable altertable { |
138 catchsql { | 138 do_test vtab5.4.2 { |
139 ALTER TABLE echo_strings ADD COLUMN col2; | 139 catchsql { |
140 } | 140 ALTER TABLE echo_strings ADD COLUMN col2; |
141 } {1 {virtual tables may not be altered}} | 141 } |
| 142 } {1 {virtual tables may not be altered}} |
| 143 } |
142 | 144 |
143 # Test that it is impossible to rename a virtual table. | 145 # Test that it is impossible to rename a virtual table. |
144 # UPDATE: It is now possible. | 146 # UPDATE: It is now possible. |
145 # | 147 # |
146 # do_test vtab5.4.3 { | 148 # do_test vtab5.4.3 { |
147 # catchsql { | 149 # catchsql { |
148 # ALTER TABLE echo_strings RENAME TO echo_strings2; | 150 # ALTER TABLE echo_strings RENAME TO echo_strings2; |
149 # } | 151 # } |
150 # } {1 {virtual tables may not be altered}} | 152 # } {1 {virtual tables may not be altered}} |
151 | 153 |
152 finish_test | 154 finish_test |
OLD | NEW |