/ History for test/whereG.test
Login

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

History for test/whereG.test

2020-06-14
13:40
[9363b2a9] part of check-in [90b1169d] Check-in [1d4f86201dab9a22] changed a testcase() to an assert() because we didn't know how to reach that condition any more. But YongHeng's fuzzer found a way. So now we change it back. Ticket [9fb26d37cefaba40]. (check-in: [90b1169d] user: drh branch: trunk, size: 10285)
2019-12-31
12:18
[c9378b28] part of check-in [1dc83c5d] The OP_ResultRow opcode releases the SCopy dependences on all its registers, as the values in those registers will not be reused. (check-in: [1dc83c5d] user: drh branch: trunk, size: 9977)
2019-08-22
16:38
[4cda56de] part of check-in [44578865] Fix the likely(), unlikely(), and likelihood() functions so that they have no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] (check-in: [44578865] user: drh branch: trunk, size: 9601)
2018-10-05
20:09
[0b2ef829] part of check-in [5c243eec] 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] (check-in: [5c243eec] user: drh branch: unique-constraint-weights, size: 8592)
2018-05-02
18:00
[01587832] part of check-in [5f0e803e] 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. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 8560)
2015-06-20
13:18
[dde4c52a] part of check-in [7cdbae62] 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. (check-in: [7cdbae62] user: drh branch: trunk, size: 8640)
2015-06-18
14:32
[a9fa7c84] part of check-in [ed96e14a] Pervent the likelihood() function from moving ON clause terms of a LEFT JOIN into the WHERE clause. Fix for ticket [5f60b11fc8e23490e2] (check-in: [ed96e14a] user: drh branch: trunk, size: 8008)
2014-06-17
16:11
[69f5ec4b] part of check-in [38965484] Add the likely() function for symmetry with unlikely(). The likely(X) function means the same thing as likelihood(X,0.9375). (check-in: [38965484] user: drh branch: trunk, size: 7510)
2014-04-25
20:22
[0ac23e5e] part of check-in [c51efaa5] 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. (check-in: [c51efaa5] user: dan branch: experimental-costs, size: 7251)
2014-04-24
20:04
[8189fedf] 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: 6895)
2014-04-03
16:29
[2533b72e] part of check-in [d5513dfa] 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]. (check-in: [d5513dfa] user: drh branch: trunk, size: 6095)
2014-03-19
23:24
[eb3a46b3] part of check-in [01afbf97] 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. (check-in: [01afbf97] user: drh branch: orderby-planning, size: 5732)
2013-09-11
17:39
[2a3d5181] part of check-in [6e6bded0] Improvements to likelihood processing so that commuting an unindexed term in the WHERE clause does not change the query plan. (check-in: [6e6bded0] user: drh branch: unlikely-func, size: 5696)
14:34
[5e695423] part of check-in [5d00cce7] Additional unlikely() test cases. Logic tweaks to support test coverage. (check-in: [5d00cce7] user: drh branch: unlikely-func, size: 4986)
11:38
[fa2da659] part of check-in [29a359b8] Change the name of the two-argument unlikely() function to likelihood(). Add test cases. (check-in: [29a359b8] user: drh branch: unlikely-func, size: 2674) Added