/ File History
Login

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

History of test/whereJ.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: [88287550] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 105392
2014-12-04
20:24
Performance enhancement for single-table queries with many OR-connected WHERE clause terms and multiple indexes with the same left-most columns. file: [55a32217] check-in: [1461d543] user: drh branch: trunk, size: 105416
2014-09-06
02:00
Fix a couple of typos in comments. No changes to code. file: [63599653] check-in: [a758465e] user: mistachkin branch: trunk, size: 104378
01:35
Query planner heuristic update: When doing a full table scan on a table that has an equality constraint on an unindexed column, do not allow the estimated number of output rows to be greater than half the total number of rows in the table. file: [1c351691] check-in: [73954f93] user: drh branch: trunk, size: 104381
2014-08-28
16:01
Fix a problem causing an inaccurate stat4-based estimate for the number of rows visited by a range scan. file: [8880784c] check-in: [052d89b5] user: dan branch: stat4-experimental, size: 88287
2014-08-07
16:50
Oops! This check-in was on trunk. But it contains a debugging printf(). Original comment: When the estimated cost to do a sort overwhelms the estimated cost to do individual table lookups, make sure that the table lookup costs are still taken into consideration when selecting the lookup algorithm. file: [35a40a50] check-in: [ec5d84ba] user: drh branch: query-planner-fix, size: 87024
2014-06-06
20:49
Add a test case to ensure that estLog() works for negative numbers. file: [7dde2828] check-in: [813469d9] user: drh branch: trunk, size: 85590 Added