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