/ Timeline
Login

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

2013-06-26
11:43
Cut over the next generation query planner. Increase the version number to 3.8.0. check-in: 0fe31f60ca user: drh tags: trunk
00:34
Fix an uninitialized variable detected by valgrind. Unclear whether or not this should apply to trunk. Closed-Leaf check-in: 19ab4811d5 user: drh tags: nextgen-query-plan-exp
2013-06-21
00:35
Modify the query planner interface so that it always passes in the result set. This is the first step toward adding an optimization that will omit tables from a join that do not contribute to the result. check-in: 2c2577e69c user: drh tags: omit-join-table-opt
2013-06-20
17:32
Add a NEVER() macro and an explanation comment around an unreachable branch in the STAT3 logic. check-in: 604c3c5de6 user: drh tags: nextgen-query-plan-exp
14:17
Pull in the posix_fallocate() change from trunk. check-in: d94db3fd92 user: drh tags: nextgen-query-plan-exp
14:07
Disable posix_fallocate() for all systems, all the time, unless the HAVE_POSIX_FALLOCATE compile-time macro is supplied. check-in: b674462243 user: drh tags: trunk
2013-06-19
23:48
Merge in trunk changes to os_unix.c that allow the code to build on unix platforms that lack posix_fallocate(). check-in: bf5764067a user: drh tags: nextgen-query-plan-exp
18:01
Add in the cost of doing a table lookup on OR searches. Make test case changes to deal with difference in STAT3 behavior. check-in: d97898e8e3 user: drh tags: nextgen-query-plan-exp
14:49
Only default HAVE_POSIX_FALLOCATE on for linux, and then only if it is not previously defined. check-in: 2b2ade9278 user: drh tags: trunk
13:59
Additional compiler warning fixes. check-in: 8d2ae8e2f3 user: drh tags: nextgen-query-plan-exp
13:32
Fix a harmless uninitialized variable warning. check-in: 9d3ef3bd2c user: drh tags: nextgen-query-plan-exp
12:34
Simplify and add invariants to the WhereLoop merging logic inside of whereLoopInsert(). check-in: 8f27f35f28 user: drh tags: nextgen-query-plan-exp
03:27
Fix compiler warnings. Fix a harmless off-by-one error in the solver. check-in: 10021941d0 user: drh tags: nextgen-query-plan-exp
2013-06-18
20:06
Adjustments to testcase() macros for improved testability. check-in: 4fbb0c4d26 user: drh tags: nextgen-query-plan-exp
01:52
Remove some redundant and unreachable code. check-in: 4c6d58d75d user: drh tags: nextgen-query-plan-exp
2013-06-17
21:37
Add more testcase() macros. Fix a memory leak following OOM in the virtual table analysis logic. check-in: b61402af69 user: drh tags: nextgen-query-plan-exp
18:20
Simplifications to the NGQP. Add the queryplantest makefile target. Add testcase() macros in the NGQP. check-in: eaf1f1b405 user: drh tags: nextgen-query-plan-exp
14:18
Use automatic indices on subqueries of the FROM clause when appropriate. check-in: e8f124284e user: drh tags: nextgen-query-plan-exp
2013-06-15
15:11
Fix compiler warnings. check-in: 3e8ac46918 user: drh tags: nextgen-query-plan-exp
2013-06-14
13:27
Comment tweaks in where.c. No changes to code. check-in: cecc5fdd5d user: drh tags: nextgen-query-plan-exp
02:51
Add a new ORDER BY optimization that bypasses ORDER BY terms that are constrained by == and IS NULL terms of the WHERE clause. check-in: b920bb70bb user: drh tags: nextgen-query-plan-exp
2013-06-13
17:58
An index might be useful for ORDER BY if any indexed column is in the ORDER BY clause, not just the first indexed column. check-in: ade473b5ae user: drh tags: nextgen-query-plan-exp
17:28
Make sure that disabling the covering index scan optimization does not prevent a covering index from being used to satisfy an ORDER BY clause. check-in: e8b7ea8202 user: drh tags: nextgen-query-plan-exp
15:50
Restore the ability to do a BETWEEN query on the rowid. Also fix a nearby comment. check-in: 459a7b9068 user: drh tags: nextgen-query-plan-exp
15:16
Make the MIN() and MAX() macros available in sqliteInt.h. Add TUNING comments to the NGQP and adjust costs slightly. check-in: 3a72af2a95 user: drh tags: nextgen-query-plan-exp
14:51
Fix an off-by-one error in the WhereCost to integer conversion. check-in: b5ca80d924 user: drh tags: nextgen-query-plan-exp
00:32
Add a prototype for an extension that sits in between the SQLite native code virtual table interface and a CLR IDisposable object. check-in: 10bba8d082 user: drh tags: disposable-vtable
2013-06-12
20:18
Activate the one-pass optimization. Update comments, especially the descriptions of the various objects. check-in: e120c558a5 user: drh tags: nextgen-query-plan-exp
17:55
Bug fixes in the handling of virtual tables. check-in: 25c0f7292a user: drh tags: nextgen-query-plan-exp
17:17
Merge all changes from trunk. check-in: f2e15b1974 user: drh tags: nextgen-query-plan-exp
17:08
"make test" now passing. check-in: addd7f466d user: drh tags: nextgen-query-plan-exp
14:52
Add the "queryplanner" test permutation. Continuing refinements to NGQP. check-in: 25e2cde105 user: drh tags: nextgen-query-plan-exp
03:48
Continue refining the NGQP check-in: 40567fddd4 user: drh tags: nextgen-query-plan-exp
2013-06-11
18:59
Improved processing of DISTINCT. check-in: ba897100fe user: drh tags: nextgen-query-plan-exp
14:22
Add the SQLITE_FTS3_MAX_EXPR_DEPTH compile time option. check-in: 24fc9d4438 user: dan tags: trunk
13:30
Fix the Parse.nQueryLoop state variable to work with NGQP. check-in: f1cac24f06 user: drh tags: nextgen-query-plan-exp
02:36
Use a logarithmic rather than linear cost and row-count measures. Do not report row count estimates in EQP output. check-in: b777b1097d user: drh tags: nextgen-query-plan-exp
02:32
Fixes to EXPLAIN QUERY PLAN output. Change weights back to something closer to what they are in legacy. More test case fixes. Closed-Leaf check-in: 36373b85f9 user: drh tags: nextgen-query-plan-logcost
2013-06-10
19:12
First attempt to store costs and row counts as a logarithm. check-in: 9e8109673c user: drh tags: nextgen-query-plan-logcost
14:56
Simplification and performance tweak to the high-speed NGQP bypass. check-in: 0f8a38ee54 user: drh tags: nextgen-query-plan-exp
12:34
Performance improvements for whereScan methods. check-in: aae14350a3 user: drh tags: nextgen-query-plan-exp
12:17
Add a high-speed bypass for the NGQP for the common case of a simply query with quality constraints that outputs a single row. check-in: 8d1ba30921 user: drh tags: nextgen-query-plan-exp
12:15
Minor problems in the high-speed NGQP fixed. Closed-Leaf check-in: 20eeccf1f2 user: drh tags: nextgen-query-plan-fast
2013-06-09
17:21
High-speed version of NGQP. Still has some minor problems. check-in: db2415fa67 user: drh tags: nextgen-query-plan-fast
2013-06-07
02:04
Must faster computation of estimated logarithm. check-in: dfbca3acae user: drh tags: nextgen-query-plan-exp
00:29
Further prepare-time performance improvements. check-in: 02741d177b user: drh tags: nextgen-query-plan-exp
2013-06-06
23:44
Performance improvements. check-in: 9f8e84ab98 user: drh tags: nextgen-query-plan-exp
23:02
Improved management of the space to hold WhereLoop.aLTerm[]. check-in: d4141ecbea user: drh tags: nextgen-query-plan-exp
19:25
Remove some commented-out code that was mistakenly left in the previous check-in. check-in: b4a5dbad36 user: drh tags: nextgen-query-plan-exp
19:16
Clean up and reorganize the elements of the various objects in the analysis tree for the NGQP. check-in: bfc76ae1e9 user: drh tags: nextgen-query-plan-exp