Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/where2.test
|
2016-03-09
| ||
| 15:09 | When optimizing expressions of the form "x IN (SELECT ...)" make sure that the subquery is not correlated. Fix for ticket [5e3c886796e5512]. file: [478d2170] check-in: [1ed6b06e] user: drh branch: trunk, size: 23730 | |
|
2015-10-29
| ||
| 12:27 | Apply optimizations to simplify OR clauses that contain constant terms. file: [bf89ae34] check-in: [d533e23f] user: drh branch: simplify-or-clause, size: 23356 | |
|
2015-08-27
| ||
| 23:18 | Fix the OR-optimization so that it always ignores subplans that do not use an index. file: [af78c555] check-in: [66f92a16] user: drh branch: trunk, size: 23351 | |
|
2014-07-22
| ||
| 19:14 | The optimization of check-in [b67a6e33f2] does not work (it generates incorrect VDBE code) if an OR term is AND-ed with a constant expression. So back that optimization out and add a test case to make sure it does not get added back in. file: [23fdb5d8] check-in: [eed754fe] user: drh branch: trunk, size: 23169 | |
|
2014-02-26
| ||
| 02:26 | Improved handling of constants and especially constant functions in the ORDER BY clause of a query. Do not optimize out "ORDER BY random()". Fix for ticket [65bdeb9739605cc2296]. file: [455a2eb2] check-in: [dca1945a] user: drh branch: trunk, size: 22916 | |
|
2013-10-04
| ||
| 15:58 | Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. file: [ed6baa94] check-in: [2f394de8] user: drh branch: index-scan-rate, size: 21724 | |
|
2013-08-21
| ||
| 20:04 | Minor fixes for test cases. No code changes. file: [76d5346f] check-in: [ef2a6a37] user: dan branch: trunk, size: 21621 | |
|
2013-07-16
| ||
| 21:31 | Enhance the query planner so that it looks at multiple solutions to OR expressions in the WHERE clause. file: [b1830f76] check-in: [5e19d054] user: drh branch: trunk, size: 21577 | |
|
2013-07-05
| ||
| 19:16 | Fix two test script problems revealed by permutations.test. file: [d712de0e] check-in: [60cf7e44] user: dan branch: trunk, size: 21171 | |
|
2013-06-12
| ||
| 17:08 | "make test" now passing. file: [dcf0ffaf] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 21082 | |
|
2013-06-11
| ||
| 02:32 | Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. file: [58cc3f85] check-in: [36373b85] user: drh branch: nextgen-query-plan-logcost, size: 20827 | |
|
2013-06-03
| ||
| 22:08 | Remove more vestiges of sqlite_query_plan from the test cases. file: [116fb0d6] check-in: [eb27086e] user: drh branch: nextgen-query-plan-exp, size: 20827 | |
|
2013-05-31
| ||
| 15:18 | Allow tracing of whereLoopInsert() when the 0x8 bit is set on ".wheretrace". Remove the use of sqlite_query_plan from where2.test. Fix a bug in the code generator for OR clause optimizations. file: [f902f62d] check-in: [707f0323] user: drh branch: nextgen-query-plan-exp, size: 20870 | |
|
2013-02-08
| ||
| 18:48 | Loop through the elements on the RHS of an IN operator in reverse order when the ORDER BY clauses specifies DESC. file: [399b3178] check-in: [f78395c8] user: drh branch: IN-with-ORDERBY, size: 20532 | |
|
2013-02-07
| ||
| 21:15 | Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. file: [61acb16d] check-in: [98bf668a] user: drh branch: IN-with-ORDERBY, size: 20528 | |
|
2010-04-30
| ||
| 21:03 | Avoid assertion faults in queries using indices with redundant columns. Ticket [3dbdcdb14e7f41]. file: [43d4beca] check-in: [946e06cd] user: drh branch: trunk, size: 19539 | |
|
2009-02-02
| ||
| 01:50 | Restrict the RANDOM() function to have zero arguments. Ticket #3627. (CVS 6229) file: [45eacc12] check-in: [b8b546b6] user: drh branch: trunk, size: 18803 | |
|
2008-10-07
| ||
| 23:46 | Add the experimental sqlite3_stmt_status() interface. (CVS 5781) file: [e446f554] check-in: [de473efb] user: drh branch: trunk, size: 18806 | |
|
2007-12-10
| ||
| 05:03 | Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) file: [7012c0ad] check-in: [0b34a186] user: danielk1977 branch: trunk, size: 18846 | |
|
2007-09-12
| ||
| 17:01 | Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) file: [9bbf1cc6] check-in: [c8405b15] user: danielk1977 branch: trunk, size: 18277 | |
|
2007-02-23
| ||
| 23:13 | Disable the OR optimization if it would conflict with column affinity coercions. Ticket #2249. Additional cleanup and testing of the OR optimization. (CVS 3658) file: [3249d426] check-in: [908daaa9] user: drh branch: trunk, size: 18103 | |
|
2006-11-06
| ||
| 15:10 | Fix a bug in the optimizer that was causing it to miss an OR optimization opportunity. (CVS 3502) file: [61d5b20d] check-in: [9bf153b5] user: drh branch: trunk, size: 13720 | |
|
2006-05-11
| ||
| 13:26 | Correctly handle multi-column indices where multiple columns are constrained by IN operators with subqueries on the right-hand side. Ticket #1807. (CVS 3184) file: [a16476a5] check-in: [b16541ba] user: drh branch: trunk, size: 13070 | |
|
2006-01-17
| ||
| 09:35 | Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [fde821b9] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 7998 | |
|
2006-01-16
| ||
| 16:24 | Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) file: [2a500059] check-in: [c058f483] user: danielk1977 branch: trunk, size: 7903 | |
|
2006-01-14
| ||
| 08:02 | Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) file: [d85bd79c] check-in: [8e79a0c2] user: danielk1977 branch: trunk, size: 7801 | |
|
2005-08-13
| ||
| 16:13 | Disable an overzealous optimization the omitted sorting on a join if the first table gave a unique result. The sort can only be omitted if all tables in the join are unique. Ticket #1358. (CVS 2589) file: [503e2e2b] check-in: [4f076612] user: drh branch: trunk, size: 7461 | |
|
2005-07-29
| ||
| 19:43 | Fix problems caused by over-agressive optimization of ORDER BY in joins. Lots more testing needed. (CVS 2571) file: [3432fc9c] check-in: [1a4e526d] user: drh branch: trunk, size: 6559 | |
| 15:10 | Optimizer now converts OR-connected WHERE-clause terms into an IN operator so that they can be used with indices. There are known problems with the ORDER BY optimization in this and in several prior check-ins. This check-in is not recommended for production use. (CVS 2569) file: [6e8c3369] check-in: [d23c8bf8] user: drh branch: trunk, size: 6588 | |
|
2005-07-28
| ||
| 23:12 | The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568) file: [8696c35c] check-in: [cdf8c958] user: drh branch: trunk, size: 5553 | |
| 20:51 | Test cases and tuning of the new optimizer code. (CVS 2567) file: [64276193] check-in: [4b02703d] user: drh branch: trunk, size: 5554 Added | |