Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/where2.test
2025-04-10
| ||
10:18 | [d7d546b891] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 23774) | |
2021-03-20
| ||
15:11 | [03c21a11e7] 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: 23778) | |
2016-03-09
| ||
15:09 | [478d217063] part of check-in [1ed6b06ea3] When optimizing expressions of the form "x IN (SELECT ...)" make sure that the subquery is not correlated. Fix for ticket [5e3c886796e5512]. (check-in: [1ed6b06ea3] user: drh branch: trunk, size: 23730) | |
2015-10-29
| ||
12:27 | [bf89ae340e] part of check-in [d533e23f05] Apply optimizations to simplify OR clauses that contain constant terms. (check-in: [d533e23f05] user: drh branch: simplify-or-clause, size: 23356) | |
2015-08-27
| ||
23:18 | [af78c55589] part of check-in [66f92a1686] Fix the OR-optimization so that it always ignores subplans that do not use an index. (check-in: [66f92a1686] user: drh branch: trunk, size: 23351) | |
2014-07-22
| ||
19:14 | [23fdb5d8e7] part of check-in [eed754fe93] 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. (check-in: [eed754fe93] user: drh branch: trunk, size: 23169) | |
2014-02-26
| ||
02:26 | [455a2eb266] part of check-in [dca1945aeb] 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]. (check-in: [dca1945aeb] user: drh branch: trunk, size: 22916) | |
2013-10-04
| ||
15:58 | [ed6baa9420] part of check-in [2f394de88f] 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. (check-in: [2f394de88f] user: drh branch: index-scan-rate, size: 21724) | |
2013-08-21
| ||
20:04 | [76d5346f7e] part of check-in [ef2a6a3736] Minor fixes for test cases. No code changes. (check-in: [ef2a6a3736] user: dan branch: trunk, size: 21621) | |
2013-07-16
| ||
21:31 | [b1830f762f] part of check-in [5e19d05410] Enhance the query planner so that it looks at multiple solutions to OR expressions in the WHERE clause. (check-in: [5e19d05410] user: drh branch: trunk, size: 21577) | |
2013-07-05
| ||
19:16 | [d712de0ea9] part of check-in [60cf7e4487] Fix two test script problems revealed by permutations.test. (check-in: [60cf7e4487] user: dan branch: trunk, size: 21171) | |
2013-06-12
| ||
17:08 | [dcf0ffafe0] part of check-in [addd7f466d] "make test" now passing. (check-in: [addd7f466d] user: drh branch: nextgen-query-plan-exp, size: 21082) | |
2013-06-11
| ||
02:32 | [58cc3f85c0] part of check-in [36373b85f9] Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. (check-in: [36373b85f9] user: drh branch: nextgen-query-plan-logcost, size: 20827) | |
2013-06-03
| ||
22:08 | [116fb0d6e9] part of check-in [eb27086e8a] Remove more vestiges of sqlite_query_plan from the test cases. (check-in: [eb27086e8a] user: drh branch: nextgen-query-plan-exp, size: 20827) | |
2013-05-31
| ||
15:18 | [f902f62d60] part of check-in [707f032326] 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. (check-in: [707f032326] user: drh branch: nextgen-query-plan-exp, size: 20870) | |
2013-02-08
| ||
18:48 | [399b317828] part of check-in [f78395c889] Loop through the elements on the RHS of an IN operator in reverse order when the ORDER BY clauses specifies DESC. (check-in: [f78395c889] user: drh branch: IN-with-ORDERBY, size: 20532) | |
2013-02-07
| ||
21:15 | [61acb16d8e] part of check-in [98bf668ab1] Allow an index to be used for sorting even if prior terms of the index are constrained by IN operators. (check-in: [98bf668ab1] user: drh branch: IN-with-ORDERBY, size: 20528) | |
2010-04-30
| ||
21:03 | [43d4becaf5] part of check-in [946e06cd2a] Avoid assertion faults in queries using indices with redundant columns. Ticket [3dbdcdb14e7f41]. (check-in: [946e06cd2a] user: drh branch: trunk, size: 19539) | |
2009-02-02
| ||
01:50 | [45eacc126a] part of check-in [b8b546b6ed] Restrict the RANDOM() function to have zero arguments. Ticket #3627. (CVS 6229) (check-in: [b8b546b6ed] user: drh branch: trunk, size: 18803) | |
2008-10-07
| ||
23:46 | [e446f55417] part of check-in [de473efb35] Add the experimental sqlite3_stmt_status() interface. (CVS 5781) (check-in: [de473efb35] user: drh branch: trunk, size: 18806) | |
2007-12-10
| ||
05:03 | [7012c0ad02] part of check-in [0b34a18651] Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) (check-in: [0b34a18651] user: danielk1977 branch: trunk, size: 18846) | |
2007-09-12
| ||
17:01 | [9bbf1cc675] part of check-in [c8405b15c0] Fixes for compilation/testing when the various OMIT macros are defined. (CVS 4423) (check-in: [c8405b15c0] user: danielk1977 branch: trunk, size: 18277) | |
2007-02-23
| ||
23:13 | [3249d426b3] part of check-in [908daaa9ab] Disable the OR optimization if it would conflict with column affinity coercions. Ticket #2249. Additional cleanup and testing of the OR optimization. (CVS 3658) (check-in: [908daaa9ab] user: drh branch: trunk, size: 18103) | |
2006-11-06
| ||
15:10 | [61d5b20d9b] part of check-in [9bf153b54c] Fix a bug in the optimizer that was causing it to miss an OR optimization opportunity. (CVS 3502) (check-in: [9bf153b54c] user: drh branch: trunk, size: 13720) | |
2006-05-11
| ||
13:26 | [a16476a591] part of check-in [b16541ba5e] Correctly handle multi-column indices where multiple columns are constrained by IN operators with subqueries on the right-hand side. Ticket #1807. (CVS 3184) (check-in: [b16541ba5e] user: drh branch: trunk, size: 13070) | |
2006-01-17
| ||
09:35 | [fde821b9cb] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 7998) | |
2006-01-16
| ||
16:24 | [2a50005957] part of check-in [c058f483a5] Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: [c058f483a5] user: danielk1977 branch: trunk, size: 7903) | |
2006-01-14
| ||
08:02 | [d85bd79cdd] part of check-in [8e79a0c24a] Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (check-in: [8e79a0c24a] user: danielk1977 branch: trunk, size: 7801) | |
2005-08-13
| ||
16:13 | [503e2e2b6a] part of check-in [4f07661279] 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) (check-in: [4f07661279] user: drh branch: trunk, size: 7461) | |
2005-07-29
| ||
19:43 | [3432fc9c24] part of check-in [1a4e526d46] Fix problems caused by over-agressive optimization of ORDER BY in joins. Lots more testing needed. (CVS 2571) (check-in: [1a4e526d46] user: drh branch: trunk, size: 6559) | |
15:10 | [6e8c3369e3] part of check-in [d23c8bf81e] 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) (check-in: [d23c8bf81e] user: drh branch: trunk, size: 6588) | |
2005-07-28
| ||
23:12 | [8696c35cd3] part of check-in [cdf8c9584b] The BETWEEN operator in a WHERE clause is now able to use indices. (CVS 2568) (check-in: [cdf8c9584b] user: drh branch: trunk, size: 5553) | |
20:51 | Added: [6427619390] part of check-in [4b02703dec] Test cases and tuning of the new optimizer code. (CVS 2567) (check-in: [4b02703dec] user: drh branch: trunk, size: 5554) | |