SQLite

All files named ”test/fts3query.test”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/fts3query.test

2021-03-20
15:11
[45806a3029] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 9837)
2018-11-07
02:17
[ca033ff2eb] part of check-in [3212733cb6] Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. (check-in: [3212733cb6] user: drh branch: read-only-shadow, size: 9885)
2018-11-06
19:26
[b911e997a4] part of check-in [a1d6c6712c] Enable DEFENSIVE mode by default for tests. This requires lots of case of turning DEFENSIVE off in order to dodgy things to the database for testing purposes. No all of those cases are yet handled, so "make test" does not run to completion. (check-in: [a1d6c6712c] user: drh branch: read-only-shadow, size: 9918)
2018-05-02
18:00
[ca5dffabdf] part of check-in [5f0e803e33] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e33] user: drh branch: rework-EQP, size: 9852)
2015-05-05
20:39
[f33eb71a1f] part of check-in [b9b77972d8] Add the fts3 matchinfo 'b' flag. (check-in: [b9b77972d8] user: dan branch: fts3-matchinfo-y, size: 9844)
2015-03-16
17:07
[c838b18f2b] part of check-in [f61fd24b4d] Modify the fts3query.test script so that it works even when testfixture is built using a version of TCL that is unable to sort the integer -9223372036854775808 (check-in: [f61fd24b4d] user: drh branch: trunk, size: 9843)
2015-01-29
11:52
[d81ffb0ab1] part of check-in [85dc12625d] Optimize range constraints on the rowid column of fts3/4 tables even if there is no MATCH clause in the query. (check-in: [85dc12625d] user: dan branch: trunk, size: 9625)
2013-06-10
23:30
[4fefd43ff2] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 7737)
2013-06-03
15:24
[00b519001b] part of check-in [7d91f68881] Virtual tables now always report 25 rows instead of 0 rows in the EXPLAIN QUERY PLAN output. Adjust tests accordingly. (check-in: [7d91f68881] user: drh branch: nextgen-query-plan-exp, size: 7843)
2012-08-25
00:49
[682cf2855e] part of check-in [865dfcbaa5] Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (check-in: [865dfcbaa5] user: drh branch: branch-3.7.2, size: 4436)
2010-11-23
19:16
[ef79d31fdb] part of check-in [9cf0f2b76b] Experimental changes to fts3 function matchinfo(). (check-in: [9cf0f2b76b] user: dan branch: fts3-experimental, size: 7842)
2010-11-15
16:12
[df864f4c9b] part of check-in [88a854e18f] Change some test cases to account for the new EXPLAIN QUERY PLAN output. (check-in: [88a854e18f] user: dan branch: trunk, size: 7785)
2010-10-25
19:01
[724a662dbb] part of check-in [918b609290] Further improvements to coverage of fts3.c. Fixes for bugs revealed by the same. (check-in: [918b609290] user: dan branch: experimental, size: 7631)
12:47
[464bc03de2] part of check-in [a8b1d99899] Test coverage improvements for fts3.c. (check-in: [a8b1d99899] user: dan branch: experimental, size: 7631)
2010-05-04
11:06
[2468caf793] part of check-in [232dbe8ece] Fix a typo in walfault.test. (check-in: [232dbe8ece] user: dan branch: trunk, size: 4429)
2010-03-27
09:44
[1acb21b58d] part of check-in [9e075e70f0] Increase the estimated cost of using a virtual table as the outer loop of a join when there exists an ORDER BY clause that is not satisfied by the virtual table. Fix for [775b39dd3c]. (check-in: [9e075e70f0] user: dan branch: trunk, size: 4395)
2010-01-12
17:57
[154fe4b015] part of check-in [dd9689b7c3] Update comments in fts3_snippet.c. (check-in: [dd9689b7c3] user: dan branch: trunk, size: 3295)
2010-01-02
19:02
[ca21717993] part of check-in [51f7ee8440] Add experimental implementation of FTS3 functions matchinfo() and snippet() (not enabled by default). (check-in: [51f7ee8440] user: dan branch: trunk, size: 3293)
2009-12-22
18:56
[2cba25181d] part of check-in [37a1de02d1] Add the experimental FTS3 matchinfo() function. Provides details of the match that may be used for result ranking and other purposes. (check-in: [37a1de02d1] user: dan branch: trunk, size: 3704)
2009-12-20
15:00
Added: [5561e1feed] part of check-in [956de051f4] Fix a problem in FTS3 phrase queries. Add tests to check that it really is fixed. (check-in: [956de051f4] user: dan branch: trunk, size: 3015)