Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add tests for running FTS 'merge' and 'optimize' commands in shared cache mode. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
09e5a7ad85dc592fce868a2d0f8719c6 |
User & Date: | dan 2013-05-29 14:22:19.357 |
Context
2013-05-29
| ||
17:48 | Updates to the Codec interface to support codecs on attached databases and to allow rekeying in the middle of a transaction. These changes are only applicable if SQLite is compiled with SQLITE_HAS_CODEC. (check-in: d5b084e9d8 user: drh tags: trunk) | |
14:22 | Add tests for running FTS 'merge' and 'optimize' commands in shared cache mode. (check-in: 09e5a7ad85 user: dan tags: trunk) | |
2013-05-28
| ||
20:25 | Add the percentile() SQL function as a loadable extension in the ext/misc directory. (check-in: a64d760d92 user: drh tags: trunk) | |
Changes
Added test/fts4merge4.test.
> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 | # 2013 May 29 # # The author disclaims copyright to this source code. In place of # a legal notice, here is a blessing: # # May you do good and not evil. # May you find forgiveness for yourself and forgive others. # May you share freely, never taking more than you give. # #************************************************************************* # This file implements regression tests for SQLite library. # set testdir [file dirname $argv0] source $testdir/tester.tcl source $testdir/fts3_common.tcl set ::testprefix fts4merge4 ifcapable !fts3 { finish_test return } set ::enable_shared_cache [sqlite3_enable_shared_cache 1] do_execsql_test 1.1 { CREATE VIRTUAL TABLE t1 USING fts4 } do_test 1.2 { for {set i 0} {$i < 2000} {incr i} { execsql {INSERT INTO t1 VALUES('a b c d e f g h i j k l');} } } {} do_test 1.3 { execsql BEGIN for {set i 0} {$i < 2000} {incr i} { execsql {INSERT INTO t1 VALUES('a b c d e f g h i j k l');} } execsql { INSERT INTO t1(t1) VALUES('merge=8,50'); COMMIT } } {} reset_db do_execsql_test 2.0 { CREATE VIRTUAL TABLE t1 USING fts4 } do_test 2.1 { for {set i 0} {$i < 2000} {incr i} { execsql {INSERT INTO t1 VALUES('a b c d e f g h i j k l');} } } {} do_execsql_test 2.2 { SELECT count(*) FROM t1_segdir; } 35 do_execsql_test 2.3 { INSERT INTO t1(t1) VALUES('optimize') } {} do_execsql_test 2.4 { SELECT count(*) FROM t1_segdir; } 1 sqlite3_enable_shared_cache $::enable_shared_cache finish_test |