| 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 fts2 tables in an attached database. | 7 # tests creating fts2 tables in an attached database. |
| 8 # | 8 # |
| 9 # $Id: fts2j.test,v 1.1 2007/02/07 01:01:18 shess Exp $ | 9 # $Id: fts2j.test,v 1.1 2007/02/07 01:01:18 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_FTS2 is defined, omit this file. | 15 # If SQLITE_ENABLE_FTS2 is defined, omit this file. |
| 16 ifcapable !fts2 { | 16 ifcapable !fts2 { |
| 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 fts2(content); | 27 CREATE VIRTUAL TABLE t3 USING fts2(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 fts2(content); | 32 CREATE VIRTUAL TABLE t1 USING fts2(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 |