AryaWu/sqlite

1# 2020 February 272#3# The author disclaims copyright to this source code.  In place of4# a legal notice, here is a blessing:5#6#    May you do good and not evil.7#    May you find forgiveness for yourself and forgive others.8#    May you share freely, never taking more than you give.9#10#*************************************************************************11#12 13set testdir [file dirname $argv0]14source $testdir/tester.tcl15source $testdir/fts3_common.tcl16set ::testprefix fts4min17 18# If SQLITE_ENABLE_FTS3 is defined, omit this file.19ifcapable !fts3 {20  finish_test21  return22}23 24#------------------------------------------------------------------25do_execsql_test 0.0 {26  CREATE TABLE t1(a NOT NULL, b);27  CREATE INDEX i1 ON t1(a);28}29 30do_execsql_test 1.0 {31  CREATE VIRTUAL TABLE ft USING fts3(c);32  INSERT INTO ft(docid, c) VALUES(22, 'hello world');33  INSERT INTO ft(docid, c) VALUES(44, 'hello world');34  INSERT INTO ft(docid, c) VALUES(11, 'hello world');35}36 37do_eqp_test 1.1.1 {38  SELECT max(rowid) FROM ft39} {VIRTUAL TABLE INDEX 0:DESC}40 41do_eqp_test 1.1.2 {42  SELECT min(rowid) FROM ft43} {VIRTUAL TABLE INDEX 0:ASC}44 45do_execsql_test 1.2.1 {46  SELECT max(rowid) FROM ft47} {44}48 49do_execsql_test 1.2.2 {50  SELECT min(rowid) FROM ft51} {11}52 53finish_test54