Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/whereG.test
|
2019-12-31
| ||
| 12:18 | The OP_ResultRow opcode releases the SCopy dependences on all its registers, as the values in those registers will not be reused. file: [c9378b28] check-in: [1dc83c5d] user: drh branch: trunk, size: 9977 | |
|
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 | |