mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 22:39:05 +00:00
9ed72eb5ae
This merges the version-3.45.1 tag from upstream SQLite git repository to libSQL with the following conflicts resolved: Conflicts: README.md ext/jni/src/org/sqlite/jni/capi/ConfigSqllogCallback.java libsql-sqlite3/configure libsql-sqlite3/doc/jsonb.md libsql-sqlite3/ext/fts5/test/fts5faultH.test libsql-sqlite3/ext/fts5/test/fts5origintext.test libsql-sqlite3/ext/fts5/test/fts5origintext2.test libsql-sqlite3/ext/fts5/test/fts5origintext3.test libsql-sqlite3/ext/fts5/test/fts5origintext4.test libsql-sqlite3/ext/fts5/test/fts5origintext5.test libsql-sqlite3/ext/fts5/test/fts5secure8.test libsql-sqlite3/ext/fts5/test/fts5tokenizer2.test libsql-sqlite3/ext/fts5/test/fts5trigram2.test libsql-sqlite3/ext/jni/src/org/sqlite/jni/annotation/Experimental.java libsql-sqlite3/ext/jni/src/org/sqlite/jni/capi/ConfigSqlLogCallback.java libsql-sqlite3/ext/jni/src/org/sqlite/jni/capi/ConfigSqllogCallback.java libsql-sqlite3/ext/jni/src/org/sqlite/jni/wrapper1/WindowFunction.java libsql-sqlite3/ext/wasm/GNUmakefile libsql-sqlite3/ext/wasm/batch-runner-sahpool.html libsql-sqlite3/ext/wasm/batch-runner-sahpool.js libsql-sqlite3/src/pager.c libsql-sqlite3/src/shell.c.in libsql-sqlite3/src/sqliteInt.h libsql-sqlite3/src/wal.c libsql-sqlite3/test/fts3integrity.test libsql-sqlite3/test/json/jsonb-q1.txt libsql-sqlite3/test/json106.test libsql-sqlite3/test/json107.test libsql-sqlite3/test/jsonb01.test libsql-sqlite3/test/mmapcorrupt.test libsql-sqlite3/test/releasetest_data.tcl libsql-sqlite3/test/shell9.test libsql-sqlite3/test/wapp.tcl libsql-sqlite3/test/wapptest.tcl
90 lines
1.9 KiB
Plaintext
90 lines
1.9 KiB
Plaintext
# 2023 Nov 03
|
|
#
|
|
# 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.
|
|
#
|
|
#***********************************************************************
|
|
#
|
|
# Tests focusing on the built-in fts5 tokenizers.
|
|
#
|
|
|
|
source [file join [file dirname [info script]] fts5_common.tcl]
|
|
set testprefix fts5tokenizer2
|
|
|
|
# If SQLITE_ENABLE_FTS5 is defined, omit this file.
|
|
ifcapable !fts5 {
|
|
finish_test
|
|
return
|
|
}
|
|
|
|
sqlite3_fts5_create_tokenizer db tst get_tst_tokenizer
|
|
proc get_tst_tokenizer {args} {
|
|
return "tst_tokenizer"
|
|
}
|
|
proc tst_tokenizer {flags txt} {
|
|
set token ""
|
|
set lTok [list]
|
|
|
|
foreach c [split $txt {}] {
|
|
if {$token==""} {
|
|
append token $c
|
|
} else {
|
|
set t1 [string is upper $token]
|
|
set t2 [string is upper $c]
|
|
|
|
if {$t1!=$t2} {
|
|
lappend lTok $token
|
|
set token ""
|
|
}
|
|
append token $c
|
|
}
|
|
}
|
|
if {$token!=""} { lappend lTok $token }
|
|
|
|
set iOff 0
|
|
foreach t $lTok {
|
|
set n [string length $t]
|
|
sqlite3_fts5_token $t $iOff [expr $iOff+$n]
|
|
incr iOff $n
|
|
}
|
|
}
|
|
|
|
do_execsql_test 1.0 {
|
|
CREATE VIRTUAL TABLE t1 USING fts5(t, tokenize=tst);
|
|
}
|
|
|
|
do_execsql_test 1.1 {
|
|
INSERT INTO t1 VALUES('AAdontBBmess');
|
|
}
|
|
|
|
do_execsql_test 1.2 {
|
|
SELECT snippet(t1, 0, '>', '<', '...', 4) FROM t1('BB');
|
|
} {AAdont>BB<mess}
|
|
|
|
do_execsql_test 1.3 {
|
|
SELECT highlight(t1, 0, '>', '<') FROM t1('BB');
|
|
} {AAdont>BB<mess}
|
|
|
|
do_execsql_test 1.4 {
|
|
SELECT highlight(t1, 0, '>', '<') FROM t1('AA');
|
|
} {>AA<dontBBmess}
|
|
|
|
do_execsql_test 1.5 {
|
|
SELECT highlight(t1, 0, '>', '<') FROM t1('dont');
|
|
} {AA>dont<BBmess}
|
|
|
|
do_execsql_test 1.6 {
|
|
SELECT highlight(t1, 0, '>', '<') FROM t1('mess');
|
|
} {AAdontBB>mess<}
|
|
|
|
do_execsql_test 1.7 {
|
|
SELECT highlight(t1, 0, '>', '<') FROM t1('BB mess');
|
|
} {AAdont>BBmess<}
|
|
|
|
|
|
finish_test
|