/
niceSOFT
/
sqlite
Обзор
Документация
Войти
/
niceSOFT
/
sqlite
Код
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
test/fts4min.test
53 строки
1 KB
dan
Optimization for "SELECT min(x) FROM tbl" where "x" is indexed and NOT NULL. This also allows similar queries on NOT NULL virtual table columns to be optimized.
27 фев 2020, 18:07
27 фев 2020, 18:07
67e2bb9
Код
Авторство
О чём код?
# 2020 February 27 # # 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. # #************************************************************************* # set testdir [file dirname $argv0] source $testdir/tester.tcl source $testdir/fts3_common.tcl set ::testprefix fts4min # If SQLITE_ENABLE_FTS3 is defined, omit this file. ifcapable !fts3 { finish_test return } #------------------------------------------------------------------ do_execsql_test 0.0 { CREATE TABLE t1(a NOT NULL, b); CREATE INDEX i1 ON t1(a); } do_execsql_test 1.0 { CREATE VIRTUAL TABLE ft USING fts3(c); INSERT INTO ft(docid, c) VALUES(22, 'hello world'); INSERT INTO ft(docid, c) VALUES(44, 'hello world'); INSERT INTO ft(docid, c) VALUES(11, 'hello world'); } do_eqp_test 1.1.1 { SELECT max(rowid) FROM ft } {VIRTUAL TABLE INDEX 0:DESC} do_eqp_test 1.1.2 { SELECT min(rowid) FROM ft } {VIRTUAL TABLE INDEX 0:ASC} do_execsql_test 1.2.1 { SELECT max(rowid) FROM ft } {44} do_execsql_test 1.2.2 { SELECT min(rowid) FROM ft } {11} finish_test