/ File History
Login

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