/ All files named "test/where8.test"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/where8.test

2018-04-18
19:56
[461ca402] part of check-in [ef74090a] 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. (check-in: [ef74090a] user: dan branch: trunk, size: 29995)
2015-12-01
21:23
[98eedca0] part of check-in [9e1d6d4c] Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. (check-in: [9e1d6d4c] user: drh branch: trunk, size: 29935)
2015-03-06
20:49
[2eafe74e] part of check-in [6b993bd5] Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. (check-in: [6b993bd5] user: drh branch: like-opt-fix, size: 29651)
2014-02-14
23:49
[806f1dce] part of check-in [e07a32f3] Seek past NULLs in a top-constrained search. Avoid checking for NULLs in the body of the search. (check-in: [e07a32f3] user: drh branch: trunk, size: 29649)
2014-02-11
01:50
[84033c4d] part of check-in [c950d6c4] 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]. (check-in: [c950d6c4] user: drh branch: trunk, size: 29649)
2013-11-06
12:05
[d2b4fd6d] part of check-in [6055dad2] Disable the OR optimization for WITHOUT ROWID tables, since it relies on the use of rowids. (check-in: [6055dad2] user: drh branch: omit-rowid, size: 29647)
2013-07-16
21:31
[6f958966] part of check-in [5e19d054] Enhance the query planner so that it looks at multiple solutions to OR expressions in the WHERE clause. (check-in: [5e19d054] user: drh branch: trunk, size: 29358)
2013-06-12
14:52
[f6b95597] part of check-in [25e2cde1] Add the "queryplanner" test permutation. Continuing refinements to NGQP. (check-in: [25e2cde1] user: drh branch: nextgen-query-plan-exp, size: 29331)
2013-05-16
19:15
[d6a283eb] part of check-in [d8ded9d8] Fix minor test script issues causing releasetest.tcl to fail. (check-in: [d8ded9d8] user: dan branch: trunk, size: 29331)
2013-04-30
14:06
[d9f889e6] part of check-in [1c795692] Make sure extra parentheses around subqueries in the FROM clause are harmless. Ticket [28c6e830f239ea5]. (check-in: [1c795692] user: drh branch: trunk, size: 29243)
2012-12-18
19:36
[02619a9b] part of check-in [7fecced4] 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. (check-in: [7fecced4] user: drh branch: trunk, size: 28701)
2010-04-15
01:04
[a6c740fd] part of check-in [defaf0d9] Further refinements to table order selection on join query planning. (check-in: [defaf0d9] user: drh branch: trunk, size: 28395)
2009-12-16
22:10
[2bb8ea44] part of check-in [2c2de252] 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]. (check-in: [2c2de252] user: drh branch: trunk, size: 28380)
2009-12-02
02:49
[434f0897] part of check-in [b3436529] Make sure a variable is cleared before use in the where8.test script. (check-in: [b3436529] user: drh branch: trunk, size: 27761)
2009-08-13
07:09
[8d3704d0] part of check-in [19f799b3] Changes to the query planner that improve the order in which tables/indexes are scanned in join queries. (check-in: [19f799b3] user: dan branch: trunk, size: 27735)
2009-07-31
06:14
[fb2ccd7f] part of check-in [8161af84] 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) (check-in: [8161af84] user: danielk1977 branch: trunk, size: 27736)
2009-06-07
23:45
[4839a0a1] part of check-in [a255c645] Disable the LIKE optimization if the affinity of the LHS column is not TEXT. Ticket #3901. (CVS 6727) (check-in: [a255c645] user: drh branch: trunk, size: 26431)
2009-06-05
17:09
[d4037348] part of check-in [1fef16ec] Remove leftover "breakpoint" commands from test scripts. Also remove blank lines at the end of scripts. (CVS 6721) (check-in: [1fef16ec] user: drh branch: trunk, size: 26426)
2009-04-21
09:02
[c53467ff] part of check-in [f61e4cd9] Attempt to optimize virtual table queries with 'OR' expressions in the WHERE clause. (CVS 6527) (check-in: [f61e4cd9] user: danielk1977 branch: trunk, size: 26435)
2008-12-30
16:13
[1b9152a0] part of check-in [e01f6ef9] Add further pseudo-randomly generated test cases to where8.test. (CVS 6083) (check-in: [e01f6ef9] user: danielk1977 branch: trunk, size: 26436)
15:51
[680fc527] part of check-in [495b569a] Fix a bug in where8.test causing a tcl exception. (CVS 6082) (check-in: [495b569a] user: danielk1977 branch: trunk, size: 15832)
15:26
[f569052b] part of check-in [ac28aa8b] Add a few more tests to where8.test. (CVS 6081) (check-in: [ac28aa8b] user: danielk1977 branch: trunk, size: 15744)
12:00
[81036f3f] part of check-in [35c87585] Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077) (check-in: [35c87585] user: danielk1977 branch: trunk, size: 8028)
2008-12-29
18:33
Added: [fa878218] part of check-in [bff460ec] Add test file where8.test. (CVS 6072) (check-in: [bff460ec] user: danielk1977 branch: trunk, size: 6149)