Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
506 check-ins using file src/whereInt.h version d3633e9b
|
2015-03-25
| ||
| 00:09 | Backport the 'stdcall' related enhancements from trunk. (Leaf check-in: cbb93d1a user: mistachkin tags: stdcall-3.8.8) | |
|
2015-03-21
| ||
| 15:37 | When scanning the full-text index as part of the fts5 integrity-check, also run a point query for every term and verify that these results are consistent with those found by the linear scan. (check-in: ce972f6a user: dan tags: fts5) | |
|
2015-03-11
| ||
| 14:51 | Add an optimization to the fts5 unicode tokenizer code. (check-in: f5db4892 user: dan tags: fts5) | |
|
2015-03-10
| ||
| 19:24 | Avoid redundant string comparisons while merging fts5 segment b-trees. (check-in: 5c46820d user: dan tags: fts5) | |
|
2015-03-07
| ||
| 15:46 | Fix some compiler warnings caused by signed/unsigned pointer conversions. (check-in: cccee7b5 user: dan tags: fts5) | |
| 11:50 | Fix the bm25() function so that it multiplies scores by -1 before returning them. This means better matches have a lower numerical score, so "ORDER BY rank" (not "ORDER BY rank DESC") does what you want. (check-in: 3ee7b5a9 user: dan tags: fts5) | |
|
2015-03-06
| ||
| 04:37 | Clearification of some documentation text. Added requirements marks. (check-in: 8c1e85aa user: drh tags: trunk) | |
| 03:31 | Clarification of documentation on sqlite3_backup. (check-in: 31d5e9b4 user: drh tags: trunk) | |
|
2015-03-05
| ||
| 16:21 | Fix some problems with OTA and empty target databases, or target databases with the wrong set of tables. Also add SQLITE_FCNTL_VFSNAME support to the OTA VFS. (check-in: 46119e8d user: dan tags: ota-update) | |
| 15:34 | New test cases and requirements marks for PRAGMA index_info, index_xinfo, and index_list. (check-in: e5b13634 user: drh tags: trunk) | |
| 14:29 | Revert "PRAGMA index_info" to output only three columns, for complete compatibility with prior versions. The new "PRAGMA index_xinfo" can be used to get the extra information in 4th, 5th, and 6th columns. (check-in: fc543c2c user: drh tags: trunk) | |
| 14:07 | Add comments to sqlite3ota.h to make it clear that passing NULL in place of a parent VFS name to sqlite3ota_create_vfs() causes the new VFS to use the system default as its parent. (check-in: 158c1a48 user: dan tags: ota-update) | |
| 13:43 | Fix a typo in sqlite3ota.h. (check-in: 04087dec user: dan tags: ota-update) | |
| 01:29 | New requirements marks on compound SELECT statements. (check-in: e7991bc5 user: drh tags: trunk) | |
|
2015-03-04
| ||
| 23:14 | New requirements marks on INSERT and INDEXED BY and on some sqlite3_config() options. (check-in: c298ea0b user: drh tags: trunk) | |
| 20:18 | Fix harmless compiler warning. (check-in: 580dae46 user: mistachkin tags: trunk) | |
| 15:35 | Refinement to the wording of the documentation on depreciated functions. (check-in: 04a59d6f user: drh tags: trunk) | |
| 15:25 | Remove a surplus </dl> mark in the documentation. No changes to code. (check-in: 5450e465 user: drh tags: trunk) | |
| 08:29 | Fix a couple of build problems. (check-in: a5d5468c user: dan tags: fts5) | |
|
2015-03-03
| ||
| 20:42 | Clean up #ifdef logic dealing with VxWorks in os_unix.c. On VxWorks, automatically use posix advisory locking if it is available or fall back to named semaphore locking if not. (check-in: ac8c7ca3 user: drh tags: trunk) | |
| 19:56 | Fix compiler warnings when compiling under VxWorks 7. (check-in: 55c21521 user: drh tags: trunk) | |
| 16:58 | Enhance SQLITE_ALLOW_URI_AUTHORITITY to elide //localhost/ and to deal with dodgy URIs that contain too many "/" characters. (check-in: 39b566a2 user: drh tags: trunk) | |
| 14:00 | Fix over-length source code lines in the main.c source file. (check-in: debba6f1 user: drh tags: trunk) | |
|
2015-03-02
| ||
| 22:06 | Changes so that the amalgamation and the command-line shell build without modifications on VxWorks 7. Still gives a few compiler warnings, and still mostly untested on that platform. (check-in: 7d92f1f1 user: drh tags: trunk) | |
| 17:25 | Ensure that automatic indexes are *not* considered when doing the the subqueries of the OR-optimization. (check-in: 17890292 user: drh tags: trunk) | |
|
2015-02-28
| ||
| 14:03 | In the command-line shell, the inability to read ~/.sqliterc is no longer a fatal error. A warning is issued, but processing continues. (check-in: 6bf62463 user: drh tags: trunk) | |
| 01:04 | More test cases and requirements marks for pragmas. (check-in: fc51037c user: drh tags: trunk) | |
|
2015-02-27
| ||
| 21:53 | Remove all references to SQLITE_DEFAULT_TEMP_CACHE_SIZE. Add requirements marks related to cache_size changing. (check-in: 766ad650 user: drh tags: trunk) | |
| 20:28 | New requirements marks and a few new test cases to go with them. No changes to code. (check-in: 8c2b29d9 user: drh tags: trunk) | |
| 19:40 | Merge updates from trunk. (check-in: acf76843 user: mistachkin tags: expShell) | |
| 09:41 | Further minor optimizations to flushing fts5 data to disk. (check-in: a07dcca9 user: dan tags: fts5) | |
| 07:23 | Fix suffix and prefix compression of terms in top-level fts5 segments. And a crash that could follow an OOM condition. (check-in: bb104b36 user: dan tags: fts5) | |
| 00:33 | Add a couple of requirements marks. (check-in: d70b0fd4 user: drh tags: trunk) | |
|
2015-02-26
| ||
| 21:04 | Fix potential memory leaks in the misc 'compress' extension. (check-in: 3bc34fd4 user: mistachkin tags: trunk) | |
| 20:49 | Optimize copying data from fts5 in-memory hash tables to top level segments. (check-in: 8e3ca632 user: dan tags: fts5) | |
| 16:40 | Update a requirements mark to reflect a change of wording in the documentation. No changes to code. (check-in: 3038d016 user: drh tags: trunk) | |
| 16:32 | Fix a real bug (in test code) that was introduced while trying to eliminate harmless compiler warnings from OpenBSD (see check-in [10321910990195878c]). (check-in: a62ba58c user: drh tags: trunk) | |
| 14:54 | Fix an fts5 bug in large incremental merges. (check-in: 208e3cb6 user: dan tags: fts5) | |
| 14:27 | In the command-line shell, change the units on the ".width" directive from bytes to characters. (Leaf check-in: b1a9e291 user: drh tags: cli-char-width) | |
| 02:33 | Simplifications to the description of the nByte parameter to sqlite3_prepare() and friends. (check-in: 4bee8295 user: drh tags: trunk) | |
|
2015-02-25
| ||
| 19:24 | Instead of the 4-byte fields, use regular varints for the poslist-size field in fts5_hash.c. (check-in: 7eb022d7 user: dan tags: fts5) | |
| 14:25 | Make sure the sqlite3_mutex.id field is initialized in the Win32 mutex implementation, even when SQLITE_DEBUG is turned off. (check-in: 6d132e7a user: drh tags: trunk) | |
| 14:09 | Merge the latest trunk fixes and enhancements into the apple-osx branch. (check-in: ba8294e2 user: drh tags: apple-osx) | |
| 14:02 | Merge the latest trunk fixes into the sessions branch. (check-in: 131a2d31 user: drh tags: sessions) | |
| 13:48 | Add support for the linenoise command-line editing library in shell.c. (check-in: 03bbb947 user: drh tags: trunk) | |
| 13:29 | Version 3.8.8.3 (Leaf check-in: 9d6c1880 user: drh tags: release, version-3.8.8.3, branch-3.8.8) | |
| 12:52 | Add support for linenoise to shell.c. (check-in: ec27ab0e user: dan tags: branch-3.8.8) | |
| 10:54 | Add support for linenoise to shell.c. (Closed-Leaf check-in: f7f2598c user: dan tags: linenoise) | |
| 01:06 | When cleaning with MSVC, prevent superfluous output regarding 'missing' files and directories. (check-in: 034c16bd user: mistachkin tags: trunk) | |
| 00:24 | Remove an always-false conditional from constructAutomaticIndex(). Put an assert() in its place to prove that the conditional is always false. (check-in: 3af300bf user: drh tags: trunk) | |
|
2015-02-24
| ||
| 20:12 | Make sure partial indexes are not qualified incorrectly by a constraint that is inside the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead33]. Cherry-pick from [491cfe9b3f87f]. (check-in: 9d94ac6a user: drh tags: branch-3.8.8) | |
| 20:10 | Prevent partial indexes on the table on the left hand side of a LEFT JOIN from being incorrectly qualified by a constraint in the ON clause of the join. This relaxes the rule introduced by the previous commit (as the partial indexes on the table on the rhs of the LEFT JOIN may now be qualified by terms within the ON clause). (check-in: 1d6fb43a user: dan tags: trunk) | |
| 20:04 | Make sure partial indexes are not qualified incorrectly by a constraint that is inside the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead33]. (check-in: 491cfe9b user: drh tags: trunk) | |
| 18:39 | More test cases to help ensure that partial indexes do not get used if their qualifing constraint is inside the ON clause of a LEFT JOIN. (Closed-Leaf check-in: c6399958 user: drh tags: tkt-2326c258) | |
| 16:48 | This additional fix prevents a partial index from being qualified for use if the constraint that qualifies the partial index is part of the ON clause of a LEFT JOIN. (check-in: 1a1516e4 user: drh tags: tkt-2326c258) | |
| 16:22 | Increase the version number to 3.8.8.3 (check-in: a92afe7d user: drh tags: branch-3.8.8) | |
| 16:05 | Make sure partial automatic indexes are not based on terms in the ON clause of a LEFT JOIN. Fix for ticket [2326c258d02ead3]. UPDATE: This fix does not work where the partial index is a named index. (check-in: c0f4e308 user: drh tags: tkt-2326c258) | |
|
2015-02-23
| ||
| 20:09 | Fix building with ENABLE_OTA and OMIT_LOAD_EXTENSION. (check-in: d6d21ff5 user: dan tags: ota-update) | |
| 16:17 | Merge latest trunk changes with this branch. (check-in: e5ca79d2 user: dan tags: ota-update) | |
| 15:41 | Change SQLITE_FCNTL_ZIPVFS_PAGER to SQLITE_FCNTL_ZIPVFS. (check-in: f7865b94 user: dan tags: ota-update) | |
| 15:02 | Update the sqlite3ota_db() API to account for the fact that each OTA handle now uses two SQLite database handles. (check-in: ef08ecce user: dan tags: ota-update) | |
| 12:22 | Improve tests for resuming ota updates following power failures. Fix a problem revealed by the same. (check-in: 1cb675e5 user: dan tags: ota-update) | |
|
2015-02-21
| ||
| 20:08 | Fix some problems with resuming ota updates if saving the state is interrupted by a power failure or system crash. (check-in: 6d5ed70d user: dan tags: ota-update) | |
| 15:42 | Update document on sqlite3_mprintf() and related functions. Discuss the %w format and point out that obscure ANSI-C formats are not supported. No changes to code. (check-in: f8917ba4 user: drh tags: trunk) | |
| 15:13 | Merge all recent trunk changes into the sessions branch. (check-in: f36bb5fa user: drh tags: sessions) | |
| 01:03 | Merge trunk changes into the apple-osx branch. (check-in: 3896e233 user: drh tags: apple-osx) | |
| 00:56 | Fix a compiler warning associated with USE_PREAD64. (check-in: c299e55a user: drh tags: trunk) | |
| 00:49 | Fix over-length source code lines in os_unix.c. (check-in: 7560a9fa user: drh tags: trunk) | |
| 00:19 | Keep track of the optimal number of reserved bytes (by looking at reserve byte requests in calls to sqlite3BtreeSetPageSize()) and then change the reserve byte count to the optimal when doing a VACUUM or when using the backup API. (check-in: 28c2b726 user: drh tags: trunk) | |
|
2015-02-20
| ||
| 14:36 | Add some missing comments and fix other minor code issues in sqlite3ota.c. (check-in: 718fd8b6 user: dan tags: ota-update) | |
|
2015-02-19
| ||
| 19:59 | Ensure the mutex used to protect the linked list of all main database files opened by a single ota vfs is allocated. (check-in: 9c8682d6 user: dan tags: ota-update) | |
| 18:06 | Update various documentation comments in sqlite3ota.c and sqlite3ota.h. (check-in: 60e0a46b user: dan tags: ota-update) | |
| 17:16 | Fix errors in the EBCDIC upper-case to lower-case translation table. (check-in: 905009f6 user: drh tags: trunk) | |
| 16:12 | Remove a redundant call to statfs() in the xOpen() method of the unix VFS. Also fix an unused local variable warning. (check-in: 8215727d user: drh tags: trunk) | |
| 15:56 | Incremental merge to prevent a huge pileup of merge conflicts resulting from editing the same code in two different branches. (check-in: 82c4c4e2 user: drh tags: apple-osx) | |
| 14:41 | Merge latest trunk changes with this branch. (check-in: 6f5888a5 user: dan tags: ota-update) | |
| 13:36 | Add tests for a couple of previously untested branches in the ota code. (check-in: a3c1bc5d user: dan tags: ota-update) | |
| 02:43 | Move the os_unix.c file closer to trunk. (check-in: 57d70240 user: drh tags: apple-osx) | |
| 02:43 | Move the os_unix.c file closer to apple-osx. (check-in: 81f242e3 user: drh tags: trunk) | |
| 00:29 | First small steps toward brining trunk and apple-osx closer together. (check-in: 28284ccc user: drh tags: trunk) | |
|
2015-02-18
| ||
| 20:17 | Add new file ota12.test, containing tests for applying ota updates to live databases with other active reader/writer clients. (check-in: 0864d127 user: dan tags: ota-update) | |
| 20:16 | Add ota tests to increase code coverage. Fix some minor issues in error handling within the ota code. (check-in: 2b10c5d2 user: dan tags: ota-update) | |
| 17:40 | Fix a problem with OTA updates in the presence of database readers. (check-in: 144bb29f user: dan tags: ota-update) | |
|
2015-02-17
| ||
| 20:49 | Improve test coverage of ota code a bit. (check-in: a438fa6c user: dan tags: ota-update) | |
|
2015-02-16
| ||
| 21:13 | Add extra tests and fixes for ota. (check-in: e0b71519 user: dan tags: ota-update) | |
| 11:48 | Add further tests and fixes for ota. (check-in: 62dc1fff user: dan tags: ota-update) | |
| 06:27 | Move tcl test code from sqlite3ota.c to new file ext/ota/test_ota.c. (check-in: f20779a6 user: dan tags: ota-update) | |
|
2015-02-14
| ||
| 18:58 | Change the way the "incremental checkpoint" function of OTA works in order to reduce the effect on the SQLite core code. (check-in: b64a11a7 user: dan tags: ota-update) | |
|
2015-02-13
| ||
| 16:42 | Enhancements to SQLITE_ENABLE_API_ARMOR merged from trunk. (check-in: 5147b94a user: drh tags: apple-osx) | |
| 16:36 | Improvements to SQLITE_ENABLE_API_ARMOR. (check-in: 823ad40c user: drh tags: trunk) | |
| 12:13 | Merge all recent trunk fixes and enhancements into the apple-osx branch. (check-in: b2449d67 user: drh tags: apple-osx) | |
| 12:05 | Make sure the prepared statement auto-resets on extended error codes of SQLITE_BUSY and SQLITE_LOCKED even when compiled using SQLITE_OMIT_AUTORESET. (check-in: 3c6ca414 user: drh tags: trunk) | |
|
2015-02-12
| ||
| 22:45 | For the shell '.import' command, make sure the last column value present is considered before NULL filling any missing ones. (check-in: 9c5bcad1 user: mistachkin tags: trunk) | |
| 17:15 | Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. Cherrypick of [245e8730451f]. (check-in: b2082462 user: dan tags: branch-3.8.8) | |
|
2015-02-11
| ||
| 17:05 | Merge the ota-update-no-pager_ota_mode branch into this one. (check-in: 71887cd9 user: dan tags: ota-update) | |
| 16:54 | Merge latest trunk changes with this branch. (Closed-Leaf check-in: 0b63e8dc user: dan tags: ota-update-no-pager_ota_mode) | |
| 16:25 | Ensure that an error is reported if an attempt is made to update a wal mode database via ota. (check-in: 6fc5d4d2 user: dan tags: ota-update-no-pager_ota_mode) | |
|
2015-02-10
| ||
| 20:00 | Further tweaks to work with zipvfs. (check-in: 0f152416 user: dan tags: ota-update-no-pager_ota_mode) | |
| 17:08 | Add documentation and test cases for sqlite3ota_create_vfs(). Also code to detect errors in zipvfs/ota setup. (check-in: e7296681 user: dan tags: ota-update-no-pager_ota_mode) | |
|
2015-02-09
| ||
| 20:07 | Add the sqlite3ota_create_vfs() and sqlite3ota_destroy_vfs() functions. (check-in: 96443ecb user: dan tags: ota-update-no-pager_ota_mode) | |
| 18:28 | Propagate COLLATE operators upward through function calls and CASE operations. And do not flatten an aggregate subquery into a query that uses other subqueries. Fixes for tickets [ca0d20b6cdddec5] and [2f7170d73bf9], respectively. (check-in: 24e78b8d user: drh tags: trunk) | |
| 17:46 | Fix WITHOUT ROWID table handing in sqlite3_analyzer. (check-in: 937e0fe7 user: dan tags: trunk) | |
| 16:34 | Add test cases for the query flattener fix for ticket [2f7170d73bf9abf8]. (Closed-Leaf check-in: dd8f7f75 user: drh tags: tkt-2f7170d7) | |
| 16:09 | Propagate the COLLATE operator upward through function calls. Initial fix for ticket [ca0d20b6cdddec5e8]. (check-in: c053448a user: drh tags: tkt-2f7170d7) | |
| 15:21 | Disable the query flattener for aggregate subqueries if the parent query uses other subqueries in its result set or WHERE clause or ORDER BY clause. Preliminary fix for ticket [2f7170d73bf9abf8]. However it still contains a defect similar to the COLLATE problem of [ca0d20b6cddd]. (check-in: 0b7d65e3 user: drh tags: tkt-2f7170d7) | |
| 14:07 | Rename the internal "EP_Constant" bitmask to a less misleading "EP_ConstFunc". (check-in: 4ef7cece user: drh tags: trunk) | |
| 13:42 | In selecttrace 0x100 mode, show the parse tree after name resolution instead of before flattening, so that it is always seen even if flattening does not occur. Also: add the hex pointer value to the top of each SELECT tree. (check-in: aa093fef user: drh tags: trunk) | |
| 11:54 | In selecttrace mode 0x100, show a complete parse-tree both before and after query flattening. This is a change to debugging code only. (check-in: b3c6b8a3 user: drh tags: trunk) | |
| 10:20 | Fix over-length source code lines in resolver.c. No logic changes. (check-in: c12edb85 user: drh tags: trunk) | |
|
2015-02-07
| ||
| 20:20 | Add comments to explain the role of the ota vfs. (check-in: 7bb63363 user: dan tags: ota-update-no-pager_ota_mode) | |
| 19:17 | Remove "PRAGMA pager_ota_mode". (check-in: 8ac58e46 user: dan tags: ota-update-no-pager_ota_mode) | |
| 15:30 | Merge increment blob I/O fixes from trunk. (check-in: 292cf68b user: drh tags: apple-osx) | |
| 15:16 | Fix potential 32-bit integer overflow problems on the offset and length parameters to sqlite3_blob_read() and sqlite3_blob_write(). For sqlite3_blob_open(), make sure the *ppBlob return parameter is zeroed if the interface fails with SQLITE_MISUSE. (check-in: 5df02f50 user: drh tags: trunk) | |
|
2015-02-06
| ||
| 16:03 | Merge all recent trunk enhancements into the apple-osx branch. (check-in: 44711921 user: drh tags: apple-osx) | |
| 15:40 | Merge all the latest enhancements from trunk. (check-in: ae7eef11 user: drh tags: sessions) | |
| 15:03 | Merge the command-line shell enhancements from trunk. (check-in: c3931db5 user: drh tags: ota-update) | |
| 14:51 | Change the name of ".info" to ".dbinfo" and add an optional second argument which is the ATTACH-ed DB about which information is provided. Provide ".indexes" as an alternative name to the legacy ".indices" command. (check-in: 0f65a7e2 user: drh tags: trunk) | |
| 14:19 | Add the ".info" command to the shell. (check-in: 0a3100a7 user: drh tags: trunk) | |
| 01:07 | Add the index_xinfo pragma which gives information about the fields that reference the table PRIMARY KEY in addition to the index key fields. Add extra columns "desc", "coll", and "key" to the index_info and index_xinfo pragmas. Add the "origin" and "partial" columns to the index_list pragma. (check-in: 2743846c user: drh tags: trunk) | |
| 00:31 | Revise the way that the index structure for a WITHOUT ROWID table is discovered. (check-in: 7f10a0ea user: drh tags: ota-update) | |
|
2015-02-05
| ||
| 17:46 | Change a comment in sqlite3ota.h to make it clear that it is not possible to insert a NULL value into an INTEGER PRIMARY KEY column using ota. (check-in: a5e86bea user: dan tags: ota-update) | |
| 17:36 | Prevent ota updates from violating NOT NULL constraints. Add a comment to the "limitations" section of sqlite3ota.h saying that CHECK constraints are not enforced. (check-in: 74e073dd user: dan tags: ota-update) | |
| 01:49 | Figure out the primary-key type of a table using queries of sqlite_master and the table_info and index_list pragmas, obviating the need for SQLITE_TESTCTRL_TBLTYPE. (check-in: 50ecdfc4 user: drh tags: ota-update) | |
|
2015-02-04
| ||
| 23:51 | Merge all changes from index_xinfo, including the move of the pragma table into the separate pragma.h file. (check-in: 21e95d28 user: drh tags: ota-update) | |
| 23:13 | Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. (Closed-Leaf check-in: 3af19f84 user: drh tags: index_xinfo) | |
| 20:56 | Fix a missing mutex in SQLITE_TESTCTRL_IMPOSTER. (check-in: 71691c4b user: drh tags: trunk) | |
| 19:20 | Fix the error messages returned by ota if an update violates a unique constraint. (check-in: c4845a3b user: dan tags: ota-update) | |
| 16:32 | Avoid a linear scan of the entire table when ota updates or deletes a row from a table with an external primary key index. (check-in: 1db198cc user: dan tags: ota-update) | |
| 11:08 | Fix a memory leak that could follow an OOM error in ota. (check-in: 0d5415f2 user: dan tags: ota-update) | |
|
2015-02-03
| ||
| 19:20 | Fix a typo in the --help output for speedtest1. Fix a dependency error in the Makefile.in for speedtest1. (check-in: f30a057a user: drh tags: trunk) | |
| 18:43 | Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes . (check-in: a21fefb7 user: dan tags: ota-update) | |
| 15:56 | Remove "PRAGMA ota_mode". (check-in: 1c111447 user: dan tags: ota-update) | |
|
2015-02-02
| ||
| 22:19 | Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. (Leaf check-in: 6dca23e6 user: drh tags: preload-pragma) | |
| 21:34 | Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. (check-in: 32c0325b user: drh tags: trunk) | |
| 11:58 | Ensure generated header file fts5parse.h is included in sqlite3.c. (check-in: bc7be2fc user: dan tags: fts5) | |
| 11:32 | Fix some problems with building fts5 and fts3 together using the amalgamation. (check-in: fb10bbb9 user: dan tags: fts5) | |
| 09:40 | Merge latest trunk changes with this branch. (check-in: 76212f2c user: dan tags: fts5) | |
|
2015-01-31
| ||
| 20:42 | Have ota use imposter tables to write to indexes instead of the sqlite3_index_writer() interface. The error handling in this version is broken in a few small ways. (check-in: cdaeab46 user: dan tags: ota-update) | |
| 15:23 | Minor optimizations to fts5 writes. (check-in: 1fffe51f user: dan tags: fts5) | |
| 02:34 | Merge in support for the index_xinfo pragma. (check-in: f9b6dc77 user: drh tags: ota-update) | |
| 02:00 | Add the "index_xinfo" pragma. Add new columns to the "index_info" and "index_list" pragmas. (check-in: 30f51d7b user: drh tags: index_xinfo) | |
|
2015-01-30
| ||
| 21:00 | Merge the SQLITE_TESTCTRL_IMPOSTER changes from trunk. (check-in: 3ed6eb2f user: drh tags: ota-update) | |
| 20:59 | Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order of parameters. Give it the ability to reset the schema parse table so that imposter tables can be erased. (check-in: 42d56017 user: drh tags: trunk) | |
| 16:36 | Merge all recent trunk changes, and especially the SQLITE_TESTCTRL_INITMODE enhancement. (check-in: 36436dde user: drh tags: ota-update) | |
| 15:52 | Added SQLITE_TESTCTRL_INITMODE for improved testability. (check-in: 98e02913 user: drh tags: trunk) | |
| 15:40 | Add a few simple test cases for SQLITE_TESTCTRL_INITMODE - cases which also test PRAGMA integrity_check. (Closed-Leaf check-in: 3a6e2afe user: drh tags: initmode-testctrl) | |
| 14:30 | Version 3.8.8.2 (check-in: 7757fc72 user: drh tags: release, version-3.8.8.2, branch-3.8.8) | |
|
2015-01-29
| ||
| 20:59 | Fix some problems with transactions that both read and write an fts5 table. (check-in: 0e225b15 user: dan tags: fts5) | |
| 20:01 | Bump the version number to 3.8.8.2 (check-in: 65bfbbb4 user: drh tags: branch-3.8.8) | |
| 19:59 | Ensure that "PRAGMA wal_checkpoint = TRUNCATE|FULL|RESTART" block on other connections and truncate the wal file as required even if the entire wal file has already been checkpointed. Cherry-pick from trunk. (check-in: 18610617 user: drh tags: branch-3.8.8) | |
| 19:27 | Fix some duplicated test names. (check-in: 1797158d user: mistachkin tags: trunk) | |
| 19:12 | Ensure that "PRAGMA wal_checkpoint = TRUNCATE|FULL|RESTART" block on other connections and truncate the wal file as required even if the entire wal file has already been checkpointed. (check-in: 53429689 user: dan tags: trunk) | |
| 18:38 | Split up the SRC variable in Makefile.msc to avoid over-long cmd.exe commands when TOP is set to a long pathname. (check-in: 7d70ac65 user: drh tags: trunk) | |
| 17:54 | Add the INITMODE test-control. (check-in: 5940af8e user: drh tags: initmode-testctrl) | |
| 15:53 | Improvements to the DELETE code generator for the one-pass case. Avoid some OP_Goto instructions. Read content from the index cursor if the index cursor is valid and was used to locate the row that is to be deleted. (Closed-Leaf check-in: 58cc257a user: drh tags: one-writable-btree) | |
| 14:48 | Avoid overlength command lines in Makefile.msc when using TOP= with a large directory name. (check-in: 0cdd59bf user: drh tags: one-writable-btree) | |
| 11:52 | Optimize range constraints on the rowid column of fts3/4 tables even if there is no MATCH clause in the query. (check-in: 85dc1262 user: dan tags: trunk) | |
| 02:26 | Experimental sqlite_db_config() setting to disable writing to all btrees except for one btree with a particular root page. (check-in: 23054110 user: drh tags: one-writable-btree) | |
|
2015-01-28
| ||
| 20:37 | Add missing VdbeCoverage() macros to the sqlite3_index_writer() implementation. (check-in: 6f8cda26 user: drh tags: ota-update) | |
| 15:30 | When a "full", "restart" or "truncate" checkpoint is attempted, return SQLITE_BUSY if a reader prevents the checkpointer from copying any frames at all into the database file. (check-in: f2700040 user: dan tags: ota-update) | |
| 12:27 | Correctly detect errors returned by walCheckpointStart() due to OOM. (check-in: 8e878c20 user: drh tags: ota-update) | |
| 12:00 | Merge in all changes from trunk. (check-in: 17c69be8 user: drh tags: ota-update) | |
|
2015-01-27
| ||
| 21:24 | Fix harmless compiler warnings. (check-in: e7d2ec04 user: mistachkin tags: trunk) | |
| 20:41 | Fix a problem with fts5 doclist-indexes that occured if the first rowid of the first non-term page of a doclist is zero. (check-in: f704bc05 user: dan tags: fts5) | |
| 19:01 | Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the first token in a column. (check-in: adc9283d user: dan tags: trunk) | |
| 18:43 | Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. (check-in: 245e8730 user: dan tags: trunk) | |
| 13:17 | Fix a (almost always harmless) read past the end of a memory allocation that comes about because the Expr.pTab field is checked on an EXPR_REDUCEDSIZE Expr object before checking the Expr.op field to know that the Expr.pTab field is meaningless. (check-in: e098de69 user: drh tags: trunk) | |
|
2015-01-25
| ||
| 20:19 | The va_list argument cannot take on a NULL value and cannot be compared with NULL on some platforms (ex: ARM). So do not attempt to do so. (check-in: 1964e656 user: drh tags: trunk) | |
|
2015-01-24
| ||
| 19:57 | Have fts5 store rowids in ascending order. Query speed is virtually the same regardless of rowid order, and ascending order makes some insert optimizations easier. (check-in: 5206ca60 user: dan tags: fts5) | |
| 12:12 | In the command-line shell, make sure stderr is unbuffered so that it automatically flushes. This has always been the case already for unix and on Windows when the output is a console, but apparently was not the case on Windows when the output was a pipe. (check-in: 2a9ea9b4 user: drh tags: trunk) | |
|
2015-01-23
| ||
| 17:43 | Fix compression of keys stored on internal segment b-tree nodes by fts5. (check-in: 51444f67 user: dan tags: fts5) | |
| 06:50 | Remove some redundant code from fts5. (check-in: 939b7a5d user: dan tags: fts5) | |
|
2015-01-22
| ||
| 19:13 | Add further tests and fixes for fts5. (check-in: 5b295897 user: dan tags: fts5) | |
| 12:00 | Make sure errors in the FROM clause of a SELECT cause analysis to abort and unwind the stack before those errors have a chance to mischief in the "*" column-name wildcard expander. Fix for ticket [32b63d542433ca67]. (check-in: 9e6eae66 user: drh tags: trunk) | |
| 11:29 | Change the undocumented ".selecttrace" command in the shell to accept an integer bitmask rather than a boolean. (check-in: bd63bf88 user: drh tags: trunk) | |
|
2015-01-21
| ||
| 20:30 | Further tests and fixes for fts5. (check-in: c020a291 user: dan tags: fts5) | |
| 18:23 | Fix an fts5 issue with loading doclist-indexes for a term that is the last thing on its leaf page. (check-in: e0d61442 user: dan tags: fts5) | |
| 17:20 | Merge trunk changes with this branch. (check-in: f8699a1a user: dan tags: fts5) | |
| 17:00 | Fix an assert() that may fail following an OOM error. (check-in: 5f592359 user: dan tags: trunk) | |
| 16:10 | Add further tests for fts5 backend. (check-in: 09dabb3b user: dan tags: fts5) | |
| 06:36 | Merge latest trunk changes with this branch. (check-in: b3348b1e user: dan tags: fts5) | |
| 00:51 | Fix harmless compiler warning seen with MSVC. (check-in: 78c2e62b user: mistachkin tags: trunk) | |
| 00:48 | Enhancements to entropy generation for the Win32 VFS. (check-in: 26190b3c user: mistachkin tags: trunk) | |
|
2015-01-20
| ||
| 20:34 | Add extra fault injection tests to fts5. (check-in: f45a0dc0 user: dan tags: fts5) | |
| 16:51 | Version 3.8.8.1 (check-in: f73337e3 user: drh tags: release, version-3.8.8.1, branch-3.8.8) | |
| 03:04 | Fix another instance of an incorrect value for KeyInfo.nXField on a sorting index. Ticket [f97c4637102a3ae72b79]. (check-in: 0077f645 user: drh tags: trunk) | |
| 02:51 | Change the version number to 3.8.8.1 (check-in: c75555a3 user: drh tags: branch-3.8.8) | |
| 02:50 | Fix another instance of an incorrect value for KeyInfo.nXField on a sorting index. More changes for ticket [f97c4637102a3ae72b79]. (check-in: dc711db4 user: drh tags: branch-3.8.8) | |
|
2015-01-19
| ||
| 21:38 | Ensure that the KeyInfo.nXField value for ephemeral tables used to implement ORDER BY or GROUP BY clauses is set correctly, so that the sqlite3VdbeFindCompare() routine can choose the correct comparison function. Add assert() statements to the high-speed comparison functions to detect cases where they are inappropriately chosen. Fix for ticket [f97c4637102a3ae72b7911]. (check-in: 59e592f6 user: drh tags: branch-3.8.8) | |
| 21:36 | Ensure that the KeyInfo.nXField value for ephemeral tables used to implement ORDER BY or GROUP BY clauses is set correctly, so that the sqlite3VdbeFindCompare() routine can choose the correct comparison function. Add assert() statements to the high-speed comparison functions to detect cases where they are inappropriately chosen. Fix for ticket [f97c4637102a3ae72b7911]. (check-in: f7201bb0 user: drh tags: trunk) | |
| 21:27 | Improve precision of the new test case by removing a superfluous carriage-return from the shell command input. (check-in: 913c41b2 user: mistachkin tags: expShell) | |
| 21:11 | Add comments and improve the new test case. (check-in: 4ec2aead user: mistachkin tags: expShell) | |
| 21:10 | There are asserts in place now that will prevent a recurrence of ticket [f97c4637102a3ae7]. Nevertheless, it is good to add some test cases as well. (Closed-Leaf check-in: e02959b9 user: drh tags: tkt-f97c4637) | |
| 20:59 | Make sure that the KeyInfo.nXField value of ephermeral tables used for ORDER BY and GROUP BY is set correctly, so that the correct comparison function can be choosen by sqlite3VdbeFindCompare(). (check-in: c16bae5e user: drh tags: tkt-f97c4637) | |
| 20:57 | Fix the assert() of the previous check-in so that it works even when compiled without SQLITE_DEBUG. (check-in: 38868f84 user: drh tags: tkt-f97c4637) | |
| 20:22 | Remove a shell function that is now superfluous. (check-in: d8564f70 user: mistachkin tags: expShell) | |
| 20:19 | Merge updates from trunk. (check-in: d9f4035b user: mistachkin tags: expShell) | |
| 20:05 | Fix compilation on Cygwin when SQLITE_MAX_WORKER_THREADS is greater than zero. (check-in: 2037442c user: mistachkin tags: trunk) | |
| 19:48 | An alternative way of implementing the assert() that verifies the relative values of KeyInfo.nField+KeyInfo.nXField and the number of columns in a record. This version of the assert() only fires when the high-speed comparison routines are used - which is to say it only fires when the constraint actually matters. (check-in: bf744b49 user: drh tags: tkt-f97c4637) | |
| 19:21 | An alternative way of fixing the key comparison bug of ticket [f97c4637102a3ae72b]. (Closed-Leaf check-in: e41376cf user: drh tags: alt1-tkt-f97c4637) | |
| 18:18 | Strengthen the KeyInfo number-of-columns assert() added by the previous check-in. (Closed-Leaf check-in: d0971b79 user: drh tags: tkt-f97c4637) | |
| 17:28 | Add an assert() to verify that the nField+nXField values of a KeyInfo object are never less then the number of columns in a row for a non-corrupt database. This assert() currently fails, which is the root of the problem with ticket [f97c4637102a3ae72b]. (check-in: 083f523d user: drh tags: tkt-f97c4637) | |
| 15:05 | Enhance the command-line shell with the ability to set the SQLITE_TESTCTRL_NEVER_CORRUPT flag using: ".testctrl never_corrupt 1". (check-in: 824328f9 user: drh tags: trunk) | |
| 11:15 | Handle the case where a tokenizer determines that there are zero tokens in an fts5 query term. (check-in: 75f3d17f user: dan tags: fts5) | |
| 07:42 | Merge updates from trunk. (check-in: c7167f88 user: mistachkin tags: expShell) | |
| 00:35 | Eliminate all use of sprintf(), strcpy() and strcat() from test logic because OpenBSD hates those functions. (check-in: 10321910 user: drh tags: trunk) | |
|
2015-01-18
| ||
| 20:30 | Set binary mode for output on Windows when writing a quoted string that might contain newline characters. (check-in: 7096e6c0 user: drh tags: trunk) | |
| 09:02 | Modify the new shell test case to work on non-Windows platforms as well. (check-in: f362c5d9 user: mistachkin tags: expShell) | |
| 05:35 | Some experimental command line shell input/output enhancements. (check-in: 25e99f3f user: mistachkin tags: expShell) | |
| 01:50 | Set the command-line shell stdin to binary mode on windows. (check-in: 80541e8b user: drh tags: trunk) | |
|
2015-01-17
| ||
| 20:01 | Ensure an up to date copy of the fts5 configuration has been loaded into memory before attempting to modify the same configuration. (check-in: f30afd20 user: dan tags: fts5) | |
| 17:48 | Improve the performance of the fts5 porter tokenizer implementation. (check-in: 96ea6004 user: dan tags: fts5) | |
| 15:26 | Fix a harmless compiler warning the VFS for Windows. (check-in: ceac571f user: drh tags: trunk) | |
|
2015-01-16
| ||
| 19:35 | Fix harmless compiler warning. (Closed-Leaf check-in: cab46fb7 user: mistachkin tags: msvcWarn) | |
| 12:44 | Merge all 3.8.8 changes into the sessions branch. (check-in: bebd131a user: drh tags: sessions) | |
| 12:24 | Merge the 3.8.8 release changes from trunk. (check-in: 518621f8 user: drh tags: apple-osx) | |
| 12:08 | Version 3.8.8 (check-in: 7d68a42f user: drh tags: trunk, release, version-3.8.8) | |
|
2015-01-15
| ||
| 17:38 | Fix the spelling of "malloc_usable_size" in configure and configure.ac. (check-in: 8f45217c user: drh tags: trunk) | |
| 15:47 | Makefile enhancements: (1) Rename autoconf/tea/configure.in to autoconf/tea/configure.ac so that it works with the latest versions of autoconf. (2) Add the "amalgamation-tarball" targets to Makefile.in and main.mk (renamed from "dist" in the latter case). (3) Update the README.first file in autoconf/ (4) The TOP macro in Makefile.in is now an absolute rather than a relative path. (check-in: 3bafeec9 user: drh tags: trunk) | |
|
2015-01-14
| ||
| 17:16 | Merge trunk 3.8.8 beta changes into the sessions branch (check-in: 0ba12454 user: drh tags: sessions) | |
|
2015-01-13
| ||
| 21:26 | Simplify some code in rtree, to avoid confusing the optimizer in GCC on some macs: gcc version 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00). Prior to these changes, compiling with -O3 would cause incorrect code to be generated. The change to the nodeGetCell() routine is key. The other changes are merely cosmetic details discovered while bug hunting. (check-in: 882181ff user: drh tags: trunk) | |
| 17:25 | Fix prefix indexes so that they work in characters, not bytes. (check-in: af8d43a4 user: dan tags: fts5) | |
| 01:12 | Fix the e_walauto.test test module so that it works on both little-endian and big-ending machines. (check-in: 5682db7b user: drh tags: trunk) | |
|
2015-01-12
| ||
| 21:43 | Fix harmless compiler warnings when using -W4 with MSVC. (check-in: e693e11d user: mistachkin tags: trunk) | |
| 20:25 | Fix harmless compiler warning in an assert() statement. (Closed-Leaf check-in: bdbeed01 user: mistachkin tags: msvcW4) | |
| 20:20 | Add two more classes of harmless MSVC compiler warnings. (check-in: de30d5b0 user: mistachkin tags: msvcW4) | |
| 19:59 | Silence some harmless uninitialized local variable warnings. (check-in: 44375a34 user: mistachkin tags: msvcW4) | |
| 19:49 | Harmless compiler warning fixes for 'testfixture' and the miscellaneous extensions when built with the MSVC makefile. (check-in: 923fd660 user: mistachkin tags: msvcW4) | |
| 18:52 | Merge updates from trunk. (check-in: ca5f2c54 user: mistachkin tags: msvcW4) | |
| 18:52 | Get things compiling cleanly with MSVC and W4. (check-in: c8725fa5 user: mistachkin tags: msvcW4) | |
| 18:38 | Fix some harmless compiler warnings. (check-in: 2b8eecbf user: mistachkin tags: msvcW4) | |
| 18:27 | Fix comments and add another disabled warning for MSVC. (check-in: 43b6b4cc user: mistachkin tags: msvcW4) | |
| 18:02 | Work in progress on fixing harmless compiler warnings when using -W4 and MSVC. (check-in: 856dd245 user: mistachkin tags: msvcW4) | |
| 17:58 | Optimize the unicode61 tokenizer so that it handles ascii text faster. Make it the default tokenizer. Change the name of the simple tokenizer to "ascii". (check-in: f22dbcca user: dan tags: fts5) | |
| 17:56 | Add an assert() in order to calm a scan-build warning. (check-in: 11e81ac2 user: drh tags: trunk) | |
|
2015-01-10
| ||
| 20:34 | Fix some documentation issues in fts5. (check-in: 512e1bdb user: dan tags: fts5) | |
| 18:22 | Add detection of the isnan() library function to the configure script. Make the code responsive to the HAVE_ISNAN configuration option. (check-in: 46f3aba2 user: drh tags: trunk) | |
| 18:02 | Make use of the fdatasync() interface if the HAVE_FDATASYNC macro is true. (check-in: 694228e4 user: drh tags: trunk) | |
| 16:49 | Improvements to compile-time-option hygiene. Use "#if OPTION" instead of "#ifdef OPTION" in cases where that makes sense, so that -DOPTION=0 will work. Add the "Have-Not" configuration in releasetest.tcl which disables all of the "HAVE_component" compile-time options. (check-in: 9e92a5ed user: drh tags: trunk) | |
| 15:21 | Add the ability to put comments in the Config and Platform setup sections of the releasetest.tcl script. (check-in: d6f8c899 user: drh tags: trunk) | |
| 14:27 | Autoconf configure script updates: (1) remove the long-obsolete --enable-cross-thread-connections option. (2) remove the --with-hints= options. (3) Extension loading is enabled by default. (4) Check for strchrnull() (5) Update the --help text. (check-in: 5004063c user: drh tags: trunk) | |
|
2015-01-09
| ||
| 21:54 | Change the testfixture binary so that it explicitly enabled core files on a crash (on unix). Add a test case to verify that this works. (check-in: 90f422ed user: drh tags: trunk) | |
| 20:00 | Add SQLITE_ENABLE_STMT_SCANSTATUS to the Update-Delete-Limit configuration in the releasetest.tcl script. (check-in: c70d5eda user: drh tags: trunk) | |
| 19:45 | Remove an unused preprocessor macro from pcache.c. (check-in: 88a7a967 user: drh tags: trunk) | |
| 19:36 | Improvements to the sqlite3_stmt_scanstatus() documentation. No changes to code. (check-in: 9309c9bc user: drh tags: trunk) | |
| 01:27 | Fix three crash problems discovered by afl-fuzz. Ticket [a59ae93ee990a55]. (check-in: fe578863 user: drh tags: trunk) | |
| 00:38 | Add the "ascii" mode to the command-line shell. (check-in: e1518a94 user: drh tags: trunk) | |
|
2015-01-08
| ||
| 22:08 | Omit modules from the "valgrind" permutation that fork off separate processes. Also omit selectG.test because it is timing sensitive and valgrind is too slow to get the right answer. (check-in: 662932a6 user: drh tags: trunk) | |
| 20:06 | Merge recent enhancements from trunk, including test scripts enhancements and the removal of limits on the number of terms in a VALUES clause. (check-in: 5a2dec55 user: drh tags: sessions) | |
| 19:55 | Merge the testing enhancements and the unlimited VALUES enhancement from trunk. (check-in: cc780842 user: drh tags: apple-osx) | |
| 16:47 | Try to fix up the "valgrindtest" target in Makefile.in so that it avoids misuse testing that can trigger false errors. (check-in: 50b5a8af user: drh tags: trunk) | |
| 02:28 | Fix the extension tags on the "smoketest" makefile target for Windows. (check-in: 826fd311 user: drh tags: trunk) | |
| 02:15 | In releasetest.tcl: (1) Add the Failure-Detection platform. (2) Re-add the --disable-shared argument on Default that was mistakenly removed by the previous commit. (3) Remove the -ftrapv tests, as we read that -ftrapv does not work in GCC. (check-in: 1f2fb777 user: drh tags: trunk) | |
| 01:05 | In releasetest.tcl: add options --veryquick and pass-through compiler optimization settings (ex: -O0). Collect the SQLite version number from the main.test output and show it during the summary report at the end. (check-in: e7e7bc1d user: drh tags: trunk) | |
|
2015-01-07
| ||
| 19:38 | In releasetest.tcl, always use --disable-shared together with --disable-amalgamation because mingw generates a binary that crashes and cannot be debugged using gdb if you don't. (check-in: 19982439 user: drh tags: trunk) | |
| 19:33 | Add the fts5 'optimize' command. (check-in: e749be56 user: dan tags: fts5) | |
| 18:44 | In releasetest.tcl, copy certain command-line arguments (-g, -D..., etc) down into each test run. (check-in: 889864b5 user: drh tags: trunk) | |
| 18:19 | Modify the valgrind target to be consistent with regard to target suffixes. (check-in: dc4aa732 user: mistachkin tags: trunk) | |
| 18:11 | Fix threads-enabled builds on Windows when the amalgamation is not in use. (check-in: 9b92a4d2 user: mistachkin tags: trunk) | |
| 17:11 | Add the 'rebuild' and 'delete-all' commands. (check-in: 0cb2fed5 user: dan tags: fts5) | |
| 14:41 | In releasetest.tcl, change the --dryrun option to work as it does in multitest.tcl of TH3. Add the new --trace option that work like the --dryrun option used to work. Add the ability to specify additional configure-script options in the Config array, and create configurations that use --disable-shared and --disable-amalgamation for testing. (check-in: be17ef03 user: drh tags: trunk) | |
| 14:09 | Add a valgrind test to the Linux-x86_64 platform in releasetest.tcl. (check-in: 4b6df035 user: drh tags: trunk) | |
|
2015-01-06
| ||
| 21:31 | Fix a problem in the unix implementation of FCNTL_SIZE_HINT on systems that do not support posix_fallocate(). (check-in: af20eae1 user: dan tags: trunk) | |
| 19:08 | Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. (check-in: 65f0262f user: dan tags: fts5) | |
| 16:53 | Improved and more rigorous test of large VALUES clauses. (check-in: 6917d9f4 user: drh tags: trunk) | |
| 14:38 | Further fixes and test cases related to external content tables. (check-in: ce6a899b user: dan tags: fts5) | |
|
2015-01-05
| ||
| 20:41 | Tests and fixes for fts5 external content tables. (check-in: 047aaf83 user: dan tags: fts5) | |
| 20:13 | Enhance "INSERT INTO ... VALUES" so that the number of rows in the VALUES clause is not limited by SQLITE_LIMIT_COMPOUND_SELECT, and so that the stack depth is constant regardless of the number of rows in VALUES. (check-in: e1c4a359 user: drh tags: trunk) | |
| 20:04 | Avoid O(N*N) behavior with very long lists of VALUES. (Closed-Leaf check-in: ee30fb35 user: drh tags: many-VALUEs) | |
| 19:16 | Handle compound-select statements originating from VALUES clauses as a special case that does not use recursion. (check-in: 9ce9e43a user: drh tags: many-VALUEs) | |
| 16:27 | Towards getting INSERT statements to except many VALUE terms (more than the limit imposed by SQLITE_LIMIT_COMPOUND_SELECT). This check-in segfaults on a stack overflow. And it is slow. (check-in: c9d65f73 user: drh tags: many-VALUEs) | |
| 15:48 | Remove some needless recursion from compound SELECT processing. (check-in: fe677d13 user: drh tags: trunk) | |
|
2015-01-03
| ||
| 20:44 | Add support for external content tables to fts5. (check-in: 17ef5b59 user: dan tags: fts5) | |
| 18:59 | In releasetest.tcl, omit the CC=clang text from the label on Sanitize tests, so that the label fits on an 80-character line. (check-in: 23d4c07e user: drh tags: trunk) | |
|
2015-01-02
| ||
| 21:54 | Fix a harmless compiler warning. (check-in: e0de5807 user: drh tags: trunk) | |
| 20:06 | Merge updates from trunk. (Closed-Leaf check-in: ea99f4b2 user: mistachkin tags: asciiMode) | |
| 19:17 | Merge the latest changes from trunk into the apple-osx branch. (check-in: df3cdf9f user: drh tags: apple-osx) | |
| 15:55 | Add the SQLITE_CONFIG_PMASZ start-time option. (check-in: acb0d1e8 user: drh tags: trunk) | |
| 14:55 | Allow the rank column to be remapped on a per-query basis by including a term similar to "rank match 'bm25(10,2)'" in a where clause. (check-in: 1cd15a17 user: dan tags: fts5) | |
|
2015-01-01
| ||
| 23:02 | Add logic to releasetest.tcl that detects -fsanitize=undefined errors. Fix a few false-positivies that come up when running the sanitize=undefined test. (check-in: 2835e79a user: drh tags: trunk) | |
| 19:53 | Add the ability to specify an alternative compiler (clang instead of gcc) on the default Makefile. Use this in releasetest.tcl to implement an -fsanitize=undefined test. (check-in: c55c05fe user: drh tags: trunk) | |
| 19:11 | Enhance the "lemon" executable so that it ignores -f, -W, -O, and -I command-line options. This permits most of the same options that are passed to the compiler to also be harmlessly passed to lemon, and thus simplifies makefiles. (check-in: da408d12 user: drh tags: trunk) | |
| 18:54 | Fix an error in the computation of the number of hours of runtime for individual test runs in the releasetest.tcl script. (check-in: e2b0ebe2 user: drh tags: trunk) | |
| 18:03 | Merge latest trunk changes with this branch. (check-in: 4b365167 user: dan tags: fts5) | |
| 16:47 | Fix a harmless compiler warning in rtree. (check-in: 30891c6b user: drh tags: trunk) | |
| 14:13 | Fix two test cases in memsubsys1 so that they work with the mmap permutation. (check-in: 66269d0d user: drh tags: trunk) | |
| 14:06 | Fix the fkey-7.1 test so that it sorts its answer and hence always gives the same answer. (check-in: 5830c557 user: drh tags: trunk) | |
|
2014-12-31
| ||
| 20:35 | Fix to releasetest.tcl: When doing the secondary _debug runs, convert "fulltest" to just "test". (check-in: ec264bde user: drh tags: trunk) | |
| 20:25 | Adjust the memsubsys1-5.5 test case to avoid occasional false positives. (check-in: 43241318 user: drh tags: trunk) | |
| 20:19 | Fix a floating-point round-off error problem in the percentile.test module. (check-in: 456948ea user: drh tags: trunk) | |
| 19:58 | Disable the bigsort.test module on machine with less than 8GB of available RAM or machine, to avoid thrashing. (check-in: 9d4fe116 user: drh tags: trunk) | |
| 18:55 | Change threadtest3.c so that SQLITE_SCHEMA returns result in warnings not hard errors. Add the Darwin-x86_64 platform to releasetest.tcl. (check-in: b09a139c user: drh tags: trunk) | |
| 18:28 | Update the command-line parsing for threadtest3 so that tests are run in the order they are specified on the command-line. (check-in: f489bc31 user: drh tags: trunk) | |
| 18:25 | Add a missing sqlite3_close() call to threadtest3.c. (check-in: a65a44f3 user: dan tags: trunk) | |
| 18:10 | Only run walthread5 once when running all tests in threadtest3. (check-in: ca2e4a5b user: drh tags: trunk) | |
| 18:08 | Do run pragma3.test as part of the mmap permutation. As it works as of [cf48eb608a]. (check-in: 11057e26 user: dan tags: trunk) | |
| 15:14 | Change the width of output lines in releasetest.tcl from 70 to 79 characters. (check-in: a468d967 user: drh tags: trunk) | |
| 14:27 | Merge the fix to PRAGMA data_version and testing improvements from trunk. (check-in: 86e39123 user: drh tags: sessions) | |
| 14:18 | Make sure PRAGMA data_version is updated even if the cache is empty when another connection changes the database. (check-in: cf48eb60 user: drh tags: trunk) | |
| 09:52 | Do not run pragma3.test as part of the mmap permutation. (check-in: 94101011 user: dan tags: trunk) | |
|
2014-12-30
| ||
| 20:40 | Add the "mptester" tests to releasetest.tcl. (check-in: 93094a68 user: drh tags: trunk) | |
| 19:58 | Ensure that when a file is extended using FCNTL_SIZE_HINT the last page is allocated on disk, even if the file will only use part of it. (check-in: c7f84717 user: dan tags: trunk) | |
| 19:26 | Update the threadtest3 test program so that its output summary is compatible with releasetest.tcl. In threadtest3, do not record errors that contain the string "no such table" as being fatal errors, since they happen sometimes in a race condition in stress1. (check-in: 98cb56e2 user: drh tags: trunk) | |
| 18:07 | Fix problems with the "inmemory_journal" permutation. (check-in: 79693f04 user: dan tags: trunk) | |
| 14:40 | If the sorter uses mmap'd temp files, ensure all pages of the temp file have been allocated before it is accessed. Otherwise, a disk-full condition might result in a SIGBUS exception. (check-in: 77664841 user: dan tags: trunk) | |
| 13:04 | Make SQLITE_CONFIG_PCACHE_HDRSZ accurate (not an over-estimate) on 32-bit systems. (check-in: 340b3477 user: drh tags: trunk) | |
| 12:03 | Change notify2.test to check that sqlite3_blocking_step() uses CPU more efficiently than sqlite3_step(), not that it results in greater overall throughput for any specific number of threads. (check-in: d904d293 user: dan tags: trunk) | |
| 00:57 | Round all object sizes that go into computing SQLITE_CONFIG_PCACHE_HDRSZ up to a multiple of 8 bytes. (check-in: b28ce75f user: drh tags: trunk) | |
|
2014-12-29
| ||
| 19:54 | Fix the --dryrun option in releasetest.tcl. (check-in: 0f9e5496 user: drh tags: trunk) | |
| 12:02 | Fix some recently added tests so that they work with SQLITE_DEFAULT_AUTOVACUUM=1. (check-in: ef0626ab user: dan tags: trunk) | |
| 11:50 | Reinstate an assert() by adding an "|| CORRUPT_DB" term. (check-in: 95ce2034 user: drh tags: trunk) | |
| 02:55 | Fix the "checksymbols" target in Makefile.in so that it actually works. Enhance the releasetest.tcl script to count the total number of tests run over all configurations. (check-in: 4eda1c74 user: drh tags: trunk) | |
|
2014-12-28
| ||
| 22:10 | Fix WITHOUT ROWID tables so that they correctly deal with PRIMARY KEYs that contain redundant columns. (check-in: 0dfef675 user: drh tags: trunk) | |
|
2014-12-25
| ||
| 12:19 | Update the SQLITE_CONFIG_PAGECACHE documentation so that the maximum page size is correctly stated to be 65536. (check-in: 3286424b user: drh tags: trunk) | |
|
2014-12-24
| ||
| 23:35 | Fix the error counter in releasetest.tcl. And report the total time in HH:MM:SS instead of just seconds. (check-in: 6396f804 user: drh tags: trunk) | |
| 18:11 | Fix a failing assert() in balance_nonroot(). (check-in: e2e32314 user: dan tags: trunk) | |
| 17:17 | When building the amalgamation with SQLITE_ENABLE_IOTRACE defined, do not mark symbol sqlite3IoTrace as static. (check-in: 5b7ca013 user: dan tags: trunk) | |
|
2014-12-23
| ||
| 21:17 | Merge the new and improved releasetest.tcl script into trunk. Add a "make releasetest" target to the autoconf makefile. (check-in: 1deb00ec user: drh tags: trunk) | |
| 21:10 | Remove 'threadtest' as a target on Windows, due to lack of pthreads. Also, change 'fulltest' to 'fulltestonly'. (Closed-Leaf check-in: a010c404 user: mistachkin tags: releasetest-refactor) | |
| 21:03 | Fix typo in library object file name. (check-in: f49566a7 user: mistachkin tags: releasetest-refactor) | |
| 20:42 | Permit sqlite3_shutdown() to be called with OMIT_WSD enabled and without having called sqlite3_initialize() first. (check-in: 3f7dbdb5 user: mistachkin tags: trunk) | |
| 20:41 | In the releasetest.tcl script, show the test target for each configuration that is run. And show the time in HH:MM:SS. (check-in: 2295e9e0 user: drh tags: releasetest-refactor) | |
| 20:31 | Add the threadtest target to Makefile.in. Add --enable-load-extension to the configure issued by releasetest.tcl. (check-in: cb128067 user: drh tags: releasetest-refactor) | |
| 20:22 | Draft of changes necessary to make releasetest work on Windows via MinGW. (check-in: af166c5c user: mistachkin tags: releasetest-refactor) | |
| 20:05 | Fix a potential segfault following OOM error in the test harness. The SQLite core itself is not at fault. (check-in: 1bb26695 user: drh tags: trunk) | |
| 19:52 | Add the "checksymbols" target to Makefile.in (check-in: 5bd73dba user: drh tags: releasetest-refactor) | |
| 19:40 | Rework the test/releasetest.tcl script so that it uses the autoconf makefile instead of the test/releasetest.mk makefile. Also add options like --dryrun and --buildonly. Omit the --makefile option and replace it with --srcdir with the default computed relative to the releasetest.tcl script itself. (check-in: 7c85e831 user: drh tags: releasetest-refactor) | |
|
2014-12-22
| ||
| 22:02 | Fix a typo in an evidence mark on a test script. No changes to code. (check-in: a08b0c75 user: drh tags: trunk) | |
| 18:48 | Merge the PRAGMA data_version redefinition and other fixes from trunk. (check-in: 315243e4 user: drh tags: sessions) | |
| 18:41 | Redefine the way PRAGMA data_version works: It continues to change when any other connection commits, including shared-cache connections, but does not change if the local connection commits. (check-in: 7a97826f user: drh tags: trunk) | |
|
2014-12-21
| ||
| 11:56 | Fixes to the README.md file. No changes to code. (check-in: ef4b734d user: drh tags: trunk) | |
|
2014-12-20
| ||
| 22:21 | Support manually disabling overlapped file I/O for Windows sub-platforms other than Windows CE. (check-in: b9330b88 user: mistachkin tags: trunk) | |
| 21:14 | Minor fixes and enhancements to the SQLITE_ENABLE_API_ARMOR functionality. (check-in: cb3e4219 user: mistachkin tags: trunk) | |
| 14:58 | Merge the PRAGMA data_version command and the enhancements to FK query planning from trunk into the sessions branch. (check-in: d4f82af0 user: drh tags: sessions) | |
| 14:50 | Add the "PRAGMA data_version" command for checking to see if a database has been modified. (check-in: de50f25c user: drh tags: trunk) | |
| 14:34 | Update the PRAGMA data_version command so that it reponse to changes made by a shared-cache database connection, and also to changes made by the same database connection. Add test cases to verify the new behavior. (Closed-Leaf check-in: 44ee5383 user: drh tags: data_version_pragma) | |
|
2014-12-19
| ||
| 22:20 | Merge updates from trunk. (check-in: 555fb71f user: mistachkin tags: asciiMode) | |
| 20:27 | Adding test cases for the "PRAGMA data_version" command. (check-in: c5fb7d6a user: drh tags: data_version_pragma) | |
| 19:28 | Experimental "PRAGMA data_version" command for detecting when another process has changed the database file. (check-in: 43db1f44 user: drh tags: data_version_pragma) | |
| 18:49 | Simplify the implementation of the "header-value" pragmas (schema_version, user_version, freelist_count, and application_id) by making them more table-driven. (check-in: da27a09d user: drh tags: trunk) | |
|
2014-12-17
| ||
| 15:03 | Experimental opimizations to speed up FK constraint CASCADE and SET NULL action processing. (check-in: 8c5dd6cc user: dan tags: trunk) | |
| 14:38 | Fix some comments in fkey.c. Add tests to fkey8.test. (Closed-Leaf check-in: 210cb2a6 user: dan tags: experimental-fk-actions) | |
|
2014-12-16
| ||
| 20:13 | Experimental opimizations to speed up FK constraint CASCADE and SET NULL action processing. Requires further testing. (check-in: 35a20a5f user: dan tags: experimental-fk-actions) | |
| 12:46 | Fix the e_walauto.test script so that it works on windows. (check-in: 7d092ebb user: drh tags: trunk) | |
| 01:05 | Merge threading fixes from trunk into the sessions branch. (check-in: 9817a286 user: drh tags: sessions) | |
| 00:29 | Merge latest fixes and enhancements from trunk into apple-osx. (check-in: 2c1d8dda user: drh tags: apple-osx) | |
| 00:20 | Enhanced "stress2" testing in the threadtest3.c test program. (check-in: ae43539e user: drh tags: trunk) | |
| 00:08 | Make sure the sqlite3BtreeCount() routine does not leave index cursors in an inconsistent state, as doing so might result in an assertion fault inside of sqlite3BtreeKey() called from saveAllCursors() if content is deleted out from under the statement that issued the sqlite3BtreeCount() call. (check-in: 5b1b6970 user: drh tags: trunk) | |
|
2014-12-15
| ||
| 20:49 | Changes to threadtest3 so that "stress2" is more similar to the SDS stress test. (Closed-Leaf check-in: 5648af96 user: dan tags: threadtest3) | |
| 16:27 | Add new test file e_walauto.test. (check-in: 62ef4514 user: dan tags: trunk) | |
| 08:46 | Fix errors in threadtest3 tests caused by earlier tests neglecting to close database handles. (check-in: 1d44f1b1 user: dan tags: trunk) | |
|
2014-12-13
| ||
| 17:41 | Further enhancements to threadtest3 stress tests. (check-in: ba772cff user: dan tags: trunk) | |
|
2014-12-12
| ||
| 23:17 | Add extra tests to threadtest4.c. Fix a benign data race accessing the text encoding using ENC(db). (check-in: d7bb7ea4 user: drh tags: trunk) | |
| 16:39 | Add extra tests to threadtest3. (check-in: f6bf86f9 user: dan tags: trunk) | |
| 01:27 | Add new tests to the threadtest4.c program. Fix a long-standing data race in WAL mode for shared-cache. (check-in: d8d3e6d0 user: drh tags: trunk) | |
| 00:52 | Remove the KeyInfo cache (for now - perhaps we will add it back in later - or maybe not since it provides negligible benefit but adds a lot of complexity and thread-safety risk). Add a mutex to ATTACH to deal with a data race. (check-in: 03c443ea user: drh tags: trunk) | |
| 00:40 | Make sure the Btree mutex is held when setting the locking mode and the secure delete flag when attaching a shared-cache database. (Closed-Leaf check-in: 6bef7ede user: drh tags: threadtest4) | |
| 00:26 | Merge the cell overflow page number cache thread race fix from trunk. (check-in: cefad47e user: drh tags: threadtest4) | |
| 00:20 | Fix a bug in the threadtest4.c program. Remove the keyinfo cache as it provides minimal performance improvements, and then only at SQL preparation time, not at runtime, and it has problems with data races in shared-cache mode. We might later add the keyinfo cache back but only enable it when shared-cache mode is off. (check-in: b7489f94 user: drh tags: threadtest4) | |
|
2014-12-11
| ||
| 19:29 | Add the threadtest4.c test program. Not yet working. (check-in: ec3a7446 user: drh tags: threadtest4) | |
| 16:38 | Fix a race condition to do with very large index keys in shared-cache mode. (check-in: fc157dd7 user: dan tags: trunk) | |
| 15:27 | Fix a typo in the documentation for sqlite3_threadsafe(). (check-in: 258e747b user: drh tags: trunk) | |
| 04:49 | Update a comment. (check-in: e0e102a0 user: mistachkin tags: asciiMode) | |
| 03:29 | Rename a structure member to improve code clarity. (check-in: d48eda16 user: mistachkin tags: asciiMode) | |
| 03:25 | Remove an unused structure member. (check-in: d8404340 user: mistachkin tags: asciiMode) | |
| 03:20 | Further simplify shell mode changes. (check-in: cf9c6e7e user: mistachkin tags: asciiMode) | |
| 03:12 | Simplify and cleanup the implementation of the new ASCII mode for the shell. (check-in: 66a28f7a user: mistachkin tags: asciiMode) | |
| 02:28 | Merge updates from trunk. (check-in: 5b5d3e4d user: mistachkin tags: asciiMode) | |
|
2014-12-10
| ||
| 20:57 | Fix a typo causing a test error in e_walhook.test. (check-in: d9f916ba user: dan tags: trunk) | |
| 20:29 | Add new test file e_walhook.test. (check-in: 2eb6d3e4 user: dan tags: trunk) | |
| 17:34 | Revise mutex handling by the sqlite3_win32_reset_heap() function. (check-in: eacb3b7b user: mistachkin tags: trunk) | |
| 04:58 | Fix typos in the documentation for sqlite3_table_column_metadata(). No changes to code. (check-in: 3528f8dd user: drh tags: trunk) | |
|
2014-12-09
| ||
| 22:24 | Fix the sqlite3_table_column_metadata() routine so that it gives the correct answer for the "rowid" column in a WITHOUT ROWID table. Enhance it so that it can be used to check for the existence of a table by setting the column name parameter to NULL. The routine is now included in the build by default, even without the SQLITE_ENABLE_COLUMN_METADATA compile-time option. (check-in: cf9be419 user: drh tags: trunk) | |
| 20:13 | Add extra tests to e_walckpt.test. (check-in: 84f95810 user: dan tags: trunk) | |
| 19:16 | Lower the default SQLITE_SORTER_PMASZ value back to 10, where it has been for the past couple of releases. Applications that need a larger value can set one. (check-in: 1ba8911c user: drh tags: trunk) | |
| 19:07 | Make the sqlite3_table_column_metadata() interface available by default and without requiring the SQLITE_ENABLE_COLUMN_METADATA compile-time option. Other sqlite3_column_* interfaces that have a run-time penalty even if they are unused still require the SQLITE_ENABLE_COLUMN_METADATA option at compile-time. (check-in: 4f7549ff user: drh tags: trunk) | |
| 15:12 | Add the SQLITE_REVERSE_UNORDERED_SELECTS compile-time option that causes the "PRAGMA reverse_unordered_selects" setting to be on by default. (check-in: 75a803e6 user: drh tags: trunk) | |
| 15:01 | Increase the default PMA size from 10 to 250 pages and provide the SQLITE_SORTER_PMASZ compile-time option to change this default. Add needed mutex call when clearing the KeyInfo cache in shared-cache mode. (check-in: 6e2da589 user: drh tags: apple-osx) | |
| 14:54 | Merge the KeyInfo cache mutex fix from trunk. (check-in: f0940c73 user: drh tags: sessions) | |
| 14:42 | Increase the default minimum PMA size for multi-threaded sorting from 10x the page size to 250x the page size. Provide the SQLITE_SORTER_PMASZ compile-time option to change this default. (check-in: b05340fe user: drh tags: trunk) | |
| 04:26 | Fix harmless compiler warning. (check-in: e97b7a8b user: mistachkin tags: trunk) | |
|
2014-12-08
| ||
| 20:29 | Add extra tests to e_walckpt.test. (check-in: d6832aa2 user: dan tags: trunk) | |
| 20:20 | Add missing mutex calls around a call to sqlite3SchemaGet() within sqlite3_open(). (check-in: 45415899 user: dan tags: trunk) | |
| 18:08 | Add a missing mutex around calls to clear the KeyInfo cache when closing a database connection. (check-in: 7047ce32 user: drh tags: trunk) | |
| 07:50 | Update this branch with latest trunk changes. (check-in: 69a312ad user: dan tags: ota-update) | |
| 07:28 | Update comments in sqlite3ota.h to remove the "must have PRIMARY KEY" restriction. (check-in: 088a41eb user: dan tags: ota-update) | |
| 07:22 | Extra tests for the ota_rowid column. (check-in: 46069393 user: dan tags: ota-update) | |
|
2014-12-06
| ||
| 19:30 | Allow the ota extension to write to tables with no PRIMARY KEY declaration. (check-in: ba59a7e2 user: dan tags: ota-update) | |
| 14:56 | Avoid accessing a single uninitialized byte when moving a rare 3-byte cell from an internal page to a leaf. This was not actually causing a problem, just a valgrind warning. (check-in: 6aeece19 user: dan tags: trunk) | |
| 02:05 | Fix a (harmless) uninitialized variable reference in b-tree balancing for auto-vacuumed tables with overflow pages. (check-in: dd1dd445 user: drh tags: trunk) | |
|
2014-12-05
| ||
| 21:18 | Avoid a potential NULL pointer deference in the sqlite3_stmt_scanstatus() logic. (check-in: 42d44adc user: drh tags: trunk) | |
| 21:04 | Fix a buffer overread that might occur in analyze.c if SQLITE_ENABLE_STAT4 was defined. (check-in: c1ae1268 user: dan tags: trunk) | |
| 20:46 | Add new test file e_walckpt.test. Still some tests to come. (check-in: e4db3db3 user: dan tags: trunk) | |
| 20:16 | Merge the shared-cache KeyInfo fix from trunk. (check-in: 8a9b43f9 user: drh tags: apple-osx) | |
| 20:05 | Merge the fix for the shared-cache KeyInfo cache bug from trunk. (check-in: 5a73da6a user: drh tags: sessions) | |
| 19:50 | Make sure the WhereTerm objects are fully zeroed when they are allocated. (check-in: fdb66733 user: drh tags: trunk) | |
| 15:31 | The KeyInfo cache must be cleared before closing the btree, not after. Revised fix for ticket [e4a18565a36884b00edf]. (check-in: 7ed3346e user: drh tags: trunk) | |
| 14:44 | When closing a (shared-cache) database connection, be sure to clear out all KeyInfo objects cached on Index objects. Fix for ticket [e4a18565a36884b00edf]. (check-in: adca7688 user: drh tags: trunk) | |
| 14:36 | Add code to check the validity of CollSeq objects during runtime. This code was not able to detect anomalies such as came up as a result of ticket [e4a18565a36884b00edf66541f38c693827968ab] so it is put into a branch for historical reference, with the intent of leaving it out of trunk. (Closed-Leaf check-in: 68b23c3d user: drh tags: collseq-checking) | |
| 14:34 | Improved comment on the sharedB.test test script. (Closed-Leaf check-in: 71f589e3 user: drh tags: fix-stale-keyinfo-cache) | |
| 14:07 | Test case demonstrating the problem described by ticket [e4a18565a36884b00edf]. (check-in: ffea3e90 user: drh tags: fix-stale-keyinfo-cache) | |
| 05:38 | When closing a (shared-cache) database connection, be sure to clear out all KeyInfo objects cached on Index objects. Proposed fix for ticket [e4a18565a36884b00edf]. (check-in: 651ed97d user: drh tags: fix-stale-keyinfo-cache) | |
| 00:49 | Import compiler warning and autoconf makefile fixes from trunk. (check-in: 5437e053 user: drh tags: apple-osx) | |
| 00:41 | Import from trunk the fix the "test" target on the autoconf and MSVC makefiles and some minor compiler warning fixes. (check-in: c9f20eb2 user: drh tags: sessions) | |
| 00:32 | Fix compiler warnings. (check-in: e9955c0e user: drh tags: trunk) | |
| 00:17 | Fix the autoconf and MSVC makefiles, which have been broken for nearly a month. :-( (check-in: 520c2b83 user: drh tags: trunk) | |
|
2014-12-04
| ||
| 23:42 | Import from trunk support for SQLITE_CHECKPOINT_TRUNCATE and fixes for a couple of obscure bugs. (check-in: 463ad971 user: drh tags: apple-osx) | |
| 23:35 | Incorporate the SQLITE_CHECKPOINT_TRUNCATE enhancement and a couple of obscure bug fixes from trunk. (check-in: 34ffa3b3 user: drh tags: sessions) | |
| 21:54 | Make sure that a DISTINCT query with an ORDER BY works correctly even if it uses a descending index. Fix for ticket [c5ea805691bfc4204b1cb9e]. (check-in: 0d3aef97 user: drh tags: trunk) | |
| 20:24 | Performance enhancement for single-table queries with many OR-connected WHERE clause terms and multiple indexes with the same left-most columns. (check-in: 1461d543 user: drh tags: trunk) | |
| 16:27 | If a table is the right operand of a LEFT JOIN, then any column of that table can be NULL even if that column has a NOT NULL constraint. Fix for ticket [6f2222d550f5b0ee7ed]. (check-in: 6f6fcbe4 user: drh tags: trunk) | |
| 15:02 | Clarification of the meaning of the second parameter to the busy-handler callback. No changes to code. (check-in: 1e2bc484 user: drh tags: trunk) | |
| 14:01 | Fix comment typos reported on the mailing list. No changes to code. (check-in: 93a71c9f user: drh tags: trunk) | |
| 04:50 | Add an implementation mark and fix a comment describing the OP_Checkpoint opcode. (check-in: 7475b90c user: drh tags: trunk) | |
|
2014-12-03
| ||
| 19:25 | Add evidence marks and assert()s used as evidence for checkpoint requirements. (check-in: b2da8afc user: drh tags: trunk) | |
| 19:08 | Fix over-length comment lines in sqlite.h.in. No changes to code. (check-in: cbd357fd user: drh tags: trunk) | |
| 18:32 | Simplify the sqlite3_wal_checkpoint() documentation. Add some source code evidence marks. (check-in: 026c44ff user: drh tags: trunk) | |
| 16:30 | Futher tweaks to the sqlite3_wal_checkpoint_v2() documentation. (check-in: 7d284d04 user: drh tags: trunk) | |
| 15:50 | Updates to the documentation for sqlite3_wal_checkpoint_v2() and related interfaces, including adding many requirements marks. (check-in: 1e212d98 user: drh tags: trunk) | |
|
2014-12-02
| ||
| 20:51 | Add support for SQLITE_CHECKPOINT_TRUNCATE. (check-in: edda2b9e user: drh tags: trunk) | |
| 19:35 | When attempting to restart a wal file, make any required calls to sqlite3_randomness() before waiting on or checking for wal file readers. This restores the behaviour exhibited by the trunk. (Closed-Leaf check-in: 6ee08769 user: dan tags: checkpoint-truncate) | |
| 19:04 | Add the SQLITE_CHECKPOINT_TRUNCATE option. (check-in: 8e20a434 user: dan tags: checkpoint-truncate) | |
| 16:38 | Merge all recent enhancements and bug fixes from trunk into the apple-osx branch. (check-in: 43c4ba26 user: drh tags: apple-osx) | |
| 16:31 | Merge all recent fixes and enhancements from trunk into sessions. (check-in: 2617d937 user: drh tags: sessions) | |
| 16:16 | Convert two unreachable branches into assert() statements. (check-in: 61b31e77 user: drh tags: trunk) | |
| 13:46 | Work around overzealous NULL pointer checking in memcpy() and memset() for some systems. (check-in: 0d04f380 user: drh tags: trunk) | |
|
2014-11-28
| ||
| 13:35 | Remove the ill-designed "-end" option from the command-line shell. Instead, allow multiple SQL or dot-commands as command-line arguments. Any -cmd commands are processed first, followed by other command-line arguments, for backwards compatibility. (check-in: 24fa2e98 user: drh tags: trunk) | |
| 11:54 | Add the -end option to the command-line shell, which forces it to exit after reading prior command-line options (presumably including one or more -cmd options) and without reading standard input. (check-in: b59397b1 user: drh tags: trunk) | |
|
2014-11-27
| ||
| 18:09 | Update ota so that the hidden columns of virtual tables may be written. (check-in: ccee9996 user: dan tags: ota-update) | |
| 11:36 | Fix a buffer overread during compilation of CREATE VIRTUAL TABLE statements that featured an explicit database name but no virtual table arguments. For example, "CREATE VIRTUAL TABLE main.ft USING fts4". (check-in: f095cde5 user: dan tags: trunk) | |
| 04:23 | More test cases for the balancer. (check-in: 358ea818 user: drh tags: trunk) | |
| 03:46 | Fix a problem in the new b-tree balancer that was causing corruption of the fragmentation count. (check-in: f242394e user: drh tags: trunk) | |
|
2014-11-25
| ||
| 18:59 | Fix an integer overflow bug in vdbesort.c. (check-in: 62382719 user: dan tags: trunk) | |
|
2014-11-22
| ||
| 21:37 | Always reinitialized the Index.bUnordered and Index.noSkipscan flags before rereading the sqlite_stat1 table, even if SQLITE_ENABLE_STAT4 is defined. (check-in: 1e1221fc user: drh tags: trunk) | |
| 19:52 | Fix an error in the comments from the previous check-in. (check-in: 9660ce54 user: drh tags: trunk) | |
| 18:50 | Deploy heuristics (well-commented) to better estimate how much unindexed terms in the WHERE clause filter the number of output rows from a single table. (check-in: 22165994 user: drh tags: trunk) | |
| 16:14 | Unintentional edits mistakenly checked in. Was: Remove an obsolete and incorrect comment from the whereLoopOutputAdjust() routine in the query planner. No changes to working code. (Closed-Leaf check-in: e1f893c6 user: drh tags: mistake) | |
| 12:22 | Remove a redundant test case (probably a copy/paste error). Add an assert() to where.c to ensure that automatic indexes do not have there output row counts adjusted downward by supplementary constraints. (check-in: eea47933 user: drh tags: trunk) | |
| 09:09 | Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. (check-in: 600cefdd user: dan tags: ota-update) | |
|
2014-11-21
| ||
| 14:37 | Merge latest trunk changes with this branch. (check-in: 7ef44c5b user: dan tags: ota-update) | |
|
2014-11-20
| ||
| 23:21 | Fix a typo in a requirements mark on the abs() SQL function. (check-in: b1e6c02f user: drh tags: trunk) | |
| 23:11 | Fix a benign test error on PRAGMA collation_list introduced by a recent checkin. (check-in: 332cc959 user: drh tags: trunk) | |
| 23:03 | Updates to requirements tags on the mutex documentation. (check-in: fcf8b7e4 user: drh tags: trunk) | |
| 19:22 | Add requirements marks on the built-in collating functions. (check-in: 4b608b62 user: drh tags: trunk) | |
| 15:30 | Ensure that when the number of cells on a page drops to zero that the freelist and fragment counter are both cleared. Also add evidence marks corresponding to file-format documentation. (check-in: ef9fbc08 user: drh tags: trunk) | |
| 02:58 | Fix the encoding of some integers to use the minimum amount of space: -128, -32768, -8388608, -217483648, and -140737488355328. (check-in: 2d7c8da5 user: drh tags: trunk) | |
| 02:18 | Add some requirements marks to the record formatting logic. Comment changes only - the code is unaltered. (check-in: 9a9627e1 user: drh tags: trunk) | |
|
2014-11-19
| ||
| 16:36 | Add new requirements marks associated with the file format documentation. No changes to code. (check-in: 6d00bcca user: drh tags: trunk) | |
| 14:31 | Completely remove an assert() that had previously been commented out. (check-in: 89b3c1c4 user: drh tags: trunk) | |
| 14:05 | Add an ALWAYS on an always-true branch in wal.c. Fix the ANALYZE command so that it resets the "unordered" and "noskipscan" flags on indices when reloading the sqlite_stat1 table. (check-in: 9ed97a85 user: drh tags: trunk) | |
|
2014-11-18
| ||
| 21:54 | Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an index for being used with the skip-scan algorithm. (check-in: 4461bf04 user: drh tags: trunk) | |
| 21:45 | Allow an automatic index to be used if the only uses of declared indexes for the same loop use the skip-scan algorithm. (check-in: c52f7971 user: drh tags: trunk) | |
| 21:27 | Merge recent trunk enhancements. (check-in: ccb601f6 user: drh tags: apple-osx) | |
| 21:20 | Merge recent trunk enhancements, including the read-after-ROLLBACK change and the addition of sqlite3_stmt_scanstatus() support, as well as various minor bug fixes. (check-in: f09055f3 user: drh tags: sessions) | |
| 20:49 | Merge in all the other ROLLBACK fixes from the branch-3.8.7 branch. I don't know why I was doing them one-by-one. (check-in: 296b0c73 user: drh tags: trunk) | |
| 20:22 | Fix a bug in the sqlite3TripAllCursors() routine that prevents it from reporting errors. It is unknown at this time whether or not this omission can result in any incorrect result in an actual query. (check-in: 2896f264 user: drh tags: trunk) | |
| 20:16 | Update a couple of test cases to account for the fact that ROLLBACK does not always abort all running SELECT statements. (check-in: abccda76 user: drh tags: trunk) | |
|
2014-11-17
| ||
| 19:42 | Avoid calling sqlite3BtreeKeysize() on a b-tree cursor in SKIPNEXT or SKIPPREV state. (check-in: 54e7d3fc user: dan tags: trunk) | |
|
2014-11-15
| ||
| 19:08 | Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an index for being used with the skip-scan algorithm. (Closed-Leaf check-in: 00fe0950 user: drh tags: noskipscan-token) | |
|
2014-11-14
| ||
| 19:34 | Consider using an automatic-index for a scan even if there exists a possible skip-scan that uses one or more "=" operators. (Closed-Leaf check-in: 93642a65 user: dan tags: experimental-autoindex-fix) | |
| 15:28 | Do not automatically remove the DISTINCT keyword from "a IN (SELECT DISTINCT ...)" expressions. Fix for [db87229497]. (check-in: 55e453aa user: dan tags: trunk) | |
|
2014-11-13
| ||
| 14:30 | Modify the documentation for sqlite3_backup_init() to indicate that it will fail if there is already a read or read-write transaction open on the destination database. (check-in: ef03a203 user: dan tags: trunk) | |
| 14:18 | Have calls to sqlite3_backup_init() fail if there is already a read or read-write transaction open on the destination database. (check-in: 169b5505 user: dan tags: trunk) | |
|
2014-11-12
| ||
| 17:45 | Add further tests for rollback operations in the presence of ongoing selects. (check-in: eaf3aae0 user: dan tags: trunk) | |
| 14:56 | When a transaction or savepoint rollback occurs, save the positions of all open read-cursors so that they can be restored following the rollback operation. (check-in: dd03a280 user: dan tags: trunk) | |
|
2014-11-11
| ||
| 19:07 | Remove some calls to the 'breakpoint' test command. (check-in: 1412fcc4 user: mistachkin tags: trunk) | |
| 16:11 | Add tests for sqlite3_blob_bytes(). (check-in: a066a383 user: dan tags: trunk) | |
| 14:59 | Permit read operations to continue after a ROLLBACK as long as the schema does not change. (check-in: b5df5ac0 user: drh tags: trunk) | |
| 12:20 | Add new test file e_blobclose.test, containing tests for sqlite3_blob_close(). (check-in: 5a1eac24 user: dan tags: trunk) | |
| 01:33 | Experimental changes that permit read operations to continue after a ROLLBACK, as long as the schema is unchanged. (Closed-Leaf check-in: fa6e6a9a user: drh tags: read-after-rollback) | |
|
2014-11-10
| ||
| 19:16 | New test cases for deleting content out from under a SELECT statement. (check-in: 8289c3e9 user: drh tags: trunk) | |
| 17:53 | Add test file e_blobwrite.test, containing tests for the sqlite3_blob_write() interface. (check-in: 1df77e5f user: dan tags: trunk) | |
| 16:49 | Add the eval() SQL function extension in ext/misc/eval.c. (check-in: 27cf665b user: drh tags: trunk) | |
| 14:42 | Shorten over-length source code lines in shell.c. (check-in: 7f3819f6 user: drh tags: trunk) | |
|
2014-11-07
| ||
| 14:41 | Add new test file e_blobopen.test, containing tests for sqlite3_blob_open(). (check-in: ecbccd0e user: dan tags: trunk) | |
| 14:37 | Fix another harmless comment typo. (check-in: b45bc80b user: drh tags: trunk) | |
| 13:52 | In the ".scanstats on" output from the shell, round the estRows value to the nearest integer, rather than rounding toward zero. (check-in: 57005085 user: drh tags: trunk) | |
| 13:24 | Fix harmless typos in comments. (check-in: 94c564da user: drh tags: trunk) | |
| 11:39 | Fix typo in sqlite3.h reported on the mailing list. (check-in: 40270321 user: drh tags: trunk) | |
| 01:43 | Update documentation on sqlite3_config() and add corresponding evidence marks. (check-in: 360c8ca1 user: drh tags: trunk) | |
|
2014-11-06
| ||
| 14:43 | Added SQLITE_SCANSTAT_SELECTID. Change the value returned by SQLITE_SCANSTAT_EST from sqlite3_int64 to double. Enhanced the formatting and display of scan statistics using the ".scanstats on" command in the shell. (check-in: 20c7614a user: drh tags: trunk) | |
| 12:46 | Further improvements to the ".scanstats on" display in the shell. Be sure to show the results of all subqueries even if there are gaps in the SELECTID values. Add ".scanstats" to the ".help" output. (Closed-Leaf check-in: ee922682 user: drh tags: scanstatus) | |
| 12:17 | On the ".scanstats on" output in the shell, initialize the estimated count for the first loop of each subquery to the actual loop count. (check-in: d1c51c84 user: drh tags: scanstatus) | |
| 12:08 | Changes the formatting of ".scanstats on" in the shell so that the stats for subqueries are grouped together and occur after the main query. (check-in: eacbbd88 user: drh tags: scanstatus) | |
| 04:42 | Add the SQLITE_SCANSTAT_SELECTID metric. Use it to improve the ".stmtscan on" output in the shell. (check-in: 64ad5761 user: drh tags: scanstatus) | |
| 03:55 | Change the SQLITE_SCANSTAT_EST parameter so that it returns a double for the estimated number of output rows per loop, rather than a 64-bit integer. Revise the output format for the ".scanstats on" in the shell to make use of this new capability. (check-in: f9684000 user: drh tags: scanstatus) | |
|
2014-11-05
| ||
| 21:34 | Fixes to the Windows VFS to allow memory mapped files to work without WAL support. (check-in: 272fddc1 user: drh tags: trunk) | |
| 21:21 | Fix harmless compiler warnings in the new balance_nonroot() routine. (check-in: 83a1e5db user: drh tags: trunk) | |
| 19:26 | Change the query planner to do a better job of estimating the number rows selected by a BETWEEN operator using STAT4 when both upper and lower bounds are contained within the same sample. (check-in: 2d36be5d user: drh tags: trunk) | |
| 15:57 | Make sure that NULL results from OP_Column are fully and completely NULL and do not have the MEM_Ephem bit set. Fix for ticket [094d39a4c95ee4]. (check-in: 42705fd7 user: drh tags: trunk) | |
| 14:19 | Add a test case to check that the previous commit is effective. (check-in: 948d6e5d user: dan tags: trunk) | |
| 13:13 | Enhance whereLoopCheaperProperSubset(X,Y) so that it does not report true if X uses skip-scan less than Y, since in that case X might deserve to be cheaper even if it is a proper subset. (check-in: c106b755 user: drh tags: trunk) | |
| 09:07 | Add the ".scanstats on" command to the shell tool. Executing this command causes the shell tool to print values from sqlite3_stmt_scanstatus() after each query is run. (check-in: 7974c0ed user: dan tags: trunk) | |
|
2014-11-04
| ||
| 21:38 | Improved output formatting for the showstat4 tool. (check-in: 7df82c46 user: drh tags: trunk) | |
| 19:52 | Skip tests that require WAL mode when it is not enabled. (Closed-Leaf check-in: 6fc4ead2 user: mistachkin tags: winMmapNoWal) | |
| 19:37 | For the Win32 VFS, allow memory mapped files to work when compiled without WAL support. (check-in: 1fc7e2f3 user: mistachkin tags: winMmapNoWal) | |
| 17:23 | Add various requirements evidence marks for sqlite3_config() options. (check-in: d423349d user: drh tags: trunk) | |
| 14:22 | Change the definition of SQLITE_CONFIG_SCRATCH so that at most one scratch buffer is used per thread. Use the generic heap memory allocator for the WalIterator object when running a checkpoint. (check-in: 391c9b85 user: drh tags: trunk) | |
| 13:41 | Improved documentation and addition of source-code evidence marks for the sqlite3_config() interface. (check-in: 681031a4 user: drh tags: trunk) | |
| 12:11 | Add the SQLITE_CONFIG_PCACHE_HDRSZ option for sqlite3_config(). (check-in: 6eb03e62 user: drh tags: trunk) | |
|
2014-11-03
| ||
| 18:03 | Updates to the sqlite3_stmt_scanstatus() documentation. No changes to code. (check-in: d97c324e user: drh tags: trunk) | |
| 16:56 | Add the experimental sqlite3_stmt_scanstatus() API. For comparing the number of rows actually visited by a loop with the estimate used by the query planner. (check-in: ab3b0fc5 user: dan tags: trunk) | |
| 16:39 | Fix a typo preventing this from building with SQLITE_ENABLE_STMT_SCANSTATUS defined. (Closed-Leaf check-in: 4c5714ab user: dan tags: scanstatus) | |
| 16:35 | Refactor the interface to make it more easily extensible. (check-in: 7955342d user: drh tags: scanstatus) | |
| 15:33 | Add further tests. Fixes so that compilation without ENABLE_STMT_SCANSTATUS works. (check-in: a2303c71 user: dan tags: scanstatus) | |
| 11:25 | Remove unused variable from struct WhereInfo. Add some explanatory comments to new code. (check-in: f5313e0c user: dan tags: scanstatus) | |