/ All files named "test/where3.test"
Login

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

History for test/where3.test

2018-05-02
19:42
[2341a294] part of check-in [dab5e529] More test case updates. Tests are all running now. (check-in: [dab5e529] user: drh branch: rework-EQP, size: 15606)
2016-06-17
14:59
[54cdeb02] part of check-in [fcd12b69] Fix a duplicate test name in cursorhint2.test. (check-in: [fcd12b69] user: dan branch: cursor-hints, size: 15703)
2014-04-24
20:04
[1ad55ba9] part of check-in [c5a6ec0a] Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. (check-in: [c5a6ec0a] user: dan branch: experimental-costs, size: 15675)
2013-08-20
17:00
[d28c51f2] part of check-in [e476408e] Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns. (check-in: [e476408e] user: drh branch: trunk, size: 15635)
2013-06-28
13:43
[a0682ba3] part of check-in [5480d124] Fix an issue with the OmitNoopJoin optimization and add test cases that are specifically for that optimization. (check-in: [5480d124] user: drh branch: trunk, size: 15466)
2013-06-12
17:08
[15707152] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 13966)
2013-06-11
02:32
[f2a7027e] part of check-in [36373b85] Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. (check-in: [36373b85] user: drh branch: nextgen-query-plan-logcost, size: 13911)
2013-06-10
23:30
[1f2a9c99] part of check-in [aa580e36] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 13911)
2013-06-04
23:40
[311c04e1] part of check-in [cf96eb59] 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. (check-in: [cf96eb59] user: drh branch: nextgen-query-plan-exp, size: 14176)
2013-06-03
22:08
[ae3054e1] part of check-in [eb27086e] Remove more vestiges of sqlite_query_plan from the test cases. (check-in: [eb27086e] user: drh branch: nextgen-query-plan-exp, size: 14182)
2011-10-18
18:10
[667e7564] part of check-in [551ce407] Improved handling of USING and NATURAL JOIN in 3-way and higher joins. Ticket [3338b3fa19ac4ab] (check-in: [551ce407] user: drh branch: trunk, size: 13893)
2011-08-26
18:04
[eaed73b9] part of check-in [a42db19d] Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. (check-in: [a42db19d] user: drh branch: stat3-3.7.2, size: 8376)
2011-03-30
14:54
[8e1175c7] part of check-in [3a27af5b] Do not generate sqlite_stat1 entries for empty tables when running ANALYZE. Ticket [83ea97620bd31016451] (check-in: [3a27af5b] user: drh branch: trunk, size: 11140)
2011-02-12
14:23
[3bd3848a] part of check-in [f2a8b5cc] 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. (check-in: [f2a8b5cc] user: drh branch: branch-3.7.2, size: 8366)
2011-02-04
06:36
[c81d4ecf] part of check-in [499edcbc] Merge the stat2 query planner enhancements into the trunk. (check-in: [499edcbc] user: drh branch: trunk, size: 11109)
2011-01-28
01:57
[858d089c] part of check-in [4847c6cb] 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. (check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 11114)
2010-11-13
16:42
[8ebedae5] part of check-in [6611b76b] 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. (check-in: [6611b76b] user: dan branch: experimental, size: 11109)
2010-11-11
10:36
[6fc33631] part of check-in [30904ef8] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef8] user: dan branch: experimental, size: 11059)
2010-10-04
23:55
[3a72db38] part of check-in [ece641eb] 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. (check-in: [ece641eb] user: drh branch: trunk, size: 10535)
2010-08-05
02:52
[3bf8006d] part of check-in [309bbedf] 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]. (check-in: [309bbedf] user: drh branch: trunk, size: 8054)
2010-08-04
21:17
[acdacc5e] part of check-in [e7a714b5] 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] (check-in: [e7a714b5] user: drh branch: trunk, size: 7174)
2010-04-15
01:04
[aa44a9b2] part of check-in [defaf0d9] Further refinements to table order selection on join query planning. (check-in: [defaf0d9] user: drh branch: trunk, size: 6444)
2008-04-17
19:14
[97d3936e] part of check-in [0d2e258e] 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) (check-in: [0d2e258e] user: drh branch: trunk, size: 6444)
2006-12-16
16:25
[0a30fe98] part of check-in [7393c81b] 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) (check-in: [7393c81b] user: drh branch: trunk, size: 4900)
2006-06-06
11:45
[3b5ad2c5] part of check-in [2baa9836] 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) (check-in: [2baa9836] user: drh branch: trunk, size: 2827)
2006-02-01
02:45
Added: [6356013c] part of check-in [248b9be9] 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) (check-in: [248b9be9] user: drh branch: trunk, size: 1435)