Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/whereG.test
2025-04-10
| ||
10:18 | [875d020ac0] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 12088) | |
2023-11-20
| ||
15:54 | [649d5ad02a] part of check-in [f5b3eb0fc8] Back out an incorrect change to the sqlite3ExprCompareSkip() function that was added way back on 2019-08-22 for [44578865fa7baf97|check-in 44578865fa7ba] and which was only today discovered to be incorrect by forum post 45ec3d9788. (check-in: [f5b3eb0fc8] user: drh branch: trunk, size: 12096) | |
2021-06-14
| ||
14:00 | [b2a479f425] part of check-in [791473bc66] An index on the expression "likely(X)" should store the true value of X, even if X is a real number with no fractional part. The optimization of storing some REAL indexed values as INT (see [10d851353c2abead]) should be omitted for index columns that are expressions. Forum post 3b940c437a. (check-in: [791473bc66] user: drh branch: trunk, size: 11600) | |
2021-04-15
| ||
19:09 | [8f1a753826] part of check-in [2363a14ca7] Fix a bad interaction between constant propagation and transitive term handling causing patterns like "WHERE unlikely(t1.x=t1.y) AND t1.y=?" to return non-matching rows. See forum post c38462ab5e. (check-in: [2363a14ca7] user: dan branch: trunk, size: 11043) | |
2021-03-20
| ||
15:11 | [0a489c891a] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 10285) | |
2020-10-22
| ||
18:58 | [3ceb63370b] part of check-in [263293f1e6] Minor tweaks to query planning weights so that when STAT4 is enabled and functioning, a full table scan is more likely to be selected if that seems like the fastest solution. Only do this when STAT4 info is available because an error has a large potential downside. (check-in: [263293f1e6] user: drh branch: branch-3.28, size: 8668) | |
18:16 | [77127a4d21] part of check-in [27c681c9c6] Test case updates. (check-in: [27c681c9c6] user: drh branch: avoid-bad-indexes, size: 10393) | |
2020-06-14
| ||
13:40 | [9363b2a97d] part of check-in [90b1169d1b] 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: [90b1169d1b] user: drh branch: trunk, size: 10285) | |
2019-12-31
| ||
12:18 | [c9378b2858] part of check-in [1dc83c5d54] The OP_ResultRow opcode releases the SCopy dependences on all its registers, as the values in those registers will not be reused. (check-in: [1dc83c5d54] user: drh branch: trunk, size: 9977) | |
2019-08-22
| ||
16:38 | [4cda56de49] part of check-in [44578865fa] Fix the likely(), unlikely(), and likelihood() functions so that they have no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] (check-in: [44578865fa] user: drh branch: trunk, size: 9601) | |
2018-10-05
| ||
20:09 | [0b2ef829f7] part of check-in [5c243eec7b] 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: [5c243eec7b] user: drh branch: unique-constraint-weights, size: 8592) | |
2018-05-02
| ||
18:00 | [0158783235] part of check-in [5f0e803e33] 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: [5f0e803e33] user: drh branch: rework-EQP, size: 8560) | |
2015-06-20
| ||
13:18 | [dde4c52a97] part of check-in [7cdbae625e] 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: [7cdbae625e] user: drh branch: trunk, size: 8640) | |
2015-06-18
| ||
14:32 | [a9fa7c84d7] part of check-in [ed96e14adc] Pervent the likelihood() function from moving ON clause terms of a LEFT JOIN into the WHERE clause. Fix for ticket [5f60b11fc8e23490e2] (check-in: [ed96e14adc] user: drh branch: trunk, size: 8008) | |
2014-06-17
| ||
16:11 | [69f5ec4b15] part of check-in [3896548419] Add the likely() function for symmetry with unlikely(). The likely(X) function means the same thing as likelihood(X,0.9375). (check-in: [3896548419] user: drh branch: trunk, size: 7510) | |
2014-04-25
| ||
20:22 | [0ac23e5e83] part of check-in [c51efaa5d2] 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: [c51efaa5d2] user: dan branch: experimental-costs, size: 7251) | |
2014-04-24
| ||
20:04 | [8189fedf3b] part of check-in [c5a6ec0a88] Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. (check-in: [c5a6ec0a88] user: dan branch: experimental-costs, size: 6895) | |
2014-04-03
| ||
16:29 | [2533b72ed4] part of check-in [d5513dfa23] 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: [d5513dfa23] user: drh branch: trunk, size: 6095) | |
2014-03-19
| ||
23:24 | [eb3a46b3ea] part of check-in [01afbf97c0] 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: [01afbf97c0] user: drh branch: orderby-planning, size: 5732) | |
2013-09-11
| ||
17:39 | [2a3d5181de] part of check-in [6e6bded055] Improvements to likelihood processing so that commuting an unindexed term in the WHERE clause does not change the query plan. (check-in: [6e6bded055] user: drh branch: unlikely-func, size: 5696) | |
14:34 | [5e69542360] part of check-in [5d00cce74a] Additional unlikely() test cases. Logic tweaks to support test coverage. (check-in: [5d00cce74a] user: drh branch: unlikely-func, size: 4986) | |
11:38 | Added: [fa2da659bd] part of check-in [29a359b8d7] Change the name of the two-argument unlikely() function to likelihood(). Add test cases. (check-in: [29a359b8d7] user: drh branch: unlikely-func, size: 2674) | |