| OLD | NEW |
| 1 # 2008 April 14 | 1 # 2008 April 14 |
| 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 58 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
| 69 CREATE TABLE t1 (a PRIMARY KEY, b, c); | 69 CREATE TABLE t1 (a PRIMARY KEY, b, c); |
| 70 CREATE TABLE t2 (a, b, c); | 70 CREATE TABLE t2 (a, b, c); |
| 71 BEGIN; | 71 BEGIN; |
| 72 INSERT INTO t1 VALUES(1, 2, 3); | 72 INSERT INTO t1 VALUES(1, 2, 3); |
| 73 INSERT INTO t1 VALUES(4, 5, 6); | 73 INSERT INTO t1 VALUES(4, 5, 6); |
| 74 INSERT INTO t2 VALUES(7, 8, 9); | 74 INSERT INTO t2 VALUES(7, 8, 9); |
| 75 INSERT INTO t2 SELECT * FROM t1; | 75 INSERT INTO t2 SELECT * FROM t1; |
| 76 } | 76 } |
| 77 catchsql { INSERT INTO t1 SELECT * FROM t2 } | 77 catchsql { INSERT INTO t1 SELECT * FROM t2 } |
| 78 set sqlite_open_file_count | 78 set sqlite_open_file_count |
| 79 } [expr 1 + (0==$jrnl_in_memory) + (0==$subj_in_memory)] | 79 } [expr 1 + (0==$jrnl_in_memory)] |
| 80 do_test tempdb-2.3 { | 80 do_test tempdb-2.3 { |
| 81 execsql { | 81 execsql { |
| 82 PRAGMA temp_store = 'memory'; | 82 PRAGMA temp_store = 'memory'; |
| 83 ROLLBACK; | 83 ROLLBACK; |
| 84 BEGIN; | 84 BEGIN; |
| 85 INSERT INTO t1 VALUES(1, 2, 3); | 85 INSERT INTO t1 VALUES(1, 2, 3); |
| 86 INSERT INTO t1 VALUES(4, 5, 6); | 86 INSERT INTO t1 VALUES(4, 5, 6); |
| 87 INSERT INTO t2 SELECT * FROM t1; | 87 INSERT INTO t2 SELECT * FROM t1; |
| 88 } | 88 } |
| 89 catchsql { INSERT INTO t1 SELECT * FROM t2 } | 89 catchsql { INSERT INTO t1 SELECT * FROM t2 } |
| 90 set sqlite_open_file_count | 90 set sqlite_open_file_count |
| 91 } [expr 1 + (0==$jrnl_in_memory)] | 91 } [expr 1 + (0==$jrnl_in_memory)] |
| 92 | 92 |
| 93 finish_test | 93 finish_test |
| OLD | NEW |