Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file test/lock.test version db74fdf5
|
2017-07-21
| ||
| 03:09 | Add new interfaces sqlite3_result_pointer(), and sqlite3_value_pointer() and use them to transfer the eponymous FTS3 column pointer to the snippet() and offsets() routines. This changes is inspired by check-in [72de49f2] but is new implementation, not a cherry-pick. (Leaf check-in: f0f49224 user: drh tags: branch-3.7.11) | |
|
2015-05-21
| ||
| 02:24 | Silently ignore any attempt to add a prefix index for prefixes zero bytes in size to an fts3/4 table. Or any prefix index size so large that it overflows a 32-bit signed integer. Cherrypick [ad4b19d2ac0889a] (check-in: 000197cc user: drh tags: branch-3.7.11) | |
| 02:20 | Ensure that tables names are dequoted exactly once by the trigger logic. Cherrypick [59e92bd9521f1e8] and [9d887b92f8086961e]. (check-in: 9e3f64a4 user: drh tags: branch-3.7.11) | |
| 02:07 | When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c] with additional changes. (check-in: 09784f37 user: drh tags: branch-3.7.11) | |
| 01:04 | Do not allow virtual table constructors to be called recursively. Cherrypick [0a72726da21581ab] (check-in: 0f0694e4 user: drh tags: branch-3.7.11) | |
| 00:50 | Add the ".open" command to the command-line shell. Cherrypick from [21eccb919441]. (check-in: a71e2a72 user: drh tags: branch-3.7.11) | |
|
2014-10-02
| ||
| 09:27 | Fix a segfault that could occur if an 'optimize' command was issued on an FTS table that contained at least one row but zero terms. (Leaf check-in: b21746ac user: dan tags: branch-3.7.14) | |
|
2014-06-17
| ||
| 18:43 | Experimental changes to use GetFileInformationByHandle instead of GetFileSize in the Win32 VFS. (Closed-Leaf check-in: d22c8142 user: mistachkin tags: filesize-debug) | |
|
2014-04-24
| ||
| 13:20 | Add sqlite3_log() diagnostic messages for a specific type of corruption where the file size is reported to be too small relative to the size in the header. This branch is intended to help debug a specific problem reported from the wild and is not for general use. (check-in: 34155c40 user: drh tags: filesize-debug) | |
|
2013-03-07
| ||
| 11:03 | Avoid an assertion fault and/or freeing memory while it is still in use when an error occurs during virtual table construction. Cherrypick of [a02599ad85d]. (check-in: 760072ce user: dan tags: branch-3.7.14) | |
|
2012-12-07
| ||
| 04:46 | Backport VSIX tooling and packaging fixes and enhancements. (check-in: e890bcde user: mistachkin tags: branch-3.7.14) | |
|
2012-12-06
| ||
| 20:27 | Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). (Leaf check-in: 34aafb74 user: dan tags: branch-3.7.9) | |
| 20:19 | Cherrypick [557c69055a3] and [0064bab7714] (OP_Once-related fixes for triggers). (check-in: 0d7b5d45 user: dan tags: branch-3.7.9) | |
|
2012-11-05
| ||
| 16:36 | Merge the omit-wal-fix branch into branch-3.7.9 where it belongs, and in so doing get branch-3.7.9 working with SQLITE_OMIT_WAL. (check-in: 03919517 user: drh tags: branch-3.7.9) | |
|
2012-10-26
| ||
| 13:34 | Backport the shared-cache-fix branch. (check-in: 325364a9 user: drh tags: branch-3.7.14) | |
| 13:25 | Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. (Cherry-pick merge of [8fc8548f52ab8fcfb5].) (check-in: cbfd1b12 user: drh tags: branch-3.7.14) | |
|
2012-10-25
| ||
| 17:21 | Use a constant string "BINARY" for the unspecified collating sequence. This is part of check-in [635e3a762dd] that is being back-ported. (check-in: 9078ea75 user: drh tags: branch-3.7.9) | |
|
2012-10-19
| ||
| 19:22 | Correct the design-time library file path in the VSIX package now that it is per-configuration. (check-in: 521024d4 user: mistachkin tags: branch-3.7.14) | |
|
2012-10-15
| ||
| 23:15 | Change the ICU tokenizer so that it does not attempt to call strlen(NULL). This is a cherry-pick of the fix in [04298f1ac42c40c] on 2012-03-31 first appearing in release 3.7.12. (check-in: 49ffbc11 user: drh tags: branch-3.7.9) | |
|
2012-10-12
| ||
| 18:22 | Backport of tooling support for including the debug build in the VSIX package. (check-in: c1888967 user: mistachkin tags: branch-3.7.14) | |
|
2012-10-05
| ||
| 19:10 | Add QNX-specific performance tweaks to the unix VFS. (check-in: b02849e7 user: drh tags: branch-3.7.9) | |
| 18:38 | Fix an accidental fork on branch-3.7.9. (check-in: cd9efeb3 user: drh tags: branch-3.7.9) | |
| 18:35 | Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 (check-in: ac81ae49 user: drh tags: branch-3.7.9) | |
|
2012-10-04
| ||
| 22:45 | Merge the 3.7.14.1 release including the fix for the LEFT JOIN problem into the sessions branch. (Leaf check-in: 17644c0e user: drh tags: sessions-3.7.14) | |
| 19:37 | Version 3.7.14.1 (check-in: 091570e4 user: drh tags: release, version-3.7.14.1, branch-3.7.14) | |
| 16:00 | Candidate fix for ticket [d02e1406a58ea02]. (check-in: 81fd941d user: drh tags: branch-3.7.14) | |
| 15:36 | Increase the version number to 3.7.14.1. The version of autoconf used is different from the previous release so there are huge differences in the generated "configure" script. (check-in: 972dbd5f user: drh tags: branch-3.7.14) | |
|
2012-10-03
| ||
| 20:20 | Add experimental sqlite3_reconfig() interface to more fully support the SQLITE_CONFIG_READONLY option. (check-in: 9dc2eaa6 user: mistachkin tags: configReadOnly) | |
| 18:26 | Work around an optimization issue with the MSVC compiler for ARM. (check-in: 2ce625fd user: drh tags: sessions-3.7.14) | |
| 18:20 | A branch off of the sessions branch corresponding to release 3.7.14. (check-in: 86633e01 user: drh tags: sessions-3.7.14) | |
| 11:11 | Fix the TCL interface so that SQL functions implemented in TCL honor the "nullvalue" setting. Also remove from the TCL interface some unused legacy UTF8 translation code left over from SQLite2. (check-in: 9bf64b66 user: drh tags: branch-3.7.14) | |
|
2012-10-02
| ||
| 23:26 | Work around an optimization issue with the MSVC compiler for ARM. (check-in: 9fab9edd user: drh tags: branch-3.7.14) | |
|
2012-09-28
| ||
| 12:55 | Update the sessionfault-9.1 and -9.2 tests to account for the change in version 3.7.11 in which a pending statement no longer blocks ROLLBACK but instead causes the next call on that statement to return SQLITE_ABORT. (check-in: fae9eb19 user: drh tags: sessions) | |
|
2012-09-27
| ||
| 23:27 | Fix some corner case behavior in the new ORDER BY optimization logic. Remove the SQLITE_OrderByIdx bit from the SQLITE_TESTCTRL_OPTIMIZATIONS mask, since enabling it caused many TH3 tests to fail when the NO_OPT configuration parameter was engaged, and since there really isn't any need to turn that optimization off. The SQLITE_OrderByIdxJoin bit remains. (Closed-Leaf check-in: 98b63371 user: drh tags: qp-enhancements) | |
| 19:53 | More test cases an bug fixes for the ORDER BY optimization of joins. All veryquick tests now pass. (check-in: 0d573320 user: drh tags: qp-enhancements) | |
| 17:31 | Test cases and bug fixes applied to the ORDER BY optimization for joins. Some test cases fail, but except for the new orderby1.test failures, all failures appear to be issues with the tests, not with the core code. (check-in: 75cda864 user: drh tags: qp-enhancements) | |
| 15:05 | Add more bits to the bit vector that is used to disable optimizations for built-in test. Add specific bit patterns to disable ORDER BY using an index in general and for joins. Use macros to test for bits in the disabled-optimization bit vector, in order to make the code clearer. (check-in: d2fcba1e user: drh tags: qp-enhancements) | |
| 14:11 | Enable ORDER BY clauses that span joins to be optimized out. (check-in: c29538f9 user: drh tags: qp-enhancements) | |
| 12:05 | Further tweaks to the query planner logic in preparation for adding ORDER BY opt-out for joins. (check-in: 53efc10a user: drh tags: qp-enhancements) | |
|
2012-09-26
| ||
| 23:17 | Further refactoring of the ORDER BY related query-planning logic in order to make it easier to extend to support optimizing out ORDER BY on joins. No actual behavior changes, yet. (check-in: 96496dda user: drh tags: qp-enhancements) | |
|
2012-09-25
| ||
| 20:43 | Augment the WhereBestIdx structure to pass down into the query planner information that might be used to better detect ORDER BY and DISTINCT optimizations spanning multiple tables of a join. (check-in: 4226e51f user: drh tags: qp-enhancements) | |
| 14:29 | Pass information around between the major routines of the query planner using a single pointer to a structure rather than a long list of parameters. (check-in: 1104d42e user: drh tags: qp-enhancements) | |
| 12:45 | Merge updates from trunk. (check-in: 4a470741 user: mistachkin tags: configReadOnly) | |
|
2012-09-24
| ||
| 19:50 | Remove an unused subfunction parameter and an obsolete comment from the query planner logic in where.c. (check-in: 349a55cd user: drh tags: trunk) | |
| 15:30 | Change the internal sqlite3WhereBegin() to report that the ORDER BY clause is satisfied by indices using the WhereInfo.nOBSat field of the returned structure. (check-in: 22989f35 user: drh tags: trunk) | |
| 11:43 | Update documentation to describe the threadsafety of sqlite3_enable_shared_cache(). (check-in: e081890c user: drh tags: trunk) | |
|
2012-09-21
| ||
| 22:50 | Enable query planner tracing using the new (and undocumented) ".wheretrace 1" command in the command-line shell if both the shell and the core are compiled with SQLITE_DEBUG and SQLITE_ENABLE_WHERETRACE. This is not a supported API. Use for testing and debugging only. (check-in: 1be4b16b user: drh tags: trunk) | |
| 13:40 | Command-line shell enhancements: Added the ".print" command. Enhanced the ".width" command so that negative widths will right-justify. (check-in: a1d8269d user: drh tags: trunk) | |
| 00:04 | Consolidate more of the DISTINCT processing logic into a single spot in the code. Reduce the number of OP_Column operations needed to perform a WHERE_DISTINCT_ORDERED. (check-in: 79e922f7 user: drh tags: trunk) | |
|
2012-09-20
| ||
| 15:41 | Continuing incremental enhancements of SELECT code generation: Remove the Select.affinity field. Use SelectDest.affSdst instead. (check-in: cf40b7b5 user: drh tags: trunk) | |
| 14:26 | Refactoring of DISTINCT code. Change the name of the local variable "distinct" to "distinctTab". Generate cleaner code w/o unnecessary P4 and P5 values on the OP_Null for WHERE_DISTINCT_ORDERED. (check-in: 0cda241a user: drh tags: trunk) | |
|
2012-09-19
| ||
| 21:15 | Tighter VDBE code for the WHERE_DISTINCT_ORDERED case of DISTINCT keyword handling. (check-in: 94b48064 user: drh tags: trunk) | |
| 17:31 | Add comments to the WHERE_DISTINCT_* macros. No changes to code. (check-in: 82320501 user: drh tags: trunk) | |
| 00:35 | Merge the covering-index-scan optimization into trunk. (check-in: ddd5d789 user: drh tags: trunk) | |
|
2012-09-18
| ||
| 23:21 | Silence harmless compiler warning seen with SQLITE_OMIT_DEPRECATED. (check-in: c5cee969 user: mistachkin tags: trunk) | |
| 19:29 | Enhance IN processing to allow efficient use of indices with numeric affinities. Add test cases for IN processing that would have spotted the error in the [2be661a48023f4] check-in. (check-in: 5ded9b68 user: drh tags: trunk) | |
| 17:32 | This change generates incorrect code when there are two or more IN operators in the WHERE clause that are both used by the same index. Was: Omit an unnecessary OP_IfNull that immediately follows an OP_Rowid. (Closed-Leaf check-in: 2be661a4 user: drh tags: mistake) | |
| 17:08 | Enhancements to the comments on sqlite3FindInIndex(). No code changes. (check-in: b1a4c394 user: drh tags: trunk) | |
| 14:00 | Add the stack_usage.tcl script for analyzing the output of objdump on the amalgamation and estimating the sizes of stack frames on each function. (check-in: 030013ff user: drh tags: trunk) | |
| 13:20 | Update the vdbe-compress.tcl script so that it accepts variable declarations inside of #ifdef...#endif. This enhancement is needed due to the change of check-in [39866c0ede5d6ef4]. (check-in: e7db056a user: drh tags: trunk) | |
|
2012-09-17
| ||
| 21:24 | Make sure the WHERE_IDX_ONLY flag is not set on query plans that will not be using an index. (Closed-Leaf check-in: 698b2a28 user: drh tags: fullscan-covering-index) | |
| 20:44 | Add the ability to disable the covering-index-scan optimization at compile-time, start-time, or at run-time. Add test cases to check this configurability. (check-in: ccb8ecc3 user: drh tags: fullscan-covering-index) | |
| 19:26 | Merge recent trunk changes into the fullscan-covering-index branch. (check-in: 1c0bf030 user: drh tags: fullscan-covering-index) | |
| 19:12 | Remove obsolete bits from the bitvector that defines disabled optimizations in the SQLITE_TESTCTRL_OPTIMIZATIONS verb of sqlite3_test_control(). (check-in: 4c21ee2d user: drh tags: trunk) | |
| 18:56 | Remove an unnecessary parameter from sqlite3Utf8Read() resulting in a slight performance increase. (check-in: 8b962c94 user: drh tags: trunk) | |
| 17:16 | Make sure the KeyInfo.aSortOrder array is always allocated so that we never have to test for KeyInfo.aSortOrder==0 in performance-critical loops. (check-in: 45793f0b user: drh tags: trunk) | |
| 15:36 | Performance enhancement in the sqlite3VdbeSerialType() routine. (check-in: ad298f52 user: drh tags: trunk) | |
|
2012-09-15
| ||
| 18:45 | Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: cfaa7bc1 user: drh tags: fullscan-covering-index) | |
| 13:39 | Make sure the name of rollback journal files are double-zero terminated when they are passed into the VFS. (check-in: 8711a844 user: drh tags: trunk) | |
| 13:29 | Factor out the code that generates a co-routine for evaluating the SELECT on the RHS of an INSERT statement so that the same code can potentially be reused in other places. (check-in: a93ee09c user: drh tags: trunk) | |
|
2012-09-13
| ||
| 19:59 | Improved alignment of fields in the Expr object gives an 8-byte size reduction on 64-bit machines. (check-in: 6b252a0d user: drh tags: trunk) | |
| 16:12 | Fix WAL capability checking in one of the test files. (check-in: 0ebe7cc5 user: mistachkin tags: trunk) | |
| 15:26 | Fix an unused variable warning with SQLITE_OMIT_WAL. (check-in: 39866c0e user: mistachkin tags: trunk) | |
| 15:24 | Improved reporting of filename translation errors in the Windows VFS. (check-in: eb0f1c29 user: mistachkin tags: trunk) | |
| 14:42 | Reduce the size of the Table object by 16 bytes on 64-bit machines, mostly by avoiding intermixing pointer fields with integer fields. (check-in: 1cb9aedf user: drh tags: trunk) | |
| 14:22 | Change boolean fields in the Column object from unsigned characters into bits in a single bit mask variable. (check-in: 4163f5f1 user: drh tags: trunk) | |
| 12:10 | Add the RTREE_INT_ONLY configuration parameter to the compile-time options logic. (check-in: 98b971fb user: drh tags: trunk) | |
| 01:51 | Allow SQLite to work on Win32 with SQLITE_OS_WINNT=0 as long as WAL is disabled. (check-in: c1a85570 user: mistachkin tags: trunk) | |
|
2012-09-12
| ||
| 18:45 | Add an implementation of the REGEXP operator and function. Only defined if compiled with SQLITE_ENABLE_REGEXP. (Closed-Leaf check-in: 8398f77c user: drh tags: regexp) | |
| 00:11 | Update version number to 3.7.15. Delete some obsolete build scripts. (check-in: 9402f81f user: drh tags: trunk) | |
|
2012-09-11
| ||
| 02:00 | Added sqlite3_errstr API to translate a result code to the corresponding error message. (check-in: bf8a9ca5 user: mistachkin tags: trunk) | |
|
2012-09-10
| ||
| 23:44 | Correct two duplicated test names. (check-in: ced49974 user: mistachkin tags: trunk) | |
| 15:02 | Remove the stale implementation of the ifnull and coalesce functions - code that has been commented out for ages. No functional changes. (check-in: c2ad6911 user: drh tags: trunk) | |
| 10:29 | Initial prototype of SQLITE_CONFIG_READONLY. (check-in: 7c340165 user: mistachkin tags: configReadOnly) | |
| 09:33 | Avoid using the sqlite3ErrStr function in the Tcl package if USE_SYSTEM_SQLITE is defined. (check-in: a716b9a3 user: mistachkin tags: trunk) | |
| 08:48 | Make header comments for some Tcl test commands more consistent. No changes to code. (check-in: af870ca9 user: mistachkin tags: trunk) | |
| 07:56 | More test cleanup. (Closed-Leaf check-in: b8d5359b user: mistachkin tags: testClean) | |
| 07:29 | Refine error messages in the sqlite3 Tcl command when a NULL database connection is returned from sqlite3_open_v2. (check-in: f260d7d5 user: mistachkin tags: trunk) | |
| 06:02 | Fix typo in documentation for sqlite3_open_v2. No changes to code. (check-in: b532120a user: mistachkin tags: trunk) | |
|
2012-09-04
| ||
| 21:34 | Avoid repeating calls to the sqlite3_trace() callback when the same statement is evaluted multiple times by sqlite3_step() due to an SQLITE_SCHEMA reprepare. (check-in: 39f763bf user: drh tags: trunk) | |
|
2012-09-03
| ||
| 15:42 | Version 3.7.14 (check-in: c0d89d4a user: drh tags: trunk, release, version-3.7.14) | |
| 12:40 | Fix compiler warnings in test_spellfix1.c (check-in: ebb08d0b user: drh tags: trunk) | |
| 11:39 | Add resources describing the version number and other information to EXEs and DLLs generated using MSVC. (check-in: a15a7084 user: drh tags: trunk) | |
| 11:14 | Insert additional tab character. (Closed-Leaf check-in: 3af7c1a6 user: mistachkin tags: win32Resources) | |
| 11:01 | Linking and cleaning fixes for the tclsqlite3.exe target in the MSVC makefile. (check-in: 96d43c7a user: mistachkin tags: win32Resources) | |
| 10:32 | Add Win32 version resources to the applicable binaries built by the MSVC makefile. (check-in: e2f27d28 user: mistachkin tags: win32Resources) | |
|
2012-08-31
| ||
| 14:55 | In the spellfix phonehash() function, add letter W into the same character class as V. (check-in: 75361013 user: drh tags: trunk) | |
| 14:23 | Update with latest trunk changes. (check-in: 87995dc9 user: dan tags: sessions) | |
| 14:10 | Merge in latest trunk changes. (check-in: bc9b9cd0 user: dan tags: apple-osx) | |
| 12:31 | Changes for ERROR_PATH_NOT_FOUND in addition to ERROR_FILE_NOT_FOUND in winAccess(). (check-in: 527340ab user: drh tags: trunk) | |
|
2012-08-30
| ||
| 20:24 | Exclude the atof1.test test script from the valgrind permutations test since valgrind sets up the floating point hardware in an unusual way that makes atof1 fail. (check-in: d3cf6832 user: drh tags: trunk) | |
| 11:22 | Fix an out-of-bounds read in the demonstration code in test_spellfix.c. (check-in: 59194311 user: dan tags: trunk) | |
|
2012-08-29
| ||
| 10:28 | Fix a typo in a comment in vdbe.c. No changes to code. (check-in: 9fbe858b user: drh tags: trunk) | |
|
2012-08-28
| ||
| 14:45 | Fix a case where SQLite was failing to detect a syntax error in queries like "SELECT ... FROM (<select-1> UNION ALL <select-2>)" when <select-1> and <select-2> return different numbers of result columns. (check-in: 200a8135 user: dan tags: trunk) | |
| 04:20 | Issue a log message if the temporary directory has not been set when running on WinRT. (check-in: 9ee39102 user: mistachkin tags: trunk) | |
| 01:44 | Enable the use of a simpler command line when cross-compiling in the MSVC build environment. (check-in: 8ade136a user: mistachkin tags: trunk) | |
| 00:17 | Formatting changes to the C code example in the documentation for sqlite3_temp_directory(). No changes to code. (check-in: 5b4b3978 user: drh tags: trunk) | |
| 00:09 | Update API docs to include notes about the WinRT temporary directory. No changes to code. (check-in: eaeeb069 user: mistachkin tags: trunk) | |
|
2012-08-27
| ||
| 21:19 | Add to #undef statements to the command-line shell, go make sure that the macros definitions that follow do not collide with system definitions. (check-in: 24420d6d user: drh tags: trunk) | |
| 14:39 | Fix an incorrect assert in the virtual table logic - it could fire following an I/O error after sqlite3_close_v2() was added. (check-in: 4ccc18e9 user: drh tags: trunk) | |
|
2012-08-25
| ||
| 10:01 | Fix all known instances of 'repeated the' style typos in comments. No changes to code. (check-in: 9b19b847 user: mistachkin tags: trunk) | |
| 02:11 | Fix a harmless compiler warning. (check-in: 929b5184 user: drh tags: trunk) | |
| 01:38 | Merge all the latest trunk changes into the apple-osx branch. (check-in: 6723add4 user: drh tags: apple-osx) | |
| 01:21 | Merge the latest trunk changes into the sessions branch. (check-in: aa62d688 user: drh tags: sessions) | |
|
2012-08-24
| ||
| 23:56 | When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (check-in: 62678be3 user: drh tags: trunk) | |
| 23:24 | Move field WhereLevel.pCovidx inside the union to WhereLevel.u.pCovidx. (Closed-Leaf check-in: b722143d user: drh tags: multi-or-covering-index) | |
| 21:54 | Remove a NEVER() that is in fact reachable on an OOM. This probably has nothing to do with the multi-or-covering-index change but just happened to be found while testing that change. (check-in: 5499af53 user: drh tags: multi-or-covering-index) | |
| 19:58 | Another test for whereD.test. (check-in: 29d58617 user: dan tags: multi-or-covering-index) | |
| 19:52 | Add extra tests to whereD.test. (check-in: 7e961eef user: dan tags: multi-or-covering-index) | |
| 18:44 | Fix a problem to do with multi-or queries and automatic indexes. (check-in: a3e26038 user: dan tags: multi-or-covering-index) | |
| 17:52 | More test cases for OR-optimization covering indices. (check-in: e5c3190c user: drh tags: multi-or-covering-index) | |
| 15:29 | Additional test cases for OR-optimization with covering indices, including one test case that currently fails. (check-in: d8b7ab37 user: drh tags: multi-or-covering-index) | |
| 10:52 | Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once. (check-in: 1dc8c7c7 user: dan tags: multi-or-covering-index) | |
| 01:07 | Merge the nested aggregate query enhancements into trunk. (check-in: d4cd6017 user: drh tags: trunk) | |
|
2012-08-23
| ||
| 22:45 | Merge changes for the new sqlite3_win32_set_directory API to trunk. (check-in: 20f184f2 user: mistachkin tags: trunk) | |
| 19:46 | Add test cases and fix bugs associated with the previous check-in enhancements to nested aggregate subquery processing. (Closed-Leaf check-in: 00b1dc71 user: drh tags: nested-agg) | |
| 16:18 | Further improvements to the processing of nested aggregate queries. (check-in: 3c3ffa90 user: drh tags: nested-agg) | |
|
2012-08-22
| ||
| 15:16 | Do not let the multi-core sorter use lookaside memory, which is not thread-safe. (Leaf check-in: acdc7d12 user: drh tags: threads-sort-ex1) | |
| 00:39 | Modify the MSVC makefile to make it easier to select the heap subsystem to use. (check-in: b1dbf490 user: mistachkin tags: trunk) | |
| 00:18 | Add assert to check that the memory block for the previous directory value was allocated via sqlite3_malloc or related function. (Closed-Leaf check-in: 1246f15b user: mistachkin tags: win32SetDir) | |
|
2012-08-21
| ||
| 23:33 | Added sqlite3_win32_set_directory API to assist in portability to WinRT. (check-in: 600de08d user: mistachkin tags: win32SetDir) | |
| 17:46 | Merge in all the latest trunk changes. (check-in: 45cdc32f user: drh tags: threads-sort-ex1) | |
| 17:44 | Update the spellfix virtual table so that all OOM errors are reported out to the application. (check-in: 573770f5 user: drh tags: trunk) | |
| 17:36 | Cherry-pick [555fc07]: Changes to the thread routines to disable them when threading is turned off using sqlite3_config(). Also merge all recent trunk changes. (check-in: c92b0fe1 user: drh tags: threads) | |
| 13:08 | Update the spellfix virtual table so that all OOM errors are reported out to the application. ERROR: A single edit was missed in spellfix1 which means that this particular check-in won't build "make test". (Closed-Leaf check-in: c2cf4985 user: drh tags: mistake) | |
|
2012-08-20
| ||
| 17:24 | Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. (check-in: e799222f user: dan tags: trunk) | |
| 16:23 | Change the checkSpacing utility program to ignore whitespace at end-of-line unless the --wseol option is used. (check-in: be1faade user: drh tags: trunk) | |
| 16:08 | Silence harmless compiler warnings in the test code. (check-in: 7653973a user: drh tags: trunk) | |
| 15:53 | Remove tab characters from source code files. Replace them with spaces. (check-in: 7edd10a9 user: drh tags: trunk) | |
| 15:46 | Add a command-line program to tool/ that will check source code files for the presence of tabs, carriage-returns, whitespace at the ends of lines, and blank lines at the ends of files. (check-in: 656a9c8b user: drh tags: trunk) | |
| 12:36 | Changes to the thread routines to disable them when threading is turned off using sqlite3_config(). (check-in: 555fc07e user: drh tags: threads-sort-ex1) | |
|
2012-08-17
| ||
| 13:44 | Clarify that the number-of-bytes parameter to sqlite3_bind_blob() must be non-negative. (check-in: b1b01c4c user: drh tags: trunk) | |
| 12:13 | Fix MSVC compiler warning in the spellfix module. Also, add an assert. (check-in: e66cf040 user: mistachkin tags: trunk) | |
| 11:47 | Skip defining some WAL specific things in the Win32 VFS code when compiling without WAL support. Also, fix an example command line in the MSVC makefile. (check-in: 61b1ae12 user: mistachkin tags: trunk) | |
|
2012-08-16
| ||
| 20:05 | Attempt to use two cores to do sorting. Unfortunately, instead of making sorts go faster as was hoped, this changes slows sorting down by about 10%. (Later:) The previous measurement was compiled using -pg. When compiled using -Os, this new code is roughly 10% faster than the original. (check-in: 11dd05e5 user: drh tags: threads-sort-ex1) | |
| 11:24 | Update the threads branch to include all the latest trunk changes. (check-in: f4125771 user: drh tags: threads) | |
|
2012-08-15
| ||
| 16:43 | Changes to the spellfix test script to make the results deterministic. (check-in: 31c07db2 user: drh tags: trunk) | |
| 16:21 | Merge all the latest trunk changes into the sessions branch. (check-in: fc07a479 user: drh tags: sessions) | |
| 16:06 | Change autoconf so that the --with-tcl=DIR option will override the TCL configuration that is found using tclsh. (check-in: 772d0de3 user: drh tags: trunk) | |
| 15:57 | Experimental change to speed up ORDER BY clauses that sort based on a single expression. (Leaf check-in: 2bb8c492 user: dan tags: sorter-exp) | |
|
2012-08-14
| ||
| 19:04 | Silence three harmless compiler warnings in vdbesort.c. (check-in: a5431c86 user: drh tags: trunk) | |
| 18:43 | Add an assert() to the btree rebalancer in order to silence a clang/scan-build warning. (check-in: 6730579c user: drh tags: trunk) | |
| 17:29 | Update the spellfix virtual table to the latest development code. (check-in: 6954fef0 user: drh tags: trunk) | |
| 01:45 | Refer to the file mapping Win32 API functions only when absolutely necessary. (check-in: 1de2237d user: mistachkin tags: trunk) | |
|
2012-08-13
| ||
| 22:05 | Refer to the WaitForSingleObjectEx and SetFilePointerEx Win32 functions only for platforms where they are going to be used. (check-in: 9888ce92 user: mistachkin tags: trunk) | |
|
2012-08-08
| ||
| 14:04 | When populating an index b-tree as part of a CREATE INDEX or REINDEX statement, distribute cells between up to three siblings in balance_nonroot() instead of four. This produces identical database files, but is slightly faster. (check-in: b0d31e77 user: dan tags: trunk) | |
| 11:55 | When building a b-tree as part of a CREATE INDEX or REINDEX statement, attempt to pack keys into pages as tightly as possible. (check-in: efea62b9 user: dan tags: trunk) | |
| 10:14 | Change to securedel2.test so that it works even if SQLITE_DEFAULT_AUTOVACUUM=1 is defined. (check-in: 1e6f5ea4 user: dan tags: trunk) | |
|
2012-08-07
| ||
| 22:53 | Simplifications to the sorter to support full-coverage testing. (check-in: de804f4c user: drh tags: trunk) | |
| 17:41 | Add extra tests for secure-delete mode. (check-in: e380cd3c user: dan tags: trunk) | |
| 15:19 | Fix a bug in hash.c introduced by [305b66672653]. (check-in: 17cb5e95 user: dan tags: trunk) | |
| 14:18 | Do not run test script spellfix.test if SQLITE_OMIT_VIRTUAL_TABLE is defined. Fix walro.test so that it works if DEFAULT_AUTOVACUUM is defined. (check-in: 26428b45 user: dan tags: trunk) | |
| 13:55 | Fix a bug in walthread.test causing intermittent failures. (check-in: a192a718 user: dan tags: trunk) | |
| 01:37 | Parser bug fix: Make sure the table constraints allowed by prior releases can still be parsed, even if they are technically not allowed by the syntax diagram. This is a cherry-pick of [a1c014d8a87c8940b3], [38bf90af1ede6ee64e], and [e536ac041815b118c4]. (Leaf check-in: 28aed847 user: drh tags: apple-osx-ml) | |
|
2012-08-06
| ||
| 23:21 | Backport VSIX packaging support and related changes. (Closed-Leaf check-in: 0620285d user: mistachkin tags: vsix-3.7.13) | |
| 22:29 | Modify VSIX package generation tool to put the PDB files in the Debug directory. (check-in: 9d072083 user: mistachkin tags: trunk) | |
| 19:28 | Merge the sorter-coalesce-writes branch into the trunk. This improves CREATE INDEX performance on some platforms. (check-in: e1e9cb08 user: dan tags: trunk) | |
| 19:12 | Fix a crash that could follow an OOM condition. (Closed-Leaf check-in: 2e5741f7 user: dan tags: sorter-coalesce-writes) | |
| 18:50 | When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. (check-in: d045f8b2 user: dan tags: sorter-coalesce-writes) | |
| 18:10 | Update sorter-coalesce-writes branch with latest trunk changes. (check-in: 214f8cda user: dan tags: sorter-coalesce-writes) | |
| 10:51 | Update description strings in the VSIX package. (check-in: 541e9310 user: mistachkin tags: trunk) | |
|
2012-08-03
| ||
| 10:00 | Correct comment about WinRT compiler define. No changes to code. (check-in: 335e91e5 user: mistachkin tags: trunk) | |
|
2012-08-01
| ||
| 20:20 | Fix typos of function names sqlite3_result_error_toobig and sqlite3_result_error_nomem in the documentation. No changes to code. (check-in: bec97c98 user: mistachkin tags: trunk) | |
|
2012-07-31
| ||
| 08:15 | Make the list of platforms dynamic in the SDK manifest inside the VSIX package. (check-in: 22b72e49 user: mistachkin tags: trunk) | |
| 00:43 | Modify metadata for the VSIX package and add tooling support for PDBs. (check-in: 12cbf6a9 user: mistachkin tags: trunk) | |
|
2012-07-30
| ||
| 14:53 | Replace a few sqlite3_malloc()+memset() sequences with calls to sqlite3MallocZero(). (check-in: 305b6667 user: dan tags: trunk) | |
|
2012-07-27
| ||
| 23:03 | Improve consistency in handling of build outputs and native library paths in the multi-platform build tool for MSVC. (check-in: e71f2de2 user: mistachkin tags: trunk) | |
| 22:29 | Minor adjustments to the multi-platform build tool for MSVC. (check-in: e76b8f77 user: mistachkin tags: trunk) | |
| 08:33 | For the clean makefile targets, delete the generated VSIX file as well. (check-in: d575d961 user: mistachkin tags: trunk) | |
| 08:21 | Modify the multi-platform build tool for MSVC to support the latest RC version. (check-in: 95b65883 user: mistachkin tags: trunk) | |
| 07:13 | Add tool to build the core DLL for multiple platforms using MSVC. (check-in: e42f5812 user: mistachkin tags: trunk) | |
| 02:36 | Add tool to generate a VSIX package usable by Visual Studio 2012 RC. (check-in: 8b90e0c4 user: mistachkin tags: trunk) | |
|
2012-07-26
| ||
| 09:21 | Update some comments in vdbesort.c. (check-in: f4b3fded user: dan tags: sorter-coalesce-writes) | |
|
2012-07-24
| ||
| 19:46 | Mark parameters to sorter interfaces as const where appropriate. (check-in: d8da26f1 user: drh tags: trunk) | |
| 06:02 | Add another define to the MSVC makefile that is sometimes required to build cleanly for WinRT. (check-in: d582cd89 user: mistachkin tags: trunk) | |
|
2012-07-23
| ||
| 21:43 | Refactor field names in the SelectDest object to make them distinct and easier to grep for. (check-in: b589f1ef user: drh tags: trunk) | |
| 20:10 | Fix an edge case in vdbesort.c. (check-in: 4ba266fc user: dan tags: sorter-coalesce-writes) | |
| 19:25 | Modify the code in vdbesort.c so that most reads and writes to temporary files are aligned page-sized blocks. (check-in: 55e47ef3 user: dan tags: sorter-coalesce-writes) | |
| 06:47 | Add an assert() to help verify the return code from the Win32 thread wait function. (check-in: ed3dc7a8 user: mistachkin tags: threads) | |
| 02:00 | Enhance implementation of the Win32 thread wait function. (check-in: 049b0411 user: mistachkin tags: threads) | |
|
2012-07-21
| ||
| 22:49 | Add Win32 support to the internal threads interface. Also, add several asserts and fix a few typos. (check-in: 793195d3 user: mistachkin tags: threads) | |
| 19:40 | Add an internal interface that allows the code to take advantage of multiple cores by pushing subcomputations off into separate threads. The interface is not currently used. (check-in: 0e4d977a user: drh tags: threads) | |
|
2012-07-19
| ||
| 20:27 | Further tweaks to malloc paths. (Closed-Leaf check-in: 0a334441 user: dan tags: calloc) | |
|
2012-07-18
| ||
| 16:07 | Remove another branch from the DbMalloc() paths. (check-in: defd828e user: dan tags: calloc) | |
| 11:28 | Reorganize code to remove a few of the branches introduced into the critical sqlite3DbMallocXXX() path by the previous commit. (check-in: 75c095ee user: dan tags: calloc) | |
|
2012-07-17
| ||
| 19:32 | Enhance the custom memory allocation interface to allow the user to specify a calloc() function. (check-in: 8752237d user: dan tags: calloc) | |
| 17:46 | Cherrypick [8c9ee1d78f] and [e416359633] from trunk: Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. (check-in: 65035912 user: drh tags: apple-osx) | |
| 14:37 | Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. (check-in: e4163596 user: dan tags: trunk) | |
| 02:56 | Amplification of a comment in wal.c. Change the aReadMark[] processing so that one read mark is left at zero when a WAL resets. (check-in: 8c9ee1d7 user: drh tags: trunk) | |
|
2012-07-16
| ||
| 23:13 | Merge the spellfix1 changes for supporting matchlen into trunk. (check-in: 6f167adf user: drh tags: trunk) | |