OLD | NEW |
1 # 2007 February 6 | 1 # 2007 February 6 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. | 3 # The author disclaims copyright to this source code. |
4 # | 4 # |
5 #************************************************************************* | 5 #************************************************************************* |
6 # This file implements regression tests for SQLite library. This | 6 # This file implements regression tests for SQLite library. This |
7 # tests creating fts3 tables in an attached database. | 7 # tests creating fts3 tables in an attached database. |
8 # | 8 # |
9 # $Id: fts3aj.test,v 1.1 2007/08/20 17:38:42 shess Exp $ | 9 # $Id: fts3aj.test,v 1.1 2007/08/20 17:38:42 shess Exp $ |
10 # | 10 # |
11 | 11 |
12 set testdir [file dirname $argv0] | 12 set testdir [file dirname $argv0] |
13 source $testdir/tester.tcl | 13 source $testdir/tester.tcl |
14 | 14 |
15 # If SQLITE_ENABLE_FTS3 is defined, omit this file. | 15 # If SQLITE_ENABLE_FTS3 is defined, omit this file. |
16 ifcapable !fts3 { | 16 ifcapable !fts3 { |
17 finish_test | 17 finish_test |
18 return | 18 return |
19 } | 19 } |
20 | 20 |
21 # Clean up anything left over from a previous pass. | 21 # Clean up anything left over from a previous pass. |
22 file delete -force test2.db | 22 forcedelete test2.db |
23 file delete -force test2.db-journal | 23 forcedelete test2.db-journal |
24 sqlite3 db2 test2.db | 24 sqlite3 db2 test2.db |
25 | 25 |
26 db eval { | 26 db eval { |
27 CREATE VIRTUAL TABLE t3 USING fts3(content); | 27 CREATE VIRTUAL TABLE t3 USING fts3(content); |
28 INSERT INTO t3 (rowid, content) VALUES(1, "hello world"); | 28 INSERT INTO t3 (rowid, content) VALUES(1, "hello world"); |
29 } | 29 } |
30 | 30 |
31 db2 eval { | 31 db2 eval { |
32 CREATE VIRTUAL TABLE t1 USING fts3(content); | 32 CREATE VIRTUAL TABLE t1 USING fts3(content); |
33 INSERT INTO t1 (rowid, content) VALUES(1, "hello world"); | 33 INSERT INTO t1 (rowid, content) VALUES(1, "hello world"); |
(...skipping 43 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
77 INSERT INTO two.t3 (rowid, content) VALUES(2, "hello there"); | 77 INSERT INTO two.t3 (rowid, content) VALUES(2, "hello there"); |
78 INSERT INTO two.t3 (rowid, content) VALUES(3, "cruel world"); | 78 INSERT INTO two.t3 (rowid, content) VALUES(3, "cruel world"); |
79 SELECT rowid FROM two.t3 WHERE t3 MATCH 'hello'; | 79 SELECT rowid FROM two.t3 WHERE t3 MATCH 'hello'; |
80 | 80 |
81 DETACH DATABASE two; | 81 DETACH DATABASE two; |
82 } db2 | 82 } db2 |
83 } {2} | 83 } {2} |
84 catch {db eval {DETACH DATABASE two}} | 84 catch {db eval {DETACH DATABASE two}} |
85 | 85 |
86 catch {db2 close} | 86 catch {db2 close} |
87 file delete -force test2.db | 87 forcedelete test2.db |
88 | 88 |
89 finish_test | 89 finish_test |
OLD | NEW |