aboutsummaryrefslogtreecommitdiff
path: root/test/whereG.test
Commit message (Collapse)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Back out an incorrect change to the sqlite3ExprCompareSkip() function thatdrh2023-11-20
| | | | | | | was added way back on 2019-08-22 for [44578865fa7baf97|check-in 44578865fa7ba] and which was only today discovered to be incorrect by [forum:/forumpost/45ec3d9788|forum post 45ec3d9788]. FossilOrigin-Name: f5b3eb0fc8936ba274a7654ff6dfa7d4654bd8dbca7f3a5ec1134b0b5260d59d
* An index on the expression "likely(X)" should store the true value of X,drh2021-06-14
| | | | | | | | 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:/forumpost/3b940c437a|Forum post 3b940c437a]. FossilOrigin-Name: 791473bc6677c2ae76f558082a4b43ca1eaf9895b76624d5b55d58f2af898ff3
* Fix a bad interaction between constant propagation and transitive term ↵dan2021-04-15
| | | | | handling causing patterns like "WHERE unlikely(t1.x=t1.y) AND t1.y=?" to return non-matching rows. FossilOrigin-Name: 2363a14ca723c0343fbe350f6c19787a7a47c2289fd9af136c97a451b53b5226
* Revise tests cases to align with the new EXPLAIN QUERY PLAN output.drh2021-03-20
| | | FossilOrigin-Name: 50fbd532602d2c316813046ed6be8be2991c281eb5f295c4c28520a0de73862c
* Test case updates.drh2020-10-22
| | | FossilOrigin-Name: 27c681c9c6672ad7098d8ff2c41e76d3e9e55866b6327ed85e73f63bd623ceed
* Check-in [1d4f86201dab9a22] changed a testcase() to an assert() because wedrh2020-06-14
| | | | | | 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]. FossilOrigin-Name: 90b1169d1b200d35a3f9f0ad2ae35a1b336bdd9b1ad0494ba80a382354c8d8b8
* The OP_ResultRow opcode releases the SCopy dependences on all its registers,drh2019-12-31
| | | | | as the values in those registers will not be reused. FossilOrigin-Name: 1dc83c5d54ca2890112e735e336c209adb8d067d2f647e9f8ae5d58f84a52461
* Fix the likely(), unlikely(), and likelihood() functions so that they havedrh2019-08-22
| | | | | | no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] FossilOrigin-Name: 44578865fa7baf9760e355691ca9ce753295aaba7a4ee0bba29d4f85d9335bab
* Fix test cases so that they work with the new EXPLAIN QUERY PLAN outputdrh2018-05-02
| | | | | | format. Only some of the cases have been fixed. This is an incremental check-in. FossilOrigin-Name: 5f0e803e33aa557865d5fc830d9202d628de9a94c9757058ca48f1a560702cd3
* Make sure that the likelihood() function does not mess up generation ofdrh2015-06-20
| | | | | | result-set code when it is used (inappropropriately) in a result-set expression. FossilOrigin-Name: 7cdbae625eb029538a693d2bebec465a6f65fb90
* Pervent the likelihood() function from moving ON clause terms of a LEFT JOINdrh2015-06-18
| | | | | | into the WHERE clause. Fix for ticket [5f60b11fc8e23490e2] FossilOrigin-Name: ed96e14adce4a4f94cc6838c46bc97937c4cb72a
* Add the likely() function for symmetry with unlikely(). The likely(X)drh2014-06-17
| | | | | function means the same thing as likelihood(X,0.9375). FossilOrigin-Name: 38965484199153e3e5b999f5196c1d66e5296f60
* If the user provides likelihood() data for a WHERE clause term used as part ↵dan2014-04-25
| | | | | of an index key, have the planner use it when calculating the expected number of rows visited by the loop. FossilOrigin-Name: c51efaa5d29ee0a91b9e6a83a8dd82530670811a
* Changes to the way the planner calculates the costs of various table and ↵dan2014-04-24
| | | | | index scans. Some test cases still failing. FossilOrigin-Name: c5a6ec0a880652dc8f4593d9f7acd58ddc3dc5f3
* Use OP_Copy instead of OP_SCopy when moving results out of a subquery,drh2014-04-03
| | | | | | to prevent the subquery results from changing out from under the outer query. Fix for ticket [1e64dd782a126f48d78]. FossilOrigin-Name: d5513dfa23baa0b0a095aaf17d19aacd30dcef61
* Fix query planner weights associated with choosing block-sorting. Fixdrh2014-03-19
| | | | | | block sorting of tables with collating functions. Fix various test cases. All "veryquick" tests are now passing, though more tests need to be added. FossilOrigin-Name: 01afbf97c0ff29667806e9a7c4d74ca717819de5
* Improvements to likelihood processing so that commuting an unindexed term indrh2013-09-11
| | | | | the WHERE clause does not change the query plan. FossilOrigin-Name: 6e6bded055cdbc902731687c86d92c39a3ba5904
* Additional unlikely() test cases. Logic tweaks to support test coverage.drh2013-09-11
| | | FossilOrigin-Name: 5d00cce74a7aefaf30022ae971ab1e0451e0ad6e
* Change the name of the two-argument unlikely() function to likelihood().drh2013-09-11
Add test cases. FossilOrigin-Name: 29a359b8d7f90e6fa2b28ce2a112284fd3870494
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 08:46:06 +0000