# 2007 February 6

#

# The author disclaims copyright to this source code.

#

#*************************************************************************

# This file implements regression tests for SQLite library.  This

# tests creating fts1 tables in an attached database.

#

# $Id: fts1j.test,v 1.1 2007/02/07 01:01:18 shess Exp $

#

set testdir [file dirname $argv0]

source $testdir/tester.tcl

# If SQLITE_ENABLE_FTS1 is defined, omit this file.

ifcapable !fts1 {

  finish_test

  return

}

# Clean up anything left over from a previous pass.

file delete -force test2.db

file delete -force test2.db-journal

sqlite3 db2 test2.db

db eval {

  CREATE VIRTUAL TABLE t3 USING fts1(content);

  INSERT INTO t3 (rowid, content) VALUES(1, "hello world");

}

db2 eval {

  CREATE VIRTUAL TABLE t1 USING fts1(content);

  INSERT INTO t1 (rowid, content) VALUES(1, "hello world");

  INSERT INTO t1 (rowid, content) VALUES(2, "hello there");

  INSERT INTO t1 (rowid, content) VALUES(3, "cruel world");

}

# This has always worked because the t1_* tables used by fts1 will be

# the defaults.

do_test fts1j-1.1 {

  execsql {

    ATTACH DATABASE 'test2.db' AS two;

    SELECT rowid FROM t1 WHERE t1 MATCH 'hello';

    DETACH DATABASE two;

  }

} {1 2}

# Make certain we're detached if there was an error.

catch {db eval {DETACH DATABASE two}}

# In older code, this appears to work fine, but the t2_* tables used

# by fts1 will be created in database 'main' instead of database

# 'two'.  It appears to work fine because the tables end up being the

# defaults, but obviously is badly broken if you hope to use things

# other than in the exact same ATTACH setup.

do_test fts1j-1.2 {

  execsql {

    ATTACH DATABASE 'test2.db' AS two;

    CREATE VIRTUAL TABLE two.t2 USING fts1(content);

    INSERT INTO t2 (rowid, content) VALUES(1, "hello world");

    INSERT INTO t2 (rowid, content) VALUES(2, "hello there");

    INSERT INTO t2 (rowid, content) VALUES(3, "cruel world");

    SELECT rowid FROM t2 WHERE t2 MATCH 'hello';

    DETACH DATABASE two;

  }

} {1 2}

catch {db eval {DETACH DATABASE two}}

# In older code, this broke because the fts1 code attempted to create

# t3_* tables in database 'main', but they already existed.  Normally

# this wouldn't happen without t3 itself existing, in which case the

# fts1 code would never be called in the first place.

do_test fts1j-1.3 {

  execsql {

    ATTACH DATABASE 'test2.db' AS two;

    CREATE VIRTUAL TABLE two.t3 USING fts1(content);

    INSERT INTO two.t3 (rowid, content) VALUES(2, "hello there");

    INSERT INTO two.t3 (rowid, content) VALUES(3, "cruel world");

    SELECT rowid FROM two.t3 WHERE t3 MATCH 'hello';

    DETACH DATABASE two;

  } db2

} {2}

catch {db eval {DETACH DATABASE two}}

catch {db2 close}

file delete -force test2.db

finish_test