Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(33)

Side by Side Diff: third_party/sqlite/src/test/fts3aj.test

Issue 901033002: Import SQLite 3.8.7.4. (Closed) Base URL: https://chromium.googlesource.com/chromium/src.git@master
Patch Set: Chromium changes to support SQLite 3.8.7.4. Created 5 years, 10 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
OLDNEW
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
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
OLDNEW

Powered by Google App Engine
This is Rietveld 408576698