AryaWu/sqlite

1# 2023 December 162#3#    May you do good and not evil.4#    May you find forgiveness for yourself and forgive others.5#    May you share freely, never taking more than you give.6#7#***********************************************************************8# This file runs all tests.9#10# $Id: fts3.test,v 1.2 2008/07/23 18:17:32 drh Exp $11 12set testdir [file dirname $argv0]13source $testdir/tester.tcl14set ::testprefix fts3integrity15 16# If SQLITE_ENABLE_FTS3 is defined, omit this file.17ifcapable !fts3 {18  finish_test19  return20}21  22do_execsql_test 1.0 {23  CREATE VIRTUAL TABLE t1 USING fts3(x);24  INSERT INTO t1 VALUES('first row');25  INSERT INTO t1 VALUES('second row');26 27  CREATE TABLE t2(x PRIMARY KEY);28  INSERT INTO t2 VALUES('first row');29  INSERT INTO t2 VALUES('second row');30}31 32sqlite3 db2 test.db33 34do_execsql_test -db db2 1.1 {35  CREATE TABLE t3(x, y);36}37 38do_execsql_test 1.2 {39  PRAGMA integrity_check;40} {ok}41 42finish_test43