/ File History
Login

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

History of test/where3.test

2018-05-02
19:42
More test case updates. Tests are all running now. file: [2341a294] check-in: [dab5e529] user: drh branch: rework-EQP, size: 15606
2016-06-17
14:59
Fix a duplicate test name in cursorhint2.test. file: [54cdeb02] check-in: [fcd12b69] user: dan branch: cursor-hints, size: 15703
2014-04-24
20:04
Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. file: [1ad55ba9] check-in: [c5a6ec0a] user: dan branch: experimental-costs, size: 15675
2013-08-20
17:00
Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns. file: [d28c51f2] check-in: [e476408e] user: drh branch: trunk, size: 15635
2013-06-28
13:43
Fix an issue with the OmitNoopJoin optimization and add test cases that are specifically for that optimization. file: [a0682ba3] check-in: [5480d124] user: drh branch: trunk, size: 15466
2013-06-12
17:08
"make test" now passing. file: [15707152] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 13966
2013-06-11
02:32
Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. file: [f2a7027e] check-in: [36373b85] user: drh branch: nextgen-query-plan-logcost, size: 13911
2013-06-10
23:30
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [1f2a9c99] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 13911
2013-06-04
23:40
Update some variable names and comments in the ORDER BY optimizer. Fix a bug in the ORDER BY optimizer dealing with IS NULL constraints. Updates to test cases. file: [311c04e1] check-in: [cf96eb59] user: drh branch: nextgen-query-plan-exp, size: 14176
2013-06-03
22:08
Remove more vestiges of sqlite_query_plan from the test cases. file: [ae3054e1] check-in: [eb27086e] user: drh branch: nextgen-query-plan-exp, size: 14182
2011-10-18
18:10
Improved handling of USING and NATURAL JOIN in 3-way and higher joins. Ticket [3338b3fa19ac4ab] file: [667e7564] check-in: [551ce407] user: drh branch: trunk, size: 13893
2011-08-26
18:04
Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. file: [eaed73b9] check-in: [a42db19d] user: drh branch: stat3-3.7.2, size: 8376
2011-03-30
14:54
Do not generate sqlite_stat1 entries for empty tables when running ANALYZE. Ticket [83ea97620bd31016451] file: [8e1175c7] check-in: [3a27af5b] user: drh branch: trunk, size: 11140
2011-02-12
14:23
Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. file: [3bd3848a] check-in: [f2a8b5cc] user: drh branch: branch-3.7.2, size: 8366
2011-02-04
06:36
Merge the stat2 query planner enhancements into the trunk. file: [c81d4ecf] check-in: [499edcbc] user: drh branch: trunk, size: 11109
2011-01-28
01:57
Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. file: [858d089c] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 11114
2010-11-13
16:42
Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. file: [8ebedae5] check-in: [6611b76b] user: dan branch: experimental, size: 11109
2010-11-11
10:36
Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [6fc33631] check-in: [30904ef8] user: dan branch: experimental, size: 11059
2010-10-04
23:55
Fix a performance regression (relative to version 3.6.23.1) caused by the query planner taking into account non-indexable WHERE clause terms to select the outermost join loops when it should be selecting tables for the outermost loop that do not benefit from being in an inner loop. file: [3a72db38] check-in: [ece641eb] user: drh branch: trunk, size: 10535
2010-08-05
02:52
Fix the query planner so that when it has a choice of full-scan tables to move to the outer loop, it chooses the one that is likely to give the fewest output rows. Ticket [13f033c865f878]. file: [3bf8006d] check-in: [309bbedf] user: drh branch: trunk, size: 8054
2010-08-04
21:17
If the outer loop of a join must be a full table scan, make sure that an incomplete ANALYZE does not trick the planner into use a table that might be indexable in an inner loop. Ticket [13f033c865f878] file: [acdacc5e] check-in: [e7a714b5] user: drh branch: trunk, size: 7174
2010-04-15
01:04
Further refinements to table order selection on join query planning. file: [aa44a9b2] check-in: [defaf0d9] user: drh branch: trunk, size: 6444
2008-04-17
19:14
Additional work on ticket #3015. The previous fix (check-in (4919)) did not appear to work in all cases and it disabled indexing in some places where it should not have. New test cases added to help insure that the current fix is better. (CVS 5026) file: [97d3936e] check-in: [0d2e258e] user: drh branch: trunk, size: 6444
2006-12-16
16:25
Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table to be reordered with A and B. This used to be the case but the capability was removed by (3203) and (3052) in response to ticket #1652. This change restores the capability. (CVS 3529) file: [0a30fe98] check-in: [7393c81b] user: drh branch: trunk, size: 4900
2006-06-06
11:45
In joins of the form "A left B, C" make sure they are not transformed into "A left C, B". Ticket #1830. See also #1652. (CVS 3203) file: [3b5ad2c5] check-in: [2baa9836] user: drh branch: trunk, size: 2827
2006-02-01
02:45
In joins of the form: "A, B left C" make sure that the reordering optimization does not put table A after table C. Ticket #1652. (CVS 3052) file: [6356013c] check-in: [248b9be9] user: drh branch: trunk, size: 1435 Added