Return to fts1j.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

sqlite3

    1: # 2007 February 6
    2: #
    3: # The author disclaims copyright to this source code.
    4: #
    5: #*************************************************************************
    6: # This file implements regression tests for SQLite library.  This
    7: # tests creating fts1 tables in an attached database.
    8: #
    9: # $Id: fts1j.test,v 1.1.1.1 2012/02/21 17:04:16 misho Exp $
   10: #
   11: 
   12: set testdir [file dirname $argv0]
   13: source $testdir/tester.tcl
   14: 
   15: # If SQLITE_ENABLE_FTS1 is defined, omit this file.
   16: ifcapable !fts1 {
   17:   finish_test
   18:   return
   19: }
   20: 
   21: # Clean up anything left over from a previous pass.
   22: forcedelete test2.db
   23: forcedelete test2.db-journal
   24: sqlite3 db2 test2.db
   25: 
   26: db eval {
   27:   CREATE VIRTUAL TABLE t3 USING fts1(content);
   28:   INSERT INTO t3 (rowid, content) VALUES(1, "hello world");
   29: }
   30: 
   31: db2 eval {
   32:   CREATE VIRTUAL TABLE t1 USING fts1(content);
   33:   INSERT INTO t1 (rowid, content) VALUES(1, "hello world");
   34:   INSERT INTO t1 (rowid, content) VALUES(2, "hello there");
   35:   INSERT INTO t1 (rowid, content) VALUES(3, "cruel world");
   36: }
   37: 
   38: # This has always worked because the t1_* tables used by fts1 will be
   39: # the defaults.
   40: do_test fts1j-1.1 {
   41:   execsql {
   42:     ATTACH DATABASE 'test2.db' AS two;
   43:     SELECT rowid FROM t1 WHERE t1 MATCH 'hello';
   44:     DETACH DATABASE two;
   45:   }
   46: } {1 2}
   47: # Make certain we're detached if there was an error.
   48: catch {db eval {DETACH DATABASE two}}
   49: 
   50: # In older code, this appears to work fine, but the t2_* tables used
   51: # by fts1 will be created in database 'main' instead of database
   52: # 'two'.  It appears to work fine because the tables end up being the
   53: # defaults, but obviously is badly broken if you hope to use things
   54: # other than in the exact same ATTACH setup.
   55: do_test fts1j-1.2 {
   56:   execsql {
   57:     ATTACH DATABASE 'test2.db' AS two;
   58:     CREATE VIRTUAL TABLE two.t2 USING fts1(content);
   59:     INSERT INTO t2 (rowid, content) VALUES(1, "hello world");
   60:     INSERT INTO t2 (rowid, content) VALUES(2, "hello there");
   61:     INSERT INTO t2 (rowid, content) VALUES(3, "cruel world");
   62:     SELECT rowid FROM t2 WHERE t2 MATCH 'hello';
   63:     DETACH DATABASE two;
   64:   }
   65: } {1 2}
   66: catch {db eval {DETACH DATABASE two}}
   67: 
   68: # In older code, this broke because the fts1 code attempted to create
   69: # t3_* tables in database 'main', but they already existed.  Normally
   70: # this wouldn't happen without t3 itself existing, in which case the
   71: # fts1 code would never be called in the first place.
   72: do_test fts1j-1.3 {
   73:   execsql {
   74:     ATTACH DATABASE 'test2.db' AS two;
   75: 
   76:     CREATE VIRTUAL TABLE two.t3 USING fts1(content);
   77:     INSERT INTO two.t3 (rowid, content) VALUES(2, "hello there");
   78:     INSERT INTO two.t3 (rowid, content) VALUES(3, "cruel world");
   79:     SELECT rowid FROM two.t3 WHERE t3 MATCH 'hello';
   80: 
   81:     DETACH DATABASE two;
   82:   } db2
   83: } {2}
   84: catch {db eval {DETACH DATABASE two}}
   85: 
   86: catch {db2 close}
   87: forcedelete test2.db
   88: 
   89: finish_test