/ File History
Login

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

History of test/whereG.test

2019-08-22
16:38
Fix the likely(), unlikely(), and likelihood() functions so that they have no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] file: [4cda56de] check-in: [44578865] user: drh branch: trunk, size: 9601
2018-10-05
20:09
When the left-hand side of a WHERE clause contraint is a UNIQUE column, and that term of the WHERE clause is not used for indexing, assume that the term reduces the number of output rows by half. This is one proposed fix for ticket [e8b674241947eb3ba4] file: [0b2ef829] check-in: [5c243eec] user: drh branch: unique-constraint-weights, size: 8592
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: [01587832] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 8560
2015-06-20
13:18
Make sure that the likelihood() function does not mess up generation of result-set code when it is used (inappropropriately) in a result-set expression. file: [dde4c52a] check-in: [7cdbae62] user: drh branch: trunk, size: 8640
2015-06-18
14:32
Pervent the likelihood() function from moving ON clause terms of a LEFT JOIN into the WHERE clause. Fix for ticket [5f60b11fc8e23490e2] file: [a9fa7c84] check-in: [ed96e14a] user: drh branch: trunk, size: 8008
2014-06-17
16:11
Add the likely() function for symmetry with unlikely(). The likely(X) function means the same thing as likelihood(X,0.9375). file: [69f5ec4b] check-in: [38965484] user: drh branch: trunk, size: 7510
2014-04-25
20:22
If the user provides likelihood() data for a WHERE clause term used as part of an index key, have the planner use it when calculating the expected number of rows visited by the loop. file: [0ac23e5e] check-in: [c51efaa5] user: dan branch: experimental-costs, size: 7251
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: [8189fedf] check-in: [c5a6ec0a] user: dan branch: experimental-costs, size: 6895
2014-04-03
16:29
Use OP_Copy instead of OP_SCopy when moving results out of a subquery, to prevent the subquery results from changing out from under the outer query. Fix for ticket [98825a79ce1456]. Problem introduced by check-in [1e64dd782a126f48d78]. file: [2533b72e] check-in: [d5513dfa] user: drh branch: trunk, size: 6095
2014-03-19
23:24
Fix query planner weights associated with choosing block-sorting. Fix block sorting of tables with collating functions. Fix various test cases. All "veryquick" tests are now passing, though more tests need to be added. file: [eb3a46b3] check-in: [01afbf97] user: drh branch: orderby-planning, size: 5732
2013-09-11
17:39
Improvements to likelihood processing so that commuting an unindexed term in the WHERE clause does not change the query plan. file: [2a3d5181] check-in: [6e6bded0] user: drh branch: unlikely-func, size: 5696
14:34
Additional unlikely() test cases. Logic tweaks to support test coverage. file: [5e695423] check-in: [5d00cce7] user: drh branch: unlikely-func, size: 4986
11:38
Change the name of the two-argument unlikely() function to likelihood(). Add test cases. file: [fa2da659] check-in: [29a359b8] user: drh branch: unlikely-func, size: 2674 Added