Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around dd03be1065537679.
|
2013-10-12
| ||
| 09:32 | Changes to the new initial row of PRAGMA index_list results. (Closed-Leaf check-in: 0c4dd9fff0 user: mistachkin tags: indexList) | |
| 02:33 | Fix harmless compiler warning. (check-in: 4b130f88fb user: mistachkin tags: trunk) | |
| 02:31 | Permit the creation of VSIX packages for Win32. (check-in: 035d03e942 user: mistachkin tags: trunk) | |
| 00:56 | Fix Unicode character encoding issues on Windows in the fts4unicode test file. (check-in: c9310c9a2b user: mistachkin tags: trunk) | |
|
2013-10-11
| ||
| 23:37 | Identify requirements text in the SQLITE_CONFIG_ documentation. Fix a typo (a duplicated word) in part of that documentation. Add some requirements marks for DETACH to the test scripts. No code changes. (check-in: 1be0a3adab user: drh tags: trunk) | |
| 23:02 | The split amalgamation option should be disabled by default. (check-in: 7c24d22ffa user: mistachkin tags: trunk) | |
| 23:01 | Enhance debugging support for the split amalgamation files when compiling with MSVC. (check-in: 8ff17c553d user: mistachkin tags: trunk) | |
| 23:01 | Fix a harmless compiler warning in lemon.c. (check-in: 62959c0ce3 user: drh tags: trunk) | |
| 22:19 | Add -no-undefined option when linking the shared libraries. (check-in: 977d2b12e5 user: mistachkin tags: trunk) | |
| 22:17 | Fix test numbering. (check-in: cef39f6933 user: mistachkin tags: trunk) | |
| 20:14 | Add requirements marks. No code changes. (check-in: 5e0d43ab55 user: drh tags: trunk) | |
| 16:35 | Additional test cases and requirements marks for the unlikely(), likelihood() and instr() functions. (check-in: 5f01cd36ee user: drh tags: trunk) | |
| 15:05 | Fix various harmless compiler warnings. Change the "warnings.sh" script to work with STAT4 instead of STAT3. (check-in: 7df06684ab user: drh tags: trunk) | |
| 13:27 | Make sure the sqlite3.h file occurs at the very top of the sqlite3.c amalgamation. (check-in: 03593817ab user: drh tags: trunk) | |
| 05:51 | Fix compilation issue for WinRT. (check-in: 7a2006ca94 user: mistachkin tags: trunk) | |
|
2013-10-10
| ||
| 20:13 | Synchronize with the trunk. (check-in: 136445ba02 user: drh tags: sessions) | |
| 17:33 | Add a rule to the main.mk makefile for building showdb. (check-in: fc5552da0d user: drh tags: trunk) | |
| 15:04 | Enhancements to the vfslog.c module to show all change-counter changes and to show the hostname and pid of the process that creates each log file. (check-in: af7abebeb1 user: drh tags: trunk) | |
| 13:41 | Another fix to the hash signature algorithm in vfslog.c. (check-in: 34212aa8c4 user: drh tags: trunk) | |
| 13:38 | Fix the hash signature algorithm in vfslog.c. Add a utility program to show the hash signatures for every page of a database file. (check-in: eaf4de13a6 user: drh tags: trunk) | |
| 13:04 | Add ext/misc/vfslog.c, a VFS shim for unix that keeps a log of method calls made by SQLite. (check-in: 24a827b876 user: dan tags: trunk) | |
| 12:38 | Estimate row sizes for tables and indices and use those estimates during query planning. Enhance the index_info pragma to show the estimated row sizes and to show the estimated row size for the main table as well. Allow an alternative row size estimate to be specified in the sqlite_stat1 table. (check-in: d27b88b8c2 user: drh tags: trunk) | |
|
2013-10-09
| ||
| 19:07 | Make sure the correct printf format is used for type tRowcnt regardless of whether 32-bit or 64-bit row counts are specified at compile-time. (Closed-Leaf check-in: e97d7d3044 user: drh tags: row-size-est) | |
|
2013-10-08
| ||
| 23:16 | Move a conditional inside of an #ifdef in order to make all branches reachable regardless of compile-time options used. (check-in: f7cc30d45b user: drh tags: row-size-est) | |
| 22:25 | Fix test cases for the new information in PRAGMA index_list. (check-in: dd03be1065 user: drh tags: row-size-est) | |
| 20:42 | Rollback some of the previous changes in the branch such that the estimated row sizes are now only used as a tie-breaker for index scans. (check-in: 65553ff34b user: drh tags: row-size-est) | |
| 20:01 | Use #ifdefs to omit unused code in the columnType() routine depending on compile-time options. (check-in: 3fd5e33217 user: drh tags: row-size-est) | |
| 18:40 | Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. (check-in: 18bd6ba96d user: drh tags: row-size-est) | |
|
2013-10-07
| ||
| 21:49 | Fix compilation issue with MSVC. (check-in: 36d64dc36f user: mistachkin tags: trunk) | |
| 17:32 | Multiply all cursor step cost estimates by the estimated size of the row in bytes, in order to get the query planner ot make use of estimated row sizes. This check-in uses magic numbers in a few places (for example, estimates of the size of output rows) and needs lots of refinement. Consider this a proof-of-concept only. (check-in: cb34cfe57c user: drh tags: row-size-est) | |
| 16:53 | Try to remember statistics from ANALYZE using LogEst instead of u64. (Leaf check-in: 8e78557a40 user: drh tags: log-stats) | |
| 10:48 | Merge bug fixes from trunk. (check-in: 1d7b2dc0ea user: drh tags: row-size-est) | |
| 00:36 | Restore the hexrekey pragma which was accidently deleted during the pragma refactoring. Make sure the hexkey and hexrekey pragmas do not overflow buffers with a over-length key. (check-in: 0aca31e151 user: drh tags: trunk) | |
|
2013-10-06
| ||
| 22:52 | Remove an incorrect debugging assert() that was accidently added during the STAT4 enhancement. (check-in: 2bb7f74bbd user: drh tags: trunk) | |
| 22:12 | Accept the sz=N parameter on table-only lines of sqlite_stat1. (check-in: e9e932aa40 user: drh tags: row-size-est) | |
|
2013-10-05
| ||
| 20:18 | Fix an issue in the test8.c test module that arises because of the change to PRAGMA index_list(). Remove an unused local variable. (check-in: 029430c503 user: drh tags: row-size-est) | |
| 19:18 | Completely remove the iScanRatio field. The PRAGMA index_list(TABLE) command shows the estimated row size in the forth column. It also generates a row for the table with an index name of NULL. The query planner still does not take row size estimates into account - that is the next step. (check-in: 8b4aa0c7a2 user: drh tags: row-size-est) | |
| 18:32 | Improvements to the LogEst command-line tool used to convert between ordinary numbers and the LogEst representation. (check-in: 5252aeb619 user: drh tags: row-size-est) | |
| 18:16 | Begin an experimental refactoring to estimate the average number of bytes in table and index rows and to use that information in query planner. Begin by renaming WhereCost to LogEst and making that type and its conversion routines available outside of where.c. (check-in: 66c4a251d6 user: drh tags: row-size-est) | |
| 02:56 | In the index_list pragma, make sure the "r" column is the same on output as it was on input in the sqlite_stat1 table. (Closed-Leaf check-in: de78250ad2 user: drh tags: index-scan-rate) | |
|
2013-10-04
| ||
| 20:39 | Merge trunk changes. (check-in: c6ac80ed8d user: drh tags: index-scan-rate) | |
| 18:29 | Further refinements of the index scanning speed logic. (check-in: e5d9371da9 user: drh tags: index-scan-rate) | |
| 18:17 | If an "INSERT INTO ... SELECT" can use the xfer optimization, pass the OPFLAG_BULKCSR hint to btree cursors used to update indices. This results in a tighter key packing. (check-in: 087af29ee2 user: dan tags: trunk) | |
| 15:58 | Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. (check-in: 2f394de88f user: drh tags: index-scan-rate) | |
| 15:30 | Improved estimates of the relative speed of index scans based on declared datatypes of columns in the table. Add "r" column to PRAGMA index_info, showing the estimated relative scan rate. (check-in: 07462bb605 user: drh tags: index-scan-rate) | |
| 02:36 | Progress toward using the iScanRatio information on indices. Many tests are still failing. (check-in: 6c352edbba user: drh tags: index-scan-rate) | |
| 00:00 | Make sure the count(*) optimization works correctly even when partial indices are present. Ticket [a5c8ed66cae]. (check-in: 9f2f4c0a50 user: drh tags: trunk) | |
|
2013-10-03
| ||
| 20:41 | Have FTS take advantage of "docid<?" constraints when they are present. Extend the FTS "incremental doclist" optimization so that it is used for tokens within multi-token phrases. (check-in: baf8ce5916 user: dan tags: trunk) | |
| 20:28 | Merge latest trunk changes. (Closed-Leaf check-in: 24aa20da22 user: dan tags: fts4-docid-range-constraints) | |
| 19:27 | Allow FTS4 multi-token phrases to use a combination of in-memory and incrementally loaded doclists. This allows phrases to (partially) benefit from incremental doclists without disabling the deferred token optimization. (check-in: f6819c5f33 user: dan tags: fts4-docid-range-constraints) | |