Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins related to "nextgen-query-plan-exp"
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 | |