Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around df36ac948179f37b.
|
2011-11-07
| ||
| 13:05 | Change the default file format from 1 to 4. This means that, unless PRAGMA legacy_file_format=ON is used first, new databases will not be readable by versions prior to 3.3.0 (2006-01-10). (check-in: a35f52b1ad user: drh tags: trunk) | |
|
2011-11-06
| ||
| 05:06 | Move function sqlite3PagerClearCache() out of the "ifndef SQLITE_OMIT_WAL" block and into an "ifndef SQLITE_OMIT_VACUUM" block. (check-in: 5dbfaed8c3 user: dan tags: trunk) | |
|
2011-11-04
| ||
| 14:36 | Update the xfer optimization code so that the xfer optimization can be used with INTEGER PRIMARY KEY ON CONFLICT ... as long as the destination table is initially empty. Improvements to the comments on the xfer optimization. New test cases added. (check-in: e3f368cd5e user: drh tags: trunk) | |
| 12:05 | Change a memcpy() in sqlite3FileSuffix() to memmove() on the grounds that the source and destination may overlap. (check-in: 5e1d247e5b user: dan tags: trunk) | |
| 10:37 | Add a missing va_end() macro to fts3.c. (check-in: e6f825748a user: dan tags: trunk) | |
| 02:24 | Use mkdir() and rmdir() rather than open() and unlink() to create the lock files with the unix-dotlock VFS. The change is backwards compatible and, we are told, works better on some network filesystems. (check-in: e2f08426d7 user: drh tags: trunk) | |
| 00:35 | Enhance the shell so that the ".schema" command works with case insensitive LIKE patterns even with PRAGMA cache_sensitive_like=ON. (check-in: b06bf3b360 user: drh tags: trunk) | |
| 00:24 | • Fixed ticket [676bc02b87]: Incorrect xfer optimization with INTERGER PRIMARY KEY ON CONFLICT REPLACE plus 2 other changes (artifact: 5d216ae9a8 user: drh) | |
| 00:23 | Make sure the INSERT INTO ... SELECT statement works correctly even when the destination table contains an INTEGER PRIMARY KEY ON CONFLICT... column. Ticket [676bc02b87176125]. (check-in: 6f9898db7f user: drh tags: trunk) | |
| 00:09 | • New ticket [676bc02b87] Incorrect xfer optimization with INTERGER PRIMARY KEY ON CONFLICT REPLACE. (artifact: 8c3f44b3dd user: drh) | |
|
2011-11-01
| ||
| 15:45 | If the read() system call in unix returns fewer bytes than expected, retry it until it either returns zero or an error. (Closed-Leaf check-in: 7225663477 user: drh tags: retry-short-reads) | |
| 00:53 | • Edit [c7c6050ef060877e|c7c6050ef0]: Change background color to "#d0c0ff". Add tag "release". (artifact: dd7b739c61 user: drh) | |
| 00:52 | Version 3.7.9 (check-in: c7c6050ef0 user: drh tags: trunk, release, version-3.7.9) | |
|
2011-10-31
| ||
| 19:59 | Fix a problem with sqlite3_backup_step() that resulted from a faulty merge. (check-in: dacdec78d0 user: drh tags: apple-osx) | |
| 19:34 | Fix the os_unix.c source file so that it will build as part of an amalgamation on non-apple platforms. (check-in: b2f7639c8f user: drh tags: apple-osx) | |
| 18:46 | • Closed ticket [8290242b2a]: ALTER TABLE RENAME fails if the database encoding is not UTF8 (artifact: 10e1dd3e36 user: drh) | |
| 18:46 | • Closed ticket [3338b3fa19]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause (artifact: 38e7c99010 user: drh) | |
| 18:45 | • Closed ticket [f1c2a689c6]: configure script ignores ``--with-tcl'' option when tclsh8.4 is installed. (artifact: 54d52170b3 user: drh) | |
| 18:44 | • Closed ticket [92bd6eaf04]: Suggestion to revise clean rule in main.mk. (artifact: 20aa3c3b78 user: drh) | |
| 18:44 | • Closed ticket [57c971fc74]: Some user defined string functions do not operate correctly on strings with embedded nuls (artifact: 6cae2ae2a4 user: drh) | |
| 14:42 | Pull the latest trunk changes into the apple-osx branch. (check-in: 4fa9ee7947 user: drh tags: apple-osx) | |
| 14:34 | Merge in all changes found in the version 3.7.9 release candidate. (check-in: 23580718e1 user: drh tags: sessions) | |
| 12:25 | Fix a typo in a comment. No code changes. (check-in: 6635cd9a77 user: drh tags: trunk) | |
| 11:36 | Add new file ext/fts3/README.content, describing the experimental FTS4 content option. (check-in: 13a9d085e1 user: dan tags: trunk) | |
| 06:52 | Update fts3fault.test to account for the sqlite3_errmsg() related changes in [8f88cc4e61] and [dcb7879347]. (check-in: 3f2d49c678 user: dan tags: trunk) | |
|
2011-10-29
| ||
| 19:25 | Update fkey_malloc.test to account for the sqlite3_errmsg() related changes in [8f88cc4e61] and [dcb7879347]. (check-in: 5b82ec6fbb user: dan tags: trunk) | |
| 15:29 | Add a test for [48f29963] that does not depend on FTS. (check-in: fb15f5458e user: dan tags: trunk) | |
| 12:42 | Fix some code formatting in sqlite3Ext.h to avoid lines longer than 80 characters. (check-in: 3ec20c3020 user: drh tags: trunk) | |
| 11:54 | • Ticket [48f299634a] Crash in SAVEPOINT within a transaction that writes to then drops an FTS table status still Closed with 1 other change (artifact: 0a2d10e31d user: dan) ... 1 similar event omitted. | |
| 11:43 | Avoid attempting to call savepoint related methods on deleted sqlite3_vtab objects. Fix for [48f299634a]. (check-in: 3565fcf898 user: dan tags: trunk) | |
| 11:36 | • Ticket [48f299634a] Crash in SAVEPOINT within a transaction that writes to then drops an FTS table status still Open with 3 other changes (artifact: a6be4fd073 user: dan) ... 1 similar event omitted. | |
| 01:33 | Avoid reporting a NOMEM error if a memory allocation fails while copying the error message from a prepared statement into the database connection. (check-in: dcb7879347 user: drh tags: trunk) | |
|
2011-10-27
| ||
| 15:19 | If an error occurs within sqlite3_step() on a statement prepared using sqlite3_prepare_v2(), transfer both the error code and error message to the database handle before sqlite3_step() returns (so that they are available via sqlite3_errcode() and sqlite3_errmsg(). Prior to this commit, only the error code was transfered. The error message was not available until after either sqlite3_reset() or sqlite3_finalize() had been called on the statement handle. (check-in: 8f88cc4e61 user: dan tags: trunk) | |
|
2011-10-25
| ||
| 21:18 | Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil (check-in: 89d63a0e1d user: drh tags: branch-3.7.2) | |
| 20:36 | Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT (check-in: 14bc58ca70 user: drh tags: branch-3.7.2) | |
|
2011-10-22
| ||
| 21:00 | Avoid a harmless reference to an uninitialized variable following an error in FTS3. This is not a bug. The change is to silence a valgrind warning. (check-in: d980c5b22f user: drh tags: trunk) | |
|
2011-10-21
| ||
| 19:06 | Purge lingering references to SQLITE_STAT2 from the code and test scripts. (check-in: aed2bf7a3c user: drh tags: trunk) | |
| 17:24 | • Edit [df36ac948179f37b|df36ac9481]: Mark "Closed". (artifact: 5a3e11e734 user: drh) | |
| 17:18 | Merge the latest trunk changes into the apple-osx branch. (check-in: be62ef058b user: drh tags: apple-osx) | |
| 17:08 | Merge the latest trunk enhancements into the sessions branch. (check-in: 8baef58170 user: drh tags: sessions) | |
| 16:47 | Remove stale requirements marks from the query planner. (check-in: 76de9914be user: drh tags: trunk) | |
| 14:27 | If an error occurs while writing to the database file during a VACUUM, discard the contents of the in-memory cache. This is required as if the database is a zipvfs database, the contents of the cache may be inconsistent with respect to the database as stored on disk. (check-in: 07159e84b4 user: dan tags: trunk) | |
|
2011-10-20
| ||
| 18:23 | Fix an issue with finding the access permissions of journal files when 8+3 filenames are in use. (check-in: 2b35c5144d user: drh tags: trunk) | |
| 00:55 | Enhancements to the omittest.tcl script used to verify that the SQLITE_OMIT compile-time options are working. (check-in: 4344483f7d user: drh tags: trunk) | |
|
2011-10-19
| ||
| 18:21 | Fix harmless compiler warnings in FTS4. (check-in: 1af4a25631 user: drh tags: trunk) | |
| 17:13 | Fix comments on SQLITE_CONFIG_HEAP so that they do not interfere with the requirements scanner. (check-in: a3151ce15c user: drh tags: trunk) | |
| 16:20 | Merge the fts4-content branch with the trunk. (check-in: 8a4077057d user: dan tags: trunk) | |
| 15:52 | Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables. (Closed-Leaf check-in: df36ac9481 user: dan tags: fts4-content) | |
| 11:57 | Change the way ^ tokens work in FTS so that the filtering is done as part of reading the FTS index instead of waiting until an entire doclist has been retrieved and then filtering it. (check-in: 9b58c59eb4 user: dan tags: fts4-content) | |
| 10:18 | Add tests for FTS ^ searches and matchinfo(). (check-in: 92618c1463 user: dan tags: fts4-content) | |
| 09:40 | Fix a problem in FTS to do with ^ tokens and the snippet() function. (check-in: 2c03b24f4c user: dan tags: fts4-content) | |
|
2011-10-18
| ||
| 22:08 | • Fixed ticket [8290242b2a]: ALTER TABLE RENAME fails if the database encoding is not UTF8 plus 2 other changes (artifact: 10056736a5 user: drh) | |
| 22:07 | Fix the virtual table rename logic so that it works even if the database encoding is something other than UTF8. Ticket [8290242b2a9a81683] (check-in: d65f63531c user: drh tags: trunk) | |
| 21:31 | • New ticket [8290242b2a] ALTER TABLE RENAME fails if the database encoding is not UTF8. (artifact: 29bc8a6fe5 user: drh) | |
| 19:39 | If a token within an FTS query is prefixed with a '^' character, it must be the first token in a column of data to match. (check-in: 63ac33c860 user: dan tags: fts4-content) | |
| 19:14 | Fix an uninitialized variable in OR-clause processing. (check-in: 54aecd9298 user: drh tags: trunk) | |
| 18:10 | • Fixed ticket [3338b3fa19]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause plus 1 other change (artifact: f362734922 user: drh) | |
| 18:10 | Improved handling of USING and NATURAL JOIN in 3-way and higher joins. Ticket [3338b3fa19ac4ab] (check-in: 551ce407bd user: drh tags: trunk) | |
| 12:49 | Cherrypick patch [3126754c72] from the trunk into the content= branch. (check-in: f9b5b21708 user: dan tags: fts4-content) | |
| 12:44 | Fix a floating-point exception that can occur when an FTS4 query contains a large number of tokens connected by AND or NEAR operators. (check-in: 3126754c72 user: dan tags: trunk) | |
|
2011-10-17
| ||
| 23:15 | Change the OP_JournalMode implementation so that it works even if a substitute sqlite3PagerFilename() that might return NULL is used. (check-in: 491ff5fb25 user: drh tags: trunk) | |
| 20:41 | Avoid 32-bit integer overflow when evaluating the exponent of a floating point value during ascii to binary conversion. (check-in: 4becc47eb4 user: drh tags: trunk) | |
| 12:14 | Performance improvement for ascii to floating-point conversions with very large exponents. (check-in: 59bb999c8b user: drh tags: trunk) | |
|
2011-10-15
| ||
| 00:16 | Added the tool/warnings-clang.sh script. Changes so that there are no warnings with either gcc or clang even including FTS4 and RTREE and both with and without SQLITE_THREADSAFE=0. (check-in: 39408702a9 user: drh tags: trunk) | |
|
2011-10-14
| ||
| 22:57 | Fix a few minor and harmless clang warnings in FTS3 and RTREE. (check-in: b3324f6cc2 user: drh tags: trunk) | |
| 21:49 | Add assert() statements and eliminate needless variable assignments in order to get the clang scan-build utility to report zero problems against the SQLite core. Clang's static analysis did find one real problem - but it was in the command-line shell, not in the SQLite core. (check-in: 60fee9574b user: drh tags: trunk) | |
|
2011-10-13
| ||
| 18:33 | • Fixed ticket [f1c2a689c6]: configure script ignores ``--with-tcl'' option when tclsh8.4 is installed. plus 3 other changes (artifact: b6fcb36707 user: drh) | |
| 18:26 | • Closed ticket [d214d7b114]: FTS3 virtual table fails when names are quoted plus 3 other changes (artifact: db537fd833 user: drh) | |
| 18:25 | • Closed ticket [9861b74ab9]: Fts3 offsets() function may report SQLITE_CORRUPT with empty string. plus 3 other changes (artifact: ccd01a1dc5 user: drh) | |
| 18:08 | • Fixed ticket [92bd6eaf04]: Suggestion to revise clean rule in main.mk. plus 1 other change (artifact: 3fa6907f18 user: drh) | |
| 18:08 | Change the makefile to delete both plain and ".exe" variants of build tools. Ticket [92bd6eaf04e117] (check-in: 19536a3828 user: drh tags: trunk) | |
| 18:01 | • Fixed ticket [57c971fc74]: Some user defined string functions do not operate correctly on strings with embedded nuls plus 3 other changes (artifact: b5983b3d0b user: drh) | |
| 18:00 | Simplifications to the upper() and lower() SQL functions. Updates to documentation on sqlite3_bind_text() and sqlite3_result_text() to make it clear that users should not try to create strings with embedded NULs and that if they do the result of expression on those strings is undefined. Ticket [57c971fc74524a] (check-in: 9984cc20ca user: drh tags: trunk) | |
| 17:34 | • Ticket [9fd058691b] Problem with updating an FTS table that contains a single row status still Closed with 1 other change (artifact: 6796c36a2b user: dan) ... 3 similar events omitted. | |
| 17:16 | Handle updating the only row of an FTS table correctly. Fix for [9fd058691]. (check-in: 7e24645be2 user: dan tags: trunk) | |
| 17:09 | An improved fix for the page_count and quick_check problem previously patched at [150592b4b4d8637] (check-in: c3cb7f4fad user: drh tags: trunk) | |
| 17:06 | • New ticket [9fd058691b] Problem with updating an FTS table that contains a single row. (artifact: 785ed2b12b user: dan) | |
| 16:36 | Provide a complete prototype for isatty() in the command-line shell sources. (check-in: 8bf13b036a user: drh tags: trunk) | |
| 16:32 | • Closed ticket [4c9223e34e]: Vacuum fails within transaction but also rolls it back plus 2 other changes (artifact: a34156cba0 user: drh) | |
| 16:30 | Change the command-line shell to do the ".dump" inside of a SAVEPOINT rather than a transaction, since this allows it to be run from within a transaction. (check-in: 6df7343b4c user: drh tags: trunk) | |
| 16:07 | • Closed ticket [ab7498f2f6]: 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause plus 1 other change (artifact: e275e42080 user: drh) | |
| 16:05 | • Ticket [3671265894] No error reporting on file open failure status still Open with 3 other changes (artifact: 79cac66ccf user: drh) | |
| 16:02 | • Fixed ticket [92af7da36b]: shell won't import large files plus 2 other changes (artifact: 046edba749 user: drh) | |
| 16:02 | Enable large-file support for fopen() and friends in the command-line shell. Ticket [92af7da36b6fbd] (check-in: eeeba4f0d2 user: drh tags: trunk) | |
| 15:56 | • Fixed ticket [0c80ff9f5a]: Quickstart missing include of stdlib.h plus 2 other changes (artifact: 79a5d8d6c3 user: drh) | |
| 15:38 | • Fixed ticket [fa7bf5ec94]: String literal case confusion in aggregate query plus 3 other changes (artifact: 6c4389fa7f user: drh) | |
| 15:35 | Make sure the query optimizer for aggregate queries knows that expressions (x='a') and (x='A') are different. Ticket [fa7bf5ec94801e7e] (check-in: e43da426e6 user: drh tags: trunk) | |
| 15:16 | • New ticket [fa7bf5ec94] String literal case confusion in aggregate query. (artifact: 02e4c841ea user: drh) | |
| 14:46 | • Closed ticket [b2d64a52a0]: pkgIndex.tcl is being deleted by 'make clean' but it is not created by 'make' plus 2 other changes (artifact: bc412bc88c user: drh) | |
| 14:44 | • Closed ticket [3338b3fa19]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause plus 2 other changes (artifact: 2040c0e591 user: drh) | |
| 14:41 | Make sure the page_count and quick_check pragmas work properly even when their names are capitalized. Fixes a problem reported on the mailing list. (check-in: 150592b4b4 user: drh tags: trunk) | |
| 14:23 | • Closed ticket [6e1086fb2c]: "create table as select" and "pragma *_column_names" plus 1 other change (artifact: f0f9668b1f user: drh) | |
| 14:18 | Adjust the symbols.sh script for STAT3. Add the symbols-mingw.sh script for testing on windows with MinGW. (check-in: c41d1d4652 user: drh tags: trunk) | |
| 14:13 | • Ticket [af3450b763] Recursive virtual tables status still Open with 3 other changes (artifact: d9fd246364 user: drh) | |
| 14:12 | • Fixed ticket [991789d9f3]: ext/fts? code uses tolower() when parsing tokens, which is problematic when using certain locales, such as tr_TR.UTF-8. plus 1 other change (artifact: 026d5b3671 user: drh) | |