Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/where8.test
|
2018-04-18
| ||
| 19:56 | Add the "sorter-reference" optimization, allowing SQLite to be configured so that some required values may be loaded from the database after external sorting occurs for SELECT statements with ORDER BY clauses that are not satisfied by database indexes. file: [461ca402] check-in: [ef74090a] user: dan branch: trunk, size: 29995 | |
|
2015-12-01
| ||
| 21:23 | Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. file: [98eedca0] check-in: [9e1d6d4c] user: drh branch: trunk, size: 29935 | |
|
2015-03-06
| ||
| 20:49 | Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. file: [2eafe74e] check-in: [6b993bd5] user: drh branch: like-opt-fix, size: 29651 | |
|
2014-02-14
| ||
| 23:49 | Seek past NULLs in a top-constrained search. Avoid checking for NULLs in the body of the search. file: [806f1dce] check-in: [e07a32f3] user: drh branch: trunk, size: 29649 | |
|
2014-02-11
| ||
| 01:50 | Make sure that virtual WHERE-clause terms do not get transformed into real terms when processing set of OR-connected terms. Fix for ticket [4c86b126f22ad]. file: [84033c4d] check-in: [c950d6c4] user: drh branch: trunk, size: 29649 | |
|
2013-11-06
| ||
| 12:05 | Disable the OR optimization for WITHOUT ROWID tables, since it relies on the use of rowids. file: [d2b4fd6d] check-in: [6055dad2] user: drh branch: omit-rowid, size: 29647 | |
|
2013-07-16
| ||
| 21:31 | Enhance the query planner so that it looks at multiple solutions to OR expressions in the WHERE clause. file: [6f958966] check-in: [5e19d054] user: drh branch: trunk, size: 29358 | |
|
2013-06-12
| ||
| 14:52 | Add the "queryplanner" test permutation. Continuing refinements to NGQP. file: [f6b95597] check-in: [25e2cde1] user: drh branch: nextgen-query-plan-exp, size: 29331 | |
|
2013-05-16
| ||
| 19:15 | Fix minor test script issues causing releasetest.tcl to fail. file: [d6a283eb] check-in: [d8ded9d8] user: dan branch: trunk, size: 29331 | |
|
2013-04-30
| ||
| 14:06 | Make sure extra parentheses around subqueries in the FROM clause are harmless. Ticket [28c6e830f239ea5]. file: [d9f889e6] check-in: [1c795692] user: drh branch: trunk, size: 29243 | |
|
2012-12-18
| ||
| 19:36 | Optimize the degenerate case of a FROM clause table name enclosed all by itself inside parentheses. Generate code as if the parentheses did not exist, rather than the old behavior of manifesting the parenthesized table into a transient table. Also, tag every FROM-clause SELECT subquery that is generated by a parenthesized FROM-clause expression using the SF_NestedFrom flag. The new SF_NestedFrom flag is not yet used for anything. file: [02619a9b] check-in: [7fecced4] user: drh branch: trunk, size: 28701 | |
|
2010-04-15
| ||
| 01:04 | Further refinements to table order selection on join query planning. file: [a6c740fd] check-in: [defaf0d9] user: drh branch: trunk, size: 28395 | |
|
2009-12-16
| ||
| 22:10 | Ensure WHERE clause terms involving tables on the right end of a join are not prematurely evaluated when tables on the left end of the join make use of the OR-clause optimization. Fix for ticket [31338dca7e]. file: [2bb8ea44] check-in: [2c2de252] user: drh branch: trunk, size: 28380 | |
|
2009-12-02
| ||
| 02:49 | Make sure a variable is cleared before use in the where8.test script. file: [434f0897] check-in: [b3436529] user: drh branch: trunk, size: 27761 | |
|
2009-08-13
| ||
| 07:09 | Changes to the query planner that improve the order in which tables/indexes are scanned in join queries. file: [8d3704d0] check-in: [19f799b3] user: dan branch: trunk, size: 27735 | |
|
2009-07-31
| ||
| 06:14 | Fix a bug in where.c that could cause SQLite to write to freed memory while compiling a query with many terms in the WHERE clause. (CVS 6952) file: [fb2ccd7f] check-in: [8161af84] user: danielk1977 branch: trunk, size: 27736 | |
|
2009-06-07
| ||
| 23:45 | Disable the LIKE optimization if the affinity of the LHS column is not TEXT. Ticket #3901. (CVS 6727) file: [4839a0a1] check-in: [a255c645] user: drh branch: trunk, size: 26431 | |
|
2009-06-05
| ||
| 17:09 | Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) file: [d4037348] check-in: [1fef16ec] user: drh branch: trunk, size: 26426 | |
|
2009-04-21
| ||
| 09:02 | Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) file: [c53467ff] check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 26435 | |
|
2008-12-30
| ||
| 16:13 | Add further pseudo-randomly generated test cases to where8.test. (CVS 6083) file: [1b9152a0] check-in: [e01f6ef9] user: danielk1977 branch: trunk, size: 26436 | |
| 15:51 | Fix a bug in where8.test causing a tcl exception. (CVS 6082) file: [680fc527] check-in: [495b569a] user: danielk1977 branch: trunk, size: 15832 | |
| 15:26 | Add a few more tests to where8.test. (CVS 6081) file: [f569052b] check-in: [ac28aa8b] user: danielk1977 branch: trunk, size: 15744 | |
| 12:00 | Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077) file: [81036f3f] check-in: [35c87585] user: danielk1977 branch: trunk, size: 8028 | |
|
2008-12-29
| ||
| 18:33 | Add test file where8.test. (CVS 6072) file: [fa878218] check-in: [bff460ec] user: danielk1977 branch: trunk, size: 6149 Added | |