OLD | NEW |
1 # 2005 February 19 | 1 # 2005 February 19 |
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 178 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
189 ifcapable schema_version { | 189 ifcapable schema_version { |
190 do_test alter3-3.4 { | 190 do_test alter3-3.4 { |
191 execsql { | 191 execsql { |
192 PRAGMA schema_version; | 192 PRAGMA schema_version; |
193 } | 193 } |
194 } {11} | 194 } {11} |
195 } | 195 } |
196 | 196 |
197 do_test alter3-4.1 { | 197 do_test alter3-4.1 { |
198 db close | 198 db close |
199 file delete -force test.db | 199 forcedelete test.db |
200 set ::DB [sqlite3 db test.db] | 200 set ::DB [sqlite3 db test.db] |
201 execsql { | 201 execsql { |
202 PRAGMA legacy_file_format=ON; | 202 PRAGMA legacy_file_format=ON; |
203 CREATE TABLE t1(a, b); | 203 CREATE TABLE t1(a, b); |
204 INSERT INTO t1 VALUES(1, 100); | 204 INSERT INTO t1 VALUES(1, 100); |
205 INSERT INTO t1 VALUES(2, 300); | 205 INSERT INTO t1 VALUES(2, 300); |
206 SELECT * FROM t1; | 206 SELECT * FROM t1; |
207 } | 207 } |
208 } {1 100 2 300} | 208 } {1 100 2 300} |
209 do_test alter3-4.1 { | 209 do_test alter3-4.1 { |
(...skipping 20 matching lines...) Expand all Loading... |
230 } {21} | 230 } {21} |
231 } | 231 } |
232 do_test alter3-4.99 { | 232 do_test alter3-4.99 { |
233 execsql { | 233 execsql { |
234 DROP TABLE t1; | 234 DROP TABLE t1; |
235 } | 235 } |
236 } {} | 236 } {} |
237 | 237 |
238 ifcapable attach { | 238 ifcapable attach { |
239 do_test alter3-5.1 { | 239 do_test alter3-5.1 { |
240 file delete -force test2.db | 240 forcedelete test2.db |
241 file delete -force test2.db-journal | 241 forcedelete test2.db-journal |
242 execsql { | 242 execsql { |
243 CREATE TABLE t1(a, b); | 243 CREATE TABLE t1(a, b); |
244 INSERT INTO t1 VALUES(1, 'one'); | 244 INSERT INTO t1 VALUES(1, 'one'); |
245 INSERT INTO t1 VALUES(2, 'two'); | 245 INSERT INTO t1 VALUES(2, 'two'); |
246 ATTACH 'test2.db' AS aux; | 246 ATTACH 'test2.db' AS aux; |
247 CREATE TABLE aux.t1 AS SELECT * FROM t1; | 247 CREATE TABLE aux.t1 AS SELECT * FROM t1; |
248 PRAGMA aux.schema_version = 30; | 248 PRAGMA aux.schema_version = 30; |
249 SELECT sql FROM aux.sqlite_master; | 249 SELECT sql FROM aux.sqlite_master; |
250 } | 250 } |
251 } {{CREATE TABLE t1(a,b)}} | 251 } {{CREATE TABLE t1(a,b)}} |
(...skipping 136 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
388 set ::sql "CREATE TABLE t4([join $cols {, }])" | 388 set ::sql "CREATE TABLE t4([join $cols {, }])" |
389 list | 389 list |
390 } {} | 390 } {} |
391 do_test alter3-8.2 { | 391 do_test alter3-8.2 { |
392 execsql { | 392 execsql { |
393 SELECT sql FROM sqlite_master WHERE name = 't4'; | 393 SELECT sql FROM sqlite_master WHERE name = 't4'; |
394 } | 394 } |
395 } [list $::sql] | 395 } [list $::sql] |
396 | 396 |
397 finish_test | 397 finish_test |
OLD | NEW |