Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 descendants and 50 ancestors of 7a8b0e362b529d54
2013-10-05
| ||
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) | |
19:21 | Experimental branch allowing different postulated scan rates for each index. (check-in: d59d97b0a8 user: drh tags: index-scan-rate) | |
15:39 | The sqlite3FixInit() routine cannot fail. So change the return type from "int" to "void". (check-in: 500c5932fe user: drh tags: trunk) | |
14:08 | Rework the PRAGMA implementation to only call sqlite3ReadSchema() from a single place, based on a flag in the pragma table, rather than separately from each case which needs the schema. (check-in: 8338232a11 user: drh tags: trunk) | |
12:29 | Return an error if an attempt is made to create a trigger with an SQL variable embedded within it. If such a variable reference is found within a trigger definition loaded from the sqlite_master table, silently replace it with a NULL. (check-in: f35f6ae3da user: dan tags: trunk) | |
11:27 | Remove unnecessary memset() calls from test code. (check-in: eec3187bc6 user: drh tags: trunk) | |
2013-10-02
| ||
20:46 | In the lemon parser generator, change all hashes to unsigned to avoid potential problems with signed integer overflow. (check-in: 8d399a03de user: drh tags: trunk) | |
08:04 | Add a test to check that the new multi-token phrase optimization is actually helping. (check-in: bc3a2ed5fb user: dan tags: fts4-docid-range-constraints) | |
2013-10-01
| ||
20:29 | Bring some file format comments in btreeInt.h up to date. (check-in: 012d54d0d2 user: drh tags: trunk) | |
20:10 | Merge trunk changes with this branch. (check-in: 65d9c6fafb user: dan tags: fts4-docid-range-constraints) | |
20:02 | Allow multi-token phrases to load doclists from the database incrementally. This allows queries that feature such phrases to benefit from the "docid<?" optimization. (check-in: ea543f081d user: dan tags: fts4-docid-range-constraints) | |
19:36 | Fix comments in the fast_vacuum.c demonstration program. (check-in: e0db7b38e1 user: drh tags: trunk) | |
19:02 | Add the "fast_vacuum.c" demonstration program to the tool/ subdirectgory. (check-in: 2b60320d57 user: drh tags: trunk) | |
15:30 | Change the ".dump" command in the command-line shell so that it COMMITs if there are database corruption errors but invokes ROLLBACK on any other kind of error. (check-in: 473234632f user: drh tags: trunk) | |
2013-09-30
| ||
19:33 | Fix a minor typo in a comment in where.c. (check-in: 9c9fa151e9 user: drh tags: trunk) | |
19:05 | Add some timing tests to the amatch test script. (check-in: ad71c72be5 user: drh tags: trunk) | |
18:16 | Merge trunk changes with this branch. (check-in: e294a9c7c5 user: dan tags: fts4-docid-range-constraints) | |
18:14 | Fix a performance problem in the FTS4 auxiliary functions triggered by an OR clause in the full-text query. (check-in: fa0f2f0e3e user: dan tags: trunk) | |
17:37 | Fix memory leaks in the amatch extension. Add a few simple test cases. (check-in: 604134732e user: drh tags: trunk) | |
11:42 | Have fts4 full-text queries consider "docid<?" and similar constraints. (check-in: 6622424a3a user: dan tags: fts4-docid-range-constraints) | |
11:01 | Update and modernize an obsolete comment associated with VACUUM. No changes to code. (check-in: 94c914e3fa user: drh tags: trunk) | |
2013-09-29
| ||
04:56 | Fix typo in comment. No changes to code. (check-in: 0b7bd46825 user: mistachkin tags: trunk) | |
2013-09-28
| ||
16:43 | Add new test file fts3defer3.test. (check-in: a6cd14effe user: dan tags: trunk) | |
13:28 | In the nextchar.c extension, allow the second argument to the next_char() function to be a subquery. (check-in: 59b9fa2236 user: drh tags: trunk) | |
12:40 | Updates to the sqlite3_analyzer utility: Change the names of some labels, especially change "Fragmentation" to "Non-sequential pages". Revise the computation of non-sequential pages so that it ignores itercalated non-leaf pages (overflow and index pages). (check-in: 3e5c7771fa user: drh tags: trunk) | |
2013-09-26
| ||
15:21 | Obtain the required shared-cache write-lock when executing "DELETE FROM tbl" statements. Fix for [1e1321ee98]. (check-in: 1f8f4fdf3f user: dan tags: trunk) | |
11:04 | Fix a faulty assert() in sqlite3BtreeBeginTrans() that may fail in shared-cache mode. (check-in: 1e1321ee98 user: dan tags: trunk) | |
2013-09-24
| ||
19:07 | Merge updates from trunk. (check-in: 435ce3b3fc user: mistachkin tags: toTypeFuncs) | |
2013-09-18
| ||
11:16 | Test that the unicode61 tokenchars= and separators= options work with the fts3tokenize virtual table. (check-in: ed24051462 user: dan tags: trunk) | |
2013-09-17
| ||
23:36 | Clear the current time value on prepared statements when the prepared statement is reset. (check-in: cebd6fc551 user: drh tags: trunk) | |
2013-09-16
| ||
20:46 | Readability improvements to the Win32 RC file. (check-in: e645906257 user: mistachkin tags: trunk) | |
19:27 | Minor consistency fixes to the Win32 RC file. (check-in: 619c5211b9 user: mistachkin tags: trunk) | |
12:57 | The date and time functions use the exact same notion of "now" for every invocation within the same call to sqlite3_step(). (check-in: daf6ba413c user: drh tags: trunk) | |
2013-09-13
| ||
23:27 | Fix Windows SDK compiler warning. (check-in: d5fc3f1dab user: mistachkin tags: trunk) | |
23:26 | Fix test issues for Windows portability. (check-in: 650b32825a user: mistachkin tags: trunk) | |
22:38 | VSIX tooling changes to support Visual Studio 2013. (check-in: d56fac4031 user: mistachkin tags: trunk) | |
19:08 | VSIX tooling changes to support Visual Studio 2013. (Leaf check-in: e8ac4a1227 user: mistachkin tags: branch-3.8.0) | |
2013-09-12
| ||
00:40 | Merge updates from trunk. (Closed-Leaf check-in: fca799f03a user: mistachkin tags: vsix2013) | |
2013-07-11
| ||
03:09 | Environment variable names in nmake must be in all uppercase. (check-in: 0328e873f2 user: mistachkin tags: vsix2013) | |
2013-07-10
| ||
21:33 | More corrections to VS 2013 integration. (check-in: 7a8b0e362b user: mistachkin tags: vsix2013) | |
19:53 | Use the VisualStudioVersion variable instead of _MSC_VER. (check-in: 603e9db817 user: mistachkin tags: vsix2013) | |
19:39 | More changes to support MSVC 18. (check-in: 29c458e2c2 user: mistachkin tags: vsix2013) | |
2013-06-21
| ||
07:54 | Update comments and package flavor error message. (check-in: 9d1b96182a user: mistachkin tags: vsix2013) | |
2013-06-20
| ||
19:07 | Use the target platorm version in the VS props file as well. (check-in: ce5a8cc1cf user: mistachkin tags: vsix2013) | |
18:53 | VSIX tooling changes to support Visual Studio 2013. (check-in: c5954c58c0 user: mistachkin tags: vsix2013) | |
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
| ||
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) | |
14:28 | Only enable posix_fallocate by default on linux and mac. (check-in: b9b30d4f98 user: drh tags: trunk) | |
2013-06-11
| ||
14:22 | Add the SQLITE_FTS3_MAX_EXPR_DEPTH compile time option. (check-in: 24fc9d4438 user: dan tags: trunk) | |
2013-06-09
| ||
20:22 | Fix the memory leak in CREATE TABLE that occurs if there are two or more COLLATE clauses on the same column. (check-in: 7e3820e5b9 user: drh tags: trunk) | |
20:16 | Add test cases to demonstrate the memory leak on the COLLATE clause. (Closed-Leaf check-in: 0a60212c9c user: drh tags: memleak) | |
2013-06-08
| ||
19:58 | Candidate fix for a memory leak that occurs if a CREATE TABLE statement contains two or more COLLATE clauses on the same column definition. (check-in: 60fc77bc53 user: drh tags: memleak) | |
2013-06-07
| ||
22:12 | Improve manual cleaning step performed by the multi-platform build tool for MSVC. (check-in: d5bc1fe1c4 user: mistachkin tags: trunk) | |
2013-06-05
| ||
16:17 | Up until now the fts4 "unicode61" tokenizer has treated all private use codepoints except the first and last of each of the three ranges as alphanumeric (eligible to be part of tokens). This commit fixes this so that all private use codepoints are considered alphanumeric. In other words, it fixes the handling of codepoints 0xE000, 0xF8FF, 0xF0000, 0xFFFFD, 0x100000 and 0x10FFFD. (check-in: 6cfd9af525 user: dan tags: trunk) | |
2013-06-03
| ||
20:39 | Fix a typo in a collating function inside the e_reindex.test script. (check-in: 4d74fccf02 user: drh tags: trunk) | |
12:47 | Enhance the shell to provide more flexibility when entering numeric arguments on dot-commands. In particular, allow hexadecimal arguments to .wheretrace and .testctrl commands. Cherrypick from [b9578c371ee5]. (check-in: 3bd5ad095b user: drh tags: trunk) | |
12:34 | Further improvements to error handling of the run-time loading of SQLite into TCL. (check-in: 7cc0c4ee11 user: drh tags: trunk) | |
2013-05-31
| ||
15:36 | Improved handling of errors when doing run-time loading of an SQLite shared-library into TCL. (check-in: b3f23d1864 user: drh tags: trunk) | |
14:31 | Enhance the shell to provide more flexibility when entering numeric arguments on dot-commands. In particular, allow hex arguments to .wheretrace. (check-in: b9578c371e user: drh tags: nextgen-query-plan-exp) | |
2013-05-29
| ||
17:48 | Updates to the Codec interface to support codecs on attached databases and to allow rekeying in the middle of a transaction. These changes are only applicable if SQLite is compiled with SQLITE_HAS_CODEC. (check-in: d5b084e9d8 user: drh tags: trunk) | |
14:22 | Add tests for running FTS 'merge' and 'optimize' commands in shared cache mode. (check-in: 09e5a7ad85 user: dan tags: trunk) | |
2013-05-28
| ||
20:25 | Add the percentile() SQL function as a loadable extension in the ext/misc directory. (check-in: a64d760d92 user: drh tags: trunk) | |
17:30 | Finish removing the sqlite3.inTrans field. In the previous check-in, it was merely commented out because I failed to select File->Save on my text editor. (check-in: 2f97e38a66 user: drh tags: trunk) | |
17:25 | Remove the obsolete and unused sqlite3.inTrans field. (check-in: c3381cd495 user: drh tags: trunk) | |
12:11 | Many small harmless comment changes. Removal of obsolete comments and fixing misspelled words. No changes to code. (check-in: a0d5cc9315 user: drh tags: trunk) | |
10:52 | Merge autoconf-package branch with trunk. (check-in: a72f50ef76 user: dan tags: trunk) | |
2013-05-27
| ||
18:37 | Add the "dist" target to main.mk. For building the amalgamation autoconf package. (Closed-Leaf check-in: 3fdc8b5649 user: dan tags: autoconf-package) | |
17:19 | Add the files used to build the amalgamation-autoconf package. (check-in: 048865e8fd user: dan tags: autoconf-package) | |
10:11 | When writing to an FTS table, take an exclusive shared-cache lock on the %_segdir table before writing. Otherwise, an xCommit() call may report an SQLITE_LOCKED error. (check-in: 3cd2da42e9 user: dan tags: trunk) | |
2013-05-24
| ||
12:47 | Set _XOPEN_SOURCE to 600 so that fchmod() will (hopefully) work on FreeBSD. (check-in: 61a1045239 user: drh tags: trunk) | |
11:57 | Fix harmless compiler warnings in the shell. (check-in: 9e2c17c535 user: drh tags: trunk) | |
2013-05-23
| ||
20:52 | Add OGC GeoPackage files to the magic.txt database. (check-in: dab6a32847 user: drh tags: trunk) | |
10:15 | Have the "make fulltest" command run the "mmap" permutation test. (check-in: 82ad373f85 user: dan tags: trunk) | |
10:13 | Avoid unnecessary calls to FCNTL_SIZE_HINT. Return an error to the user if the file-control invoked by "PRAGMA mmap_size" returns a value other than SQLITE_OK or SQLITE_NOTFOUND. (check-in: 40cfde8b4a user: dan tags: trunk) | |
01:40 | Cause the mmap_size PRAGMA to immediately change the mmap space if the database connection is already active. In particular, reducing mmap_size will immediately free up process address space. (check-in: 761177927c user: drh tags: trunk) | |
2013-05-20
| ||
00:56 | Version 3.7.17 (check-in: 118a3b3569 user: drh tags: trunk, release, version-3.7.17) | |
2013-05-17
| ||
20:16 | Remove a stray tab character from the transitive_closure extension source code. (check-in: 7a9aa21c35 user: drh tags: trunk) | |
17:15 | Fix a bug in SQLITE_TRACE_SIZE_LIMIT that was introduced by check-in [1a1cf5aa86734c8]. That check-in was to remove harmless compiler warnings. So once again, we have introduced a real bug into SQLite by attempting to eliminate a harmless compiler warning. (check-in: cec2bcb45a user: drh tags: trunk) | |
16:41 | In test file test_syscall.c, include sqliteInt.h before any tcl or system include files. This ensures that the magical defines in sqliteInt.h really do enable large file support (and set things up so that sizeof(off_t)==8). (check-in: 0f355bb17f user: dan tags: trunk) | |
12:52 | Use sum() instead of total() in mptest/multiwrite01.test too. (check-in: d0c2288c72 user: drh tags: trunk) | |
12:51 | Use sum() instead of total() in the mptest/crash01.test script. (check-in: 8ba0fc9811 user: drh tags: trunk) | |
12:25 | Add extra "PRAGMA mmap_size = N" statements to mmap1.test and mmap2.test. (check-in: cec0a06c17 user: dan tags: trunk) | |
12:10 | In os_unix.c and os_win.c, initialize the default mmap-limit of a new file descriptor to the current global default mmap-limit, not the current global maximum allowable mmap-limit. (check-in: 1def4ea3a0 user: dan tags: trunk) | |
2013-05-16
| ||
19:15 | Fix minor test script issues causing releasetest.tcl to fail. (check-in: d8ded9d8a1 user: dan tags: trunk) | |
18:33 | Fix a typo in Makefile.in preventing compilation with the --disable-amalgamation option. (check-in: 8ffbefe7d7 user: dan tags: trunk) | |
14:28 | Several releasetest.tcl related fixes to test cases. No code changes. (check-in: e97d744ba1 user: dan tags: trunk) | |
12:41 | Fix compilation with SQLITE_OMIT_WAL on Win32. (check-in: 6d45a79fb1 user: mistachkin tags: trunk) | |
11:57 | In sqlite3_close_v2(), do not attempt to roll back a transaction if there exist active statement objects. Any open transaction will be rolled back when the last of these statement objects is finalized. (check-in: d11e76072a user: dan tags: trunk) | |
01:02 | Treat identifiers in the HAVING clause the same as in the WHERE clause. Only consider AS names from the result set to match if there are no other matches. Continuation of the fix for [2500cdb9be05]. This check-in fixes a bug found by SqlLogicTest during release testing for version 3.7.17. (check-in: 9ffff3d052 user: drh tags: trunk) | |
2013-05-15
| ||
20:35 | Apply compilation fix from [a58af81483] to the other makefiles as well. (check-in: 7e76889d67 user: mistachkin tags: trunk) | |