OLD | NEW |
1 # 2003 April 4 | 1 # 2003 April 4 |
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 175 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
186 DETACH db5; | 186 DETACH db5; |
187 } | 187 } |
188 } {} | 188 } {} |
189 ifcapable schema_pragmas { | 189 ifcapable schema_pragmas { |
190 do_test attach-1.20.2 { | 190 do_test attach-1.20.2 { |
191 db_list db | 191 db_list db |
192 } {0 main 2 db2 3 db3 4 db4 5 db6 6 db7 7 db8 8 db9 9 db10 10 db11} | 192 } {0 main 2 db2 3 db3 4 db4 5 db6 6 db7 7 db8 8 db9 9 db10 10 db11} |
193 } ;# ifcapable schema_pragmas | 193 } ;# ifcapable schema_pragmas |
194 integrity_check attach-1.20.3 | 194 integrity_check attach-1.20.3 |
195 ifcapable tempdb { | 195 ifcapable tempdb { |
196 execsql {select * from sqlite_temp_master} | 196 execsql {select * from temp.sqlite_master} |
197 } | 197 } |
198 do_test attach-1.21 { | 198 do_test attach-1.21 { |
199 catchsql { | 199 catchsql { |
200 ATTACH 'test.db' as db12; | 200 ATTACH 'test.db' as db12; |
201 } | 201 } |
202 } {0 {}} | 202 } {0 {}} |
203 if {$SQLITE_MAX_ATTACHED==10} { | 203 if {$SQLITE_MAX_ATTACHED==10} { |
204 do_test attach-1.22 { | 204 do_test attach-1.22 { |
205 catchsql { | 205 catchsql { |
206 ATTACH 'test.db' as db13; | 206 ATTACH 'test.db' as db13; |
(...skipping 658 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
865 sqlite3 db test.db -uri 1 | 865 sqlite3 db test.db -uri 1 |
866 do_execsql_test attach-11.1 { | 866 do_execsql_test attach-11.1 { |
867 ATTACH printf('file:%09000x/x.db?mode=memory&cache=shared',1) AS aux1; | 867 ATTACH printf('file:%09000x/x.db?mode=memory&cache=shared',1) AS aux1; |
868 CREATE TABLE aux1.t1(x,y); | 868 CREATE TABLE aux1.t1(x,y); |
869 INSERT INTO aux1.t1(x,y) VALUES(1,2),(3,4); | 869 INSERT INTO aux1.t1(x,y) VALUES(1,2),(3,4); |
870 SELECT * FROM aux1.t1; | 870 SELECT * FROM aux1.t1; |
871 } {1 2 3 4} | 871 } {1 2 3 4} |
872 | 872 |
873 | 873 |
874 finish_test | 874 finish_test |
OLD | NEW |