/ File History
Login

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

History of test/fts3join.test

2018-05-02
18:00
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. file: [949b4f5a] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 2958
2017-07-18
17:34
Do not use the flattening optimization for a sub-query on the RHS of a LEFT JOIN if that subquery reads data from a virtual table. Because it prevents the planner from creating an automatic index on the results of the sub-query, the flattening optimization sometimes slows things down in this case. file: [69aeb460] check-in: [9dbae1df] user: dan branch: trunk, size: 2929
2017-06-27
16:39
Fix a virtual table problem that can occur when the vtab is on the RHS of a LEFT JOIN and there is a MATCH constraint in the ON clause, or when the vtab is in a sub-query that is the RHS of a LEFT JOIN and there is a MATCH constraint in the WHERE clause of the sub-query. file: [a758accc] check-in: [87b38166] user: dan branch: trunk, size: 2310
2016-02-05
16:46
From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. file: [34750f3c] check-in: [a6b35273] user: drh branch: trunk, size: 1864
2014-01-04
14:42
Instead of having the planner ignore plans with unusable MATCH constraints, have FTS assign extremely high costs to such plans in order to discourage the planner from using them. file: [53e66a0c] check-in: [24f84b38] user: dan branch: avoid-unusable-match, size: 1866
14:16
Have the planner detect cases where a MATCH constraint is applied to a virtual table, and ignore any plans that do not allow the virtual table implementation to implement the MATCH filtering. file: [bc8e5ca3] check-in: [19f3208b] user: dan branch: avoid-unusable-match, size: 1830 Added