Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 descendants and 200 ancestors of 9235b0cf6a37712a
|
2016-03-14
| ||
| 16:16 | Test script changes to support testing the SQLite Encryption Extension. (check-in: 1c70aa5c01 user: drh tags: see-testing) | |
| 15:43 | Fix the backcompat.test script so that it works with the --testdir test option. (check-in: f7480e33eb user: dan tags: trunk) | |
| 15:03 | Run TCL tests in the "testdir" subdirectory. (check-in: 90e0cc7b0b user: drh tags: trunk) | |
| 14:59 | More file pathname normalization. (Closed-Leaf check-in: fa8c12921f user: drh tags: test-in-subdir) | |
| 14:28 | Normalize the $testdir and $argv0 paths so that they continue to work in the testing subdirectory. (check-in: 19225b8130 user: drh tags: test-in-subdir) | |
| 13:42 | Run TCL tests in a subdirectory "testdir". (check-in: f632bba0d6 user: drh tags: test-in-subdir) | |
| 12:16 | Fix a memory leak in fts5 that could occur following a syntax error in a query expression. (check-in: 54b8968e33 user: dan tags: trunk) | |
|
2016-03-12
| ||
| 19:33 | Fix a problem handling 'NEAR("" token)' in fts5 found by fuzzing. (check-in: 10a827ae5f user: dan tags: trunk) | |
| 16:32 | Fix handling of strings that contain zero tokens in fts5. And other problems found by fuzzing. (check-in: 72b3ff0f0d user: dan tags: trunk) | |
|
2016-03-11
| ||
| 23:07 | Do not allow the use of WAL mode with nolock=1 because it does not work. (check-in: 74f5d3b07f user: drh tags: trunk) | |
| 15:25 | Tweak the amalgamation autoconf files so that the --disable-static-shell option works again. (check-in: 83efcdebfa user: dan tags: trunk) | |
| 14:30 | Update spellfix1_scriptcode() to output 215 (latin) for pure numeric text. (check-in: df44308b86 user: drh tags: trunk) | |
|
2016-03-10
| ||
| 19:08 | Check for PDB files prior to attempting to copy them in the MSVC batch build tool. (check-in: d7c20f04e6 user: mistachkin tags: trunk) | |
| 15:12 | Add tests to cover untested branches in recent fts5 changes. (check-in: fa0033edf6 user: dan tags: trunk) | |
| 14:28 | Use #ifdefs to remove code that is unreachable in some configurations, replacing it with an assert(). (check-in: f96ec84d60 user: drh tags: trunk) | |
| 14:22 | Remove an unused local variable. (check-in: 3c343c3d01 user: drh tags: trunk) | |
|
2016-03-09
| ||
| 20:54 | Add an incremental optimize capability to fts5. Make the 'merge' command independent of the 'automerge' settings. (check-in: 556671444c user: dan tags: trunk) | |
| 18:17 | Fix a problem in fts3/4 that was causing it to discard data cached in-memory if an 'optimize' command is run when there is no data on disk. The usual way this would happen is if the very first transaction that writes to the fts3/4 table also includes an 'optimize' command. (check-in: 79338b991b user: dan tags: trunk) | |
| 15:34 | Slight simplification to the query optimizer logic associated with IN (SELECT). (check-in: 2c55c3c295 user: drh tags: trunk) | |
| 15:14 | Add another test case for bug [5e3c8867]. (check-in: d91e57e49f user: dan tags: trunk) | |
| 15:09 | When optimizing expressions of the form "x IN (SELECT ...)" make sure that the subquery is not correlated. Fix for ticket [5e3c886796e5512]. (check-in: 1ed6b06ea3 user: drh tags: trunk) | |
| 13:39 | Automatically disable SQLITE_ENABLE_EXPLAIN_COMMENTS if SQLITE_OMIT_EXPLAIN is defined. (check-in: 8d4b6b2b51 user: drh tags: trunk) | |
| 12:35 | In the query planner, make sure OOM errors are reported up into whereLoopAddVirtual() so that it shuts down appropriately. (check-in: a13c59d08b user: drh tags: trunk) | |
| 11:59 | Disable the bestindex*.test modules when building without virtual table support. (check-in: e0bac2f3ee user: drh tags: trunk) | |
| 08:08 | Merge latest trunk changes with this branch. (check-in: 59caca4387 user: dan tags: schemalint) | |
| 04:17 | Simplifications to the memjournal.c logic to facilitate testing. (check-in: 8baa2c2c76 user: drh tags: trunk) | |
| 03:44 | Move the write failure test in memjrnlCreateFile() to just after the actual write, thus reducing the number of instances of the test by one. (check-in: 7f00d80c63 user: drh tags: trunk) | |
| 03:29 | Update a comment in btree.c to account for WITHOUT ROWID tables. No code changes. (check-in: fa20dcb03b user: drh tags: trunk) | |
| 02:12 | Change a branch made obsolete by recent parser enhancements into an assert(). (check-in: ee486ef742 user: drh tags: trunk) | |
| 02:03 | Add an #ifdef and an ALWAYS() for coverage. (check-in: 069337a922 user: drh tags: trunk) | |
|
2016-03-08
| ||
| 23:44 | Change an unreachable branch in the virtual table query planner into an assert(). (check-in: 73b97b9ec3 user: drh tags: trunk) | |
| 23:18 | Improved comments on virtual table query planning. Added many new WHERETRACE() macros. (check-in: 4c89c2534a user: drh tags: trunk) | |
| 17:59 | In memjournal.c, reuse the same sqlite3_file object for both the in-memory phase and the on-disk phase. (check-in: e7fbbdc25c user: drh tags: trunk) | |
| 17:44 | Modify the memjournal.c code to make it a bit smaller. (Closed-Leaf check-in: d99ac41548 user: dan tags: memjournal-exp) | |
| 16:35 | Merge changes from trunk, especially the SQLITE_DEFAULT_SYNCHRONOUS enhancements. (check-in: 2974194123 user: drh tags: apple-osx) | |
| 16:07 | Drop support for SQLITE_EXTRA_DURABLE. The new SQLITE_DEFAULT_SYNCHRONOUS compile-time option is a more general replacement. (check-in: f6d3156ba9 user: drh tags: trunk) | |
| 16:02 | Remove an unused goto label in the RBU extension. (check-in: 2179a106e8 user: drh tags: trunk) | |
| 15:52 | Add a new row type to RBU (a peer of insert, update and delete) - "delete then insert". (check-in: 1d9468d242 user: dan tags: trunk) | |
| 15:47 | Add the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS compile-time options. Automatically switch to the WAL_SYNCHRONOUS setting when first opening a WAL-mode database if the synchronous setting has not been previously set by the application. (check-in: 5a847a676e user: drh tags: trunk) | |
| 15:37 | Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error. (check-in: 64b3cb2915 user: dan tags: trunk) | |
| 15:30 | Make the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS values zero-based to agree with PRAGMA synchronous. (Closed-Leaf check-in: 592d210436 user: drh tags: default-synchronous) | |
| 15:14 | If SQLITE_DEFAULT_WAL_SYNCHRONOUS is not the same value as SQLITE_DEFAULT_SYNCHRONOUS and the application has not run "PRAGMA synchronous", then set synchronous to the SQLITE_DEFAULT_WAL_SYNCHRONOUS setting when entering WAL mode for the first time. (check-in: 5791407b52 user: drh tags: default-synchronous) | |
| 14:40 | Add compile-time options SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS used to specify the default synchronous settings for all database connections. (check-in: 1fefa967aa user: drh tags: default-synchronous) | |
| 14:16 | Fix ATTACH to use the symbolic name PAGER_SYNCHRONOUS_FULL rather than an integer literal. (check-in: c4e192a0e5 user: drh tags: trunk) | |
| 14:01 | Merge coverage improvements and comment fixes from trunk. (check-in: 58023bfccc user: drh tags: apple-osx) | |
| 13:56 | Fix comments on pager flag settings to include synchronous=EXTRA. (check-in: 3a65a1fc0f user: drh tags: trunk) | |
| 02:59 | Simplified error detection in the xBestIndex processing. (check-in: 82ca2131b6 user: drh tags: trunk) | |
| 01:32 | Add the ALLBITS macro as a shorthand for "(Bitmask)(-1)". (check-in: 91bd619d27 user: drh tags: trunk) | |
| 01:11 | Add a NEVER() to the code generator. Change the parameter name "mExtra" to "mPrereq" in the query planner, to more closely reflect its meaning. (check-in: 721ae51e44 user: drh tags: trunk) | |
| 00:39 | Changes so that some assert()s in the virtual table query planner are correct even following an OOM error. (check-in: 9805f6f852 user: drh tags: trunk) | |
|
2016-03-07
| ||
| 21:28 | Fix a typo and remove an unused variable from test logic. (check-in: 9f31516c5d user: drh tags: apple-osx) | |
| 20:48 | Merge recent enhancements from trunk. (check-in: 84f09f00f8 user: drh tags: apple-osx) | |
| 20:14 | Update fts3/4 so that the 'merge=X,0' command merges X pages from all segments of the first level in the fts index that contains 2 or more segments. (check-in: cddf69dbc4 user: dan tags: trunk) | |
| 19:08 | Avoid a NULL pointer dereference following an OOM while generating code for IN operators on virtual tables. (check-in: c924008692 user: drh tags: trunk) | |
| 17:49 | Merge the virtual table query planner enhancement, the RTREE cost estimate fix, and the statement journal spill delay enhancement from trunk. (check-in: 17fd8f3cf0 user: drh tags: sessions) | |
| 17:39 | Add a new row type to RBU (a peer of insert, update and delete) - "delete then insert". (Closed-Leaf check-in: 169311c85b user: dan tags: rbu-delete-then-insert) | |
| 17:37 | Add the SQLITE_CONFIG_STMTJRNL_SPILL option for sqlite3_config(). (check-in: b6c4202432 user: drh tags: trunk) | |
|
2016-03-05
| ||
| 21:32 | Fix a problem in the previous commit affecting queries with three or more tables joined together to the right of a LEFT or CROSS JOIN operator. (check-in: d8d89d69a4 user: dan tags: trunk) | |
| 21:07 | Change the way SQLite invokes the xBestIndex method of virtual tables so that N-way joins involving virtual tables work as expected. (check-in: 195444380b user: dan tags: trunk) | |
| 20:28 | Adjust the cost estimates for RTREE such that the expected number of rows and expected cost is halved for each additional constraint. (Closed-Leaf check-in: fd7cd06093 user: drh tags: xbestindex-fix) | |
| 17:29 | Change the way SQLite invokes the xBestIndex method of virtual tables so that N-way joins involving virtual tables work as expected. (check-in: ffc65968ed user: dan tags: xbestindex-fix) | |
| 15:35 | Remove the unused journal.c source file (its function have been subsumed into memjournal.c). Refactor some of the names in memjournal.c. No functional changes. (check-in: 5f2a262d3f user: drh tags: trunk) | |
| 15:03 | Work around (incorrect) ASAN warnings in memjournal.c. (check-in: 4de09777da user: drh tags: trunk) | |
| 14:19 | Fix an integer size mismatch problem in test_bestindex.c (check-in: 2e35eb6b74 user: drh tags: trunk) | |
| 14:00 | Fix an incorrect #ifdef on sqlite3LogEstToInt(). (check-in: dca7b23354 user: drh tags: trunk) | |
|
2016-03-04
| ||
| 21:18 | Fix an assert() in sqlite3VarintLen(), even though it is impossible to hit in SQLite due to the way sqlite3VarintLen() is used. (check-in: 251424c586 user: drh tags: trunk) | |
| 19:55 | Simplify the computation of Index.aAvgEq. (Leaf check-in: c448873006 user: drh tags: analyze-worst-case) | |
| 18:45 | Merge changes from trunk. (check-in: 5294c977d9 user: drh tags: analyze-worst-case) | |
| 16:42 | Merge recent enhancements from trunk. Default page size is 4096. Writes to statement journals are avoided. (check-in: 456df3365e user: drh tags: sessions) | |
| 14:57 | Merge recent enhancements from trunk, and especially the changes that reduce the heap-memory footprint of schemas, and defer opening and writing to statement journals. (check-in: 2f0c195ccc user: drh tags: apple-osx) | |
| 14:43 | Defer opening and writing statement journals until the size reaches a threshold (currently 64KiB). (check-in: cb9302cca4 user: drh tags: trunk) | |
| 14:23 | Update test cases to taken deferred statement-journal opening into account. (Closed-Leaf check-in: 5b2fe5219a user: drh tags: memjournal-exp) | |
| 13:08 | Merge changes from trunk. (check-in: a87305dfd4 user: drh tags: memjournal-exp) | |
| 04:01 | Change the default cache_size to -2000 (which means 2000*1024 bytes independent of page_size). (check-in: 2682e8e413 user: drh tags: trunk) | |
| 03:43 | Change the default page size for new database files to 4096 (from 1024). Except, when building the testfixture, preserve the legacy page size. Also fix a comment on SQLITE_MAX_ATTACHED. (check-in: 2e8a9ca9d3 user: drh tags: trunk) | |
| 03:20 | Detect the presence of pread()/pwrite() system calls on unix systems and use them if available. (check-in: 82cbf5ad2e user: drh tags: trunk) | |
| 03:14 | Further fixes to the pread()/pwrite() enabling logic. (Closed-Leaf check-in: 38fb54e785 user: drh tags: pread) | |
| 03:02 | Fix the build for cases when pread()/pwrite() are not available. (check-in: 7d67d876b7 user: drh tags: pread) | |
| 02:59 | Add the test_bestindex.c file to Makefile.in and Makefile.msc so that "make test" will work again. (check-in: 6ec6b6a97e user: drh tags: trunk) | |
| 02:38 | Update the configure script to detect pread/pwrite and update os_unix.c to use those routines if they are available. (check-in: 2cffb9e50b user: drh tags: pread) | |
| 00:13 | Get in-memory subjournals working for builds without SQLITE_ENABLE_ATOMIC_WRITE. (check-in: b5378dcea5 user: drh tags: memjournal-exp) | |
|
2016-03-03
| ||
| 21:29 | Merge the latest updates from trunk. (check-in: 55c00f716d user: drh tags: memjournal-exp) | |
| 21:22 | Reduce the amount of heap memory required to store many schemas by storing the column datatype appended to the column name (with a \000 separator), rather than in separate memory allocation. (check-in: 16fbf2e19c user: drh tags: trunk) | |
| 20:42 | Allow the left-hand side of IN operators on virtual tables to have the aConstraintUsage[].omit flag clear. (check-in: 3eb7434274 user: drh tags: trunk) | |
| 17:54 | Merge 3.11.1 changes into trunk. (check-in: 7abc2dd953 user: drh tags: trunk) | |
|
2016-03-02
| ||
| 17:57 | Add new test script bestindex1.test to the utf16 permutation. (Closed-Leaf check-in: 5893e97244 user: dan tags: vtab-IN-opt) | |
| 16:13 | Add an extra test for the change on this branch. (check-in: d2d2825156 user: dan tags: vtab-IN-opt) | |
| 16:01 | Enhance test_bestindex.c so that it can be used to test plans generated by xBestIndex. (check-in: 3c15a9bf45 user: dan tags: trunk) | |
| 03:28 | Allow the left-hand side of IN operators on virtual tables to have the aConstraintUsage[].omit flag clear. (check-in: 1622623cbb user: drh tags: vtab-IN-opt) | |
| 00:58 | Add the optional -DSERIES_OMIT_CONSTRAINT_VERIFY=0 option to the series.c extension that implements the generate_series() virtual table. (check-in: 3d9daa929c user: drh tags: trunk) | |
|
2016-03-01
| ||
| 22:48 | New test cases and infrastructure for testing the xBestIndex method of virtual tables. (check-in: 1d41c16116 user: drh tags: trunk) | |
| 22:41 | Improved debugging output with wheretrace. Fix some typos in test script comments. (check-in: 13a37fd487 user: drh tags: trunk) | |
| 18:35 | Fix a memory leak in the test code on this branch. (Closed-Leaf check-in: 7a1add5634 user: dan tags: test-bestindex) | |
| 18:24 | Allow test_bestindex.c to set the omit flag for a constraint. (check-in: 759b9d5b22 user: dan tags: test-bestindex) | |
| 18:07 | Add test code useful for testing the planners use of teh virtual table xBestIndex() method. (check-in: de034c0db6 user: dan tags: test-bestindex) | |
| 14:31 | Change the estimated row counts in stat1 to be one-third worst-case and two-threads average case. (check-in: 21bfd47c42 user: drh tags: analyze-worst-case) | |
| 12:45 | Fix test cases to align with the improved stats computation. (check-in: 810967bff6 user: drh tags: analyze-worst-case) | |
| 02:11 | Better estimatedCost in the xBestIndex method of the generate_series vtab. (check-in: f2c16094a5 user: drh tags: trunk) | |
|
2016-02-29
| ||
| 23:02 | Improvements to the logic for adding the "noskipscan" flag to stat1 entries. (check-in: 421b5b544a user: drh tags: analyze-worst-case) | |
| 21:27 | The ANALYZE command automatically appends "noskipscan" to sqlite_stat1 entries that have large worst-case repeat estimates but small average repeat estimates. (check-in: 6326ba5891 user: drh tags: analyze-worst-case) | |
| 20:18 | When using a temporary file for a statement journal, store the first 64KiB in memory. If the file grows larger than that, flush it to disk and free the memory. Hardcoding to 64KiB is just an experiment to check that the memjournal.c code works. (check-in: 44b2dc18e2 user: dan tags: memjournal-exp) | |
| 20:00 | Fix minor problems with new code in memjournal.c. (check-in: 9fd3f7b9c9 user: dan tags: memjournal-exp) | |
| 18:30 | Modify the ANALYZE command to store worst-case statistics in sqlite_stat1, rather thn average case. (check-in: 5a0143c94e user: drh tags: analyze-worst-case) | |
| 17:34 | Fix a problem in fts5 where a corrupt db could lead to a (huge) buffer overread. (check-in: c9a30e117f user: dan tags: trunk) | |
| 17:16 | Fix an fts5 problem causing 'optimize' to corrupt the fts index under some circumstances. (check-in: 251d6473f7 user: dan tags: trunk) | |
| 15:53 | Reduce the amount of heap required to store many schemas by storing each column datatype appended to the column name, rather than as a separate allocation. (Closed-Leaf check-in: 842b211627 user: drh tags: schema-storage) | |
| 13:44 | Very minor improvement to the performance and reduction in size to the parser by capturing the name and datatype of table columns in a single grammar rule reduction. (check-in: 4b55c520f5 user: drh tags: trunk) | |
| 13:37 | Further simplifications to the grammar. (Closed-Leaf check-in: 519fd03b84 user: drh tags: schema-storage) | |
|
2016-02-27
| ||
| 23:25 | Update the parser so that it pulls out the column name and type all in one go, rather than using separate reductions. (check-in: ad3ffe2eec user: drh tags: schema-storage) | |
| 21:16 | Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. (check-in: d8c94a46df user: drh tags: trunk) | |
| 20:14 | Extend the code in memjournal.c so that it subsumes the role of journal.c. And (untested) can flush journal or statement journal files to disk after they grow to a specified size. (check-in: e0b0b43165 user: dan tags: memjournal-exp) | |
| 19:19 | Tighter description of I/O stats in the shell. Show I/O stats on speedtest1.c. (check-in: f681d80034 user: drh tags: trunk) | |
| 19:03 | More compact implementation of PRAGMA onconflict, and some test cases. (Leaf check-in: 3e5d38f5b3 user: drh tags: pragma-onconflict) | |
| 17:16 | Experimental "PRAGMA onconflict=FAIL" statement to change the default ON CONFLICT algorithm to something other than ABORT. (check-in: 3a0c347cca user: drh tags: pragma-onconflict) | |
| 17:12 | Enhance the ".stats" command in sqlite3.exe to show one-time stats information if invoked with one argument. Also show /proc/PID/io information if run on Linux. (check-in: 3c36948f16 user: drh tags: trunk) | |
| 14:04 | Fix a requirement mark to conform to a typo fix in the documentation. (check-in: d1392c6279 user: drh tags: trunk) | |
| 14:00 | Enhance documentation of sqlite3_snapshot_open() to explain that the database connection must have participated in at least one read operation prior to the beginning of the transaction for which the snapshot is to be opened. Add test cases for this fact. (check-in: 33dd671cb9 user: drh tags: trunk) | |
| 00:21 | Add 'Replace.exe' to the MSVC clean target. (check-in: c2277fab12 user: mistachkin tags: trunk) | |
| 00:21 | Fix typo in ICU error message. (check-in: 00c8fffd47 user: mistachkin tags: trunk) | |
| 00:07 | Make sure the Replace.cs file is included in the autoconf tarball. (check-in: b850df483d user: drh tags: trunk) | |
|
2016-02-26
| ||
| 23:13 | Support generating the '.def' file using the autoconf Makefile for MSVC. (check-in: 3617564cb6 user: mistachkin tags: trunk) | |
| 21:20 | Fix a potential buffer overflow in the ICU upper() function. (check-in: b8dc1b9f5d user: drh tags: trunk) | |
| 21:03 | Further refinements to the MSVC batch build process. (check-in: cf4e4fbdb6 user: mistachkin tags: trunk) | |
| 16:14 | Merge all recent enhancements from trunk, and in particular the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER change. (check-in: 4fb4aee83d user: drh tags: apple-osx) | |
| 16:03 | Fix the ICU extension LIKE function so that it does not read past the end of a buffer if it it passed malformed utf-8. (check-in: 424b7aee33 user: dan tags: trunk) | |
| 15:38 | Provide the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to sqlite3_db_config() that can be used to activate the two-argument version of fts3_tokenizer() for a specific database connection at run-time. (check-in: 374b510808 user: drh tags: trunk) | |
| 13:22 | Fix a typo in a comment (though an important comment in that it is used to generate documentation). (check-in: ff3d7f845e user: drh tags: trunk) | |
| 04:13 | Ephemeral tables used to hold manifested views may not be unordered since they might be subject to an ordered comparison if they are part of a join. (check-in: 3ef6a31532 user: drh tags: trunk) | |
| 04:04 | Remove a debugging "exit" command mistakenly left in the "where.test" module. (check-in: beda0b8c76 user: drh tags: trunk) | |
|
2016-02-25
| ||
| 23:27 | Add some comments in the VSIX test tool. (check-in: c871473ffe user: mistachkin tags: trunk) | |
| 23:25 | Add tool for smoke-testing the UWP VSIX package. (check-in: d27f32c6d7 user: mistachkin tags: trunk) | |
| 23:22 | Enhance checking of prerequisites in the vsixtest tool. (Closed-Leaf check-in: 799d5f09ed user: mistachkin tags: vsixTest) | |
| 23:21 | Fix an incorrect cost computation for sorting (introduced just a few check-ins ago). Should be NlogN, not NloglogN. (check-in: 2459d32388 user: drh tags: trunk) | |
| 21:38 | Small optimization in FK handling. (check-in: e0d25913b7 user: mistachkin tags: trunk) | |
| 21:27 | Change the srcck1.c utility program to use only unsigned characters. (check-in: d64d005eb5 user: drh tags: trunk) | |
| 21:19 | Change the "PRAGMA stats" command to report size values in LogEst units. The eliminates the need for sqlite3LogEstToInt() unless non-standard compile-time options are used, so leave it out except in those cases. (check-in: 832c237fcb user: drh tags: trunk) | |
| 20:17 | Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. (check-in: 9ffff484bb user: dan tags: trunk) | |
| 19:52 | Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. (check-in: 8fea116601 user: dan tags: sessions) | |
| 18:54 | Merge all the latest changes from trunk. (check-in: b86590043e user: drh tags: sessions) | |
| 18:40 | Query planner improvements: Take the LIMIT into account when estimated the cost of an ORDER BY. Avoid automatic indexes on query loops that are expected to run less than twice. See [9e2b2681] for a later enhancement. (check-in: bf46179d44 user: drh tags: trunk) | |
| 18:22 | Improvement on the previous check-in: disallow automatic indexes for any loop that is expected to run less than twice. (Closed-Leaf check-in: aab53a2189 user: drh tags: planner-improvements) | |
| 18:03 | Do not use an automatic index on an outer loop that only runs once. (check-in: 5957e79341 user: drh tags: planner-improvements) | |
| 16:04 | Take the LIMIT clause into account when estimating the cost of sorting. (check-in: d491745cab user: drh tags: planner-improvements) | |
| 13:33 | In the command-line shell: When the ".import" command is creating a new table using column names from the first row of CSV input, make sure double-quotes in the name are properly escaped. (check-in: 2e67a1c823 user: drh tags: trunk) | |
| 08:02 | Improve readability and logging of the vsixtest script. (check-in: 4fe7c4e90b user: mistachkin tags: vsixTest) | |
| 02:56 | Enable all steps and add/update comments. (check-in: 788f99f47f user: mistachkin tags: vsixTest) | |
| 02:49 | More work. Install and build steps are now tested. (check-in: 0ab74373bd user: mistachkin tags: vsixTest) | |
|
2016-02-24
| ||
| 23:31 | Fix typo. Improve interim debugging. (check-in: e0029bdf20 user: mistachkin tags: vsixTest) | |
| 23:25 | Test build all supported configurations and platforms during VSIX testing. (check-in: cce40a0b8e user: mistachkin tags: vsixTest) | |
| 21:42 | Initial work on an automated VSIX testing tool. Not working or tested yet. (check-in: 496e4ac984 user: mistachkin tags: vsixTest) | |
| 20:16 | Extend [3e9ed1ae] so that covering indexes on WITHOUT ROWID tables are also identified. (check-in: e721975faa user: dan tags: trunk) | |
| 19:57 | Change a char* to const char* in order to suppress some harmless compiler warnings. (check-in: 56f62e34ae user: drh tags: trunk) | |
| 17:18 | When an index completely covers a table, it can be used as a covering index even if columns past the 63rd column are indexed and accessed. (check-in: 3e9ed1aea4 user: drh tags: trunk) | |
| 16:14 | Fix a problem with handling identifiers that start with "x" if SQLITE_OMIT_BLOB_LITERAL is defined. (check-in: b65217c69c user: dan tags: trunk) | |
| 15:43 | Identify indexes that completely cover their table. (Closed-Leaf check-in: 71d488b599 user: drh tags: covering-index) | |
| 13:35 | LSM1: Fix the integer key encoding so that negative keys are in numeric order. (check-in: f92dc4187f user: drh tags: lsm-vtab) | |
|
2016-02-23
| ||
| 16:28 | Add the SQLITE_BITMASK_TYPE compile-time option. (check-in: 0064a8c77b user: drh tags: trunk) | |
| 01:41 | Merge trunk enhancements. (check-in: fac4f4ecee user: drh tags: lsm-vtab) | |
| 01:37 | Add support for (variable length) integer keys in LSM1. (check-in: 32f3daec0a user: drh tags: lsm-vtab) | |
|
2016-02-22
| ||
| 23:44 | Remove code not needed now that synchronous=OFF database files no longer trigger the use of a master journal. (check-in: aa9f4c622a user: drh tags: trunk) | |
| 23:14 | Avoid an unnecessary seek operation some corner-case skip-scan operations. (check-in: 2a6003a937 user: drh tags: trunk) | |
| 21:19 | Clearer presentation of the logic. No functional changes. (Closed-Leaf check-in: a3dcf6db76 user: drh tags: skip-scan-improvement) | |
| 20:52 | Avoid an unnecessary seek operation on some corner-case skip-scans. (check-in: 38e837e605 user: drh tags: skip-scan-improvement) | |
| 16:32 | Merge the master-journal optimization and other recent changes from trunk. (check-in: 18c3ab4784 user: drh tags: apple-osx) | |
| 16:04 | Always use the sqlite3VdbeDeleteAuxdata() routine for clearing auxdata on function parameter, rather than having a separate deleteAuxdataFromFrame() for doing the job for trigger frames. (check-in: 64386fa339 user: drh tags: trunk) | |
| 14:57 | Avoid creating a master journal unless two or more databases in the transaction can actually benefit from that master journal. (check-in: 3ed1890612 user: drh tags: trunk) | |
| 13:23 | Change magic numbers associated with synchronous settings to named constants. (check-in: 9230ba6c01 user: drh tags: trunk) | |
| 13:01 | Merge up to trunk. (check-in: f9e5fb88a5 user: drh tags: lsm-vtab) | |
| 09:45 | Add an extra test case for the change in commit [c4295725]. (check-in: a48ac4c347 user: dan tags: trunk) | |
|
2016-02-19
| ||
| 19:46 | Further enhancements to the MSVC batch build tool. (check-in: 06f1495f4b user: mistachkin tags: trunk) | |
| 18:54 | Use a separate list of aux-data structures for each trigger program at the VDBE level. Fix for [dc9b1c91]. (check-in: c429572501 user: dan tags: trunk) | |
| 16:19 | Enhance speedtest1 to display the particular version of SQLite under test. (check-in: 0cb728c15c user: drh tags: trunk) | |
| 15:17 | Fix a couple of harmless warnings generated by clang. (check-in: a1a3ff1f53 user: drh tags: trunk) | |
| 14:20 | Fix a harmless uninitialized variable access. (check-in: 398522e686 user: drh tags: trunk) | |
| 14:10 | Make sure WhereClause objects are fully initialized before use when planning OR queries. (check-in: 1620530217 user: drh tags: trunk) | |
| 13:29 | Fix (harmless) compiler warnings in some of the TCL-based test code. (check-in: 7c26d2b470 user: drh tags: trunk) | |
| 13:20 | Add an SQLITE_DISABLE_INTRINSIC #ifdef to the sqlite3Put4Byte() function. (check-in: ba9c6827d0 user: drh tags: trunk) | |
| 13:19 | Omit the unused yyzerominor constant. (check-in: 60ad68a9f5 user: drh tags: trunk) | |
| 10:18 | Add an "#ifndef SQLITE_AMALGAMATION" guard around a typedef in fts5_test_mi.c to avoid redefining "u32" if it is compiled as part of the amalgamation. (check-in: f9c49ba1ed user: dan tags: trunk) | |
| 00:48 | Further improvements to the MSVC batch build tool. (check-in: b9626b5954 user: mistachkin tags: trunk) | |
|
2016-02-18
| ||
| 21:15 | Correct the install location for the UWP VSIX package. (check-in: f74de325ff user: mistachkin tags: trunk) | |
| 14:53 | Merge the tokenizer buffer overrun bug-fix from trunk. (check-in: 82e7e31b09 user: drh tags: apple-osx) | |
| 14:49 | Avoid a potential buffer overrun if an SQL statement being parsed ends with an illegal "!" token. (This problem was detected by fuzzcheck running under valgrind. The problem was introduced by check-in [9570b6b43df3], two days ago and has not appeared in a release.) (check-in: 2a8d97e7c8 user: drh tags: trunk) | |
| 14:03 | Improved handling of the -v option on the fuzzcheck test program. (check-in: c8cd7804dc user: drh tags: trunk) | |
| 13:32 | Remove an unnecessary "include <tcl.h>" line from fts5_test_mi.c. (check-in: 31d8b69e9e user: dan tags: trunk) | |
| 01:36 | Merge recent performance enhancements and the enhanced API_ARMOR from trunk. (check-in: b7fa0fb339 user: drh tags: apple-osx) | |
| 01:29 | Add extra API armor on the sqlite3_bind_blob() interface. (check-in: 80de1ad5eb user: drh tags: trunk) | |
|
2016-02-17
| ||
| 20:47 | When VDBE opcodes fail, they cause an immediate exit from the loop, rather than depending on the rc==SQLITE_OK test at the top of the loop. This is faster and smaller. (check-in: 24c7151c1a user: drh tags: trunk) | |
| 18:44 | Fix up all VDBE opcodes so that they cause an immediate exit on any kind of error, and thereby eliminate the need to test "rc" at the top of the loop. Resulting code is a little smaller and faster. (Closed-Leaf check-in: a444633a82 user: drh tags: vdbe-performance) | |
| 15:01 | Bump the version number to 3.12.0. (check-in: c17d7276b8 user: drh tags: trunk) | |
| 14:48 | Remove the "#ifdef SQLITE_TEST" condition from fts5_test_mi.c. Update fts5_main.c so that if SQLITE_FTS5_TEST_MI is defined when it is built the fts5_test_mi.c entry point is automatically called. This makes it easier to build versions of fts5 that include the matchinfo() demo by default. (check-in: 87e6e225ae user: dan tags: trunk) | |
| 14:11 | Improve test coverage of demo code in fts5_test_mi.c. (check-in: 8a78050dc0 user: dan tags: trunk) | |
| 13:24 | Enhance Lemon to generate more compact and efficient code for yy_reduce(). Update the main SQL grammar to take advantage of the new capabilities. (check-in: 53fd040c98 user: drh tags: trunk) | |
| 12:34 | More agressive use of /*A-overwrites-X*/ in the parser. Fix an off-by-one error in parser stack overflow detection. (Closed-Leaf check-in: 417e777701 user: drh tags: parser-performance) | |
| 11:13 | Documentation typo on sqlite3_wal_hook(). No changes to code. (check-in: fc2043ebaa user: drh tags: trunk) | |
| 04:33 | Enhance Lemon so that if reduce code contains a comment of the form "/*A-overwrites-X*/" then a LHS label A is allowed to overwrite the RHS label X. (check-in: 5cfe9545d4 user: drh tags: parser-performance) | |
| 01:46 | Further improvements to the Lemon-generated code for yy_reduce(). (check-in: ef95a7d649 user: drh tags: parser-performance) | |
| 01:18 | In Lemon, add the ability for the left-most RHS label to be the same as the LHS label, causing the LHS values to be written directly into the stack. (check-in: 4bb94c7c4c user: drh tags: parser-performance) | |
|
2016-02-16
| ||
| 21:19 | Experimental changes to Lemon for improved parser performance. (check-in: a65d583ce9 user: drh tags: parser-performance) | |
| 13:04 | Minor simplification to the tokenizer. Slightly smaller and faster. (check-in: 9570b6b43d user: drh tags: trunk) | |
| 01:01 | Improve the Lemon parser template (lempar.c) so that it avoids unnecessary work when the grammer defines YYNOERRORRECOVERY (as SQLite does). Slightly smaller and faster code results. (check-in: 9235b0cf6a user: drh tags: trunk) | |
|
2016-02-15
| ||
| 23:46 | Fix a harmless compiler warning in FTS5. (check-in: e52c90758c user: drh tags: trunk) | |
| 22:37 | Readability improvements for winRandomness. (check-in: 1640f814c7 user: mistachkin tags: trunk) | |
| 22:28 | Fix comment. No changes to code. (check-in: 2e1f2eff27 user: mistachkin tags: trunk) | |
| 22:01 | Revise compiler checks for the rand_s() function. (check-in: 287f508dd6 user: mistachkin tags: trunk) | |
| 21:31 | On windows systems when rand_s() is available, use it to obtain additional seed material in winRandomness(). (check-in: 139081bef9 user: drh tags: trunk) | |
| 20:41 | Improved entropy gathering for the implementation of winRandomness(). (check-in: fea3705e77 user: drh tags: trunk) | |
| 19:38 | Add working -q and --help options to testfixture. (check-in: 404494e52b user: drh tags: trunk) | |
| 18:58 | In the tool/warning.sh script, disable Android-specific compiler warning tests when not running on Linux. (check-in: 153f01a821 user: drh tags: trunk) | |
| 18:47 | Fix harmless compiler warnings previously seen in 64-bit MSVC builds. (check-in: 7026246300 user: drh tags: trunk) | |
| 18:15 | Add the SQLITE_NOMEM_BKPT macro to enhance the ability to debug OOM errors. Only effective with compiling with SQLITE_DEBUG. (check-in: 9b3454762d user: drh tags: trunk) | |
| 18:02 | Minor code simplifications. (check-in: c3b38efd50 user: drh tags: trunk) | |
| 17:56 | Make the application-defined SQL function logic more compact and faster, especially faster for the case where an application defines thousands of new SQL functions. (check-in: 7d49ed32a7 user: drh tags: trunk) | |
| 17:29 | Version 3.11.0 (check-in: 3d862f207e user: drh tags: trunk, release, version-3.11.0) | |
| 15:06 | Make sure the codec is invoked when overwriting existing frames of the WAL file. Yikes! (check-in: f694e60a79 user: drh tags: trunk) | |
| 00:34 | Improvements to the application-defined function mechanism so that it is more compact and runs faster, especially when the application defines thousands of new SQL functions. (Closed-Leaf check-in: 3201fbcc51 user: drh tags: many-app-functions) | |
|
2016-02-14
| ||
| 00:14 | Update a comment. (Closed-Leaf check-in: e9753d9a2c user: mistachkin tags: noMemBkpt) | |
|
2016-02-13
| ||
| 23:43 | Enhance ability to debug out-of-memory errors. (check-in: 6a9c4a3ebf user: mistachkin tags: noMemBkpt) | |
| 18:54 | Provide Sqlite3_SafeInit() and Sqlite3_SafeUnload() entry points on the TCL interface, but have the always return TCL_ERROR, because the non-standard TCL builds on Macs require this. (check-in: 37ec3015ec user: drh tags: trunk) | |
|
2016-02-12
| ||
| 18:48 | Fix a potential buffer overread provoked by invalid utf-8 in fts5. (check-in: a049fbbde5 user: dan tags: trunk) | |
| 17:56 | Fix a fairly obscure buffer overread in fts5. (check-in: 130580207a user: dan tags: trunk) | |
| 17:30 | Fix a documentation typo. No changes to code. (check-in: d9c985878c user: drh tags: trunk) | |
| 17:27 | Enhance mptester so that it takes great care to delete its test database prior to start-up, including checking the return code from unlink() and retrying after a delay if unlink() fails. Hopefully this will clear intermittant startup problems on Windows. (check-in: 6ea84ec1e0 user: drh tags: trunk) | |
| 05:19 | Naming updates for Universal Windows Platform. (check-in: 717c1fc41a user: mistachkin tags: trunk) | |
| 00:13 | Remove an unused parameter from whereSortingCost(). (check-in: b5d7719916 user: drh tags: trunk) | |
|
2016-02-11
| ||
| 22:41 | Automatically disable FTS3 and FTS4 when building with SQLITE_OMIT_VIRTUALTABLE. (check-in: 0beb32d20d user: drh tags: trunk) | |
| 21:59 | Enhance the MSVC makefile to enable building 'testfixture' fully from source code. (check-in: f183e05990 user: mistachkin tags: trunk) | |
| 21:55 | Remove the unexplained extra 3.0 cost factor for the B-tree sorting that is done to implement DISTINCT in the absence of an index to help. (check-in: 52571991fc user: drh tags: trunk) | |
| 21:53 | Remove the unused fts5BlobCompare() routine. (check-in: defc762dd1 user: drh tags: trunk) | |
| 21:38 | Prevent 'expanded command line X too long' errors during the batch 'for' loops used for copying files. (Closed-Leaf check-in: 67ee9b5af1 user: mistachkin tags: testFixtureSrc) | |
| 21:28 | Enhance the MSVC makefile to enable building 'testfixture' fully from source code. (check-in: 54ff3a26bc user: mistachkin tags: testFixtureSrc) | |
| 18:18 | Fix another unused variable warning in fts5 code. (check-in: 61b4c12054 user: dan tags: trunk) | |
| 18:08 | Avoid a buffer overread when reading a corrupt fts5 structure record. (check-in: facbc424e5 user: dan tags: trunk) | |
| 17:01 | Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. (check-in: bc3f7900d5 user: dan tags: trunk) | |
| 15:37 | Add JSON1 and FTS5 to the set of extensions subject to close compiler warning analysis. Fix some warnings in each. More (harmless) warnings still exist in FTS5. (check-in: cfe2eb88b5 user: drh tags: trunk) | |
| 13:30 | Minor simplifications deferred to the next release. (Closed-Leaf check-in: a863729ccb user: drh tags: simplify) | |
|
2016-02-10
| ||
| 21:45 | In the MSVC makefile, include the working directory so that it can pickup build generated files (e.g. sqlite3.h, etc). (check-in: e9e6000bd2 user: mistachkin tags: trunk) | |
| 19:10 | Add testcase() macros to the CHECK constraint avoidance logic. Avoid creating an unused VDBE label during CHECK constraint code generation. (check-in: 970881befd user: drh tags: trunk) | |
| 18:24 | Fix to previous check-in: Make sure CHECK constraints involving the ROWID are not ignored when the ROWID changes. (check-in: 7782cb1dd5 user: drh tags: trunk) | |
| 16:52 | Omit unnecessary CHECK constraints in UPDATE statements, when none of the columns referenced in the CHECK constraint are modified. (check-in: 02fbdbc782 user: drh tags: trunk) | |
| 16:03 | Omit NOT NULL checks on unchanging columns in an UPDATE. (check-in: 6a3aaedfb4 user: drh tags: trunk) | |
| 13:36 | When generating the snapshot-tarball, truncate the date/time in the name to 12 significant digits (YYYYMMDDhhmm) omitting the seconds and fractional seconds. (check-in: 604f777547 user: drh tags: trunk) | |
| 13:17 | Updates to the autoconf tarball README.txt file. (check-in: a3e911e3aa user: drh tags: trunk) | |
|
2016-02-09
| ||
| 22:54 | Update the snapshot tarball name to use the date (ISO8601 format) instead of the SHA1 hash in its name. (check-in: 070ec66f67 user: drh tags: trunk) | |
| 22:39 | Add the new "snapshot-tarball" target to the unix makefiles, for building a tarball similar to "amalgamation-tarball" but named by the SHA1 hash of the current check-out rather than by the version number. (check-in: 4f360b2ae7 user: drh tags: trunk) | |
| 22:00 | Update the MSVC autoconf makefile with the recent changes from the primary one. (check-in: c7242aa3e9 user: mistachkin tags: trunk) | |
| 20:37 | Fix the makefiles in the autoconf-tarball so that they build the command-line shell with SQLITE_ENABLE_EXPLAIN_COMMENTS. (check-in: 1135ad014a user: drh tags: trunk) | |
| 20:31 | In the shell, use the appropriate string constant instead of a literal new-line. (check-in: 61951b153d user: mistachkin tags: trunk) | |
| 20:11 | Enhance the command-line shell to be in auto-explain mode by default. It is no longer necessary to use the ".explain" command to put the shell into a mode where the EXPLAIN output is formatted nicely. That now happens automatically. (check-in: 751915cb7e user: drh tags: trunk) | |
| 20:04 | Improved auto-detection of EXPLAIN output in the shell. (Closed-Leaf check-in: 6c6d7a6e89 user: drh tags: auto-explain) | |
| 18:39 | Add auto-explain mode to the command-line shell. Default on. Auto-explain tries to automatically detect EXPLAIN queries and format them appropriately. (check-in: 1d62aa6b31 user: drh tags: auto-explain) | |
| 18:28 | Fix MSVC makefile options that enable control-flow guard. (check-in: 51b6823f4c user: mistachkin tags: trunk) | |
| 17:12 | Fix the top-level makefiles to always include SQLITE_ENABLE_EXPLAIN_COMMENTS when building the shell. Still need to fix main.mk and the amalgamation tarball. (check-in: 992282399c user: drh tags: trunk) | |
| 16:09 | Code simplification: ALTER TABLE ADD COLUMN always upgrades the file_format to 4 if is not there already. No need to upgrade to only 2 or 3 since format 4 has now been supported for over 10 years. (check-in: e1d8ec8554 user: drh tags: trunk) | |
| 02:12 | Make sure every co-routines has its own set of temporary registers and does not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. (check-in: ca72be8618 user: drh tags: trunk) | |
|
2016-02-08
| ||
| 20:45 | Fix spelling error in MSVC makefile comments. (check-in: 6eab74c9ae user: mistachkin tags: trunk) | |
| 20:40 | More work on Windows 10 SDK integration. (check-in: 1e563c6ebb user: mistachkin tags: trunk) | |
| 20:14 | Fix a signed/unsigned comparison warning in fts5. (check-in: 85eb05ddbc user: dan tags: trunk) | |
| 20:06 | Fix a compiler warning when compiling without SQLITE_ENABLE_FTS3_TOKENIZER. (check-in: 6926f28cd5 user: drh tags: trunk) | |
| 19:40 | Disable the two-argument form of the fts3_tokenizer() SQL function unless the library is built with -DSQLITE_ENABLE_FTS3_TOKENIZER. (check-in: e0eb217aca user: dan tags: trunk) | |
| 19:36 | Changes to help the tokenizer run about 33% faster. (check-in: a050e6f096 user: drh tags: trunk) | |
| 19:15 | Add code to get the tokenizer character-class logic working for EBCDIC. (Closed-Leaf check-in: 04f7da77c1 user: drh tags: tokenizer-char-class) | |
| 03:23 | Faster keywordCode() implementation by taking advantage of the fact that the input is always pure ASCII alphabetic and underscore and that the keyword table is always upper-case. (check-in: ff406b9701 user: drh tags: tokenizer-char-class) | |
| 02:30 | Demonstrate a much faster sqlite3GetToken() routine by using a lookup table to map initial token characters into a character class. This check-in does not work for EBCDIC. More optimization needed. (check-in: 9115baa191 user: drh tags: tokenizer-char-class) | |
|
2016-02-07
| ||
| 20:39 | Fix harmless compiler warning in 'srcck1' tool and add it to the clean targets. (check-in: 852a529a8b user: mistachkin tags: trunk) | |
| 00:08 | Add the sourcetest target to Makefile.msc. (check-in: ab269e7205 user: drh tags: trunk) | |
|
2016-02-06
| ||
| 22:32 | Add a utility program that looks for assert(), NEVER(), ALWAYS(), and testcase() macros that have side-effects, and reports errors when they are found. Also fix a bug that this utility detected as it was being tested. (check-in: b0b4624fc5 user: drh tags: trunk) | |
| 19:48 | Make sure variable declarations occur at the beginning of blocks, even with SQLITE_DEBUG enabled. (check-in: 2f7778e64d user: drh tags: trunk) | |
| 14:14 | Fix an assert() to have a test instead of a side effect (check-in: a2952231ac user: pdr tags: trunk) | |
|
2016-02-05
| ||
| 21:09 | Add tests for and remove unreachable branches from fts5 in order to restore test coverage. (check-in: 22589018ac user: dan tags: trunk) | |
| 19:40 | More work on Windows 10 SDK integration. (Closed-Leaf check-in: ebace2c99b user: mistachkin tags: win10sdk) | |
| 19:18 | Further streamlining of fts5 prefix query code. (check-in: ca91bd8ac7 user: dan tags: trunk) | |
| 17:49 | Make sure the "bak.db" database file does not actually exist before starting the "quota.test" testing. (check-in: 1cac6c45ee user: drh tags: trunk) | |
| 16:46 | From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. (check-in: a6b3527323 user: drh tags: trunk) | |
| 14:11 | Improvements to the way out-of-memory conditions are handled, resulting in an almost 1% performance gain in the commmon case where OOM errors do not occur. (check-in: b082538da7 user: drh tags: trunk) | |
| 13:38 | Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority cases where db is guaranteed to be not NULL. (Closed-Leaf check-in: 0a802e96ab user: drh tags: oom-handling) | |
| 04:55 | Improve ERRORLEVEL handling in the MSVC batch build tool sub-routine 'fn_UnsetVariable'. (check-in: fe123ab4f1 user: mistachkin tags: trunk) | |
| 04:50 | OOM failures on sqlite3_errmsg16() in an app-defined function are no longer benign. (check-in: 9efb223f4c user: drh tags: oom-handling) | |
| 04:39 | Another small tweak to the MSVC batch build tool. (check-in: 76718bbce7 user: mistachkin tags: trunk) | |
| 02:50 | Minor simplification of schema error reporting. (check-in: a8846aeed9 user: drh tags: oom-handling) | |
| 02:42 | Further performance improvements that fall out of the mallocFailed changes. (check-in: d94416ddca user: drh tags: oom-handling) | |
| 01:55 | Improvements to the way that OOM errors are processed. (check-in: c3ef03478a user: drh tags: oom-handling) | |
|
2016-02-04
| ||
| 19:50 | Temporarily back out the 0.5% performance improvement from check-in [632071bac5ff32]. Need a more elaborate solution that works with reentrant virtual tables and SQL functions. (check-in: 42736fb0ad user: drh tags: trunk) | |
| 19:45 | Further improve performance of unindexed fts5 prefix queries. (check-in: c9c6457d8e user: dan tags: trunk) | |
| 17:31 | Avoid running some particularly time-consuming tests as part of veryquick.test. (check-in: f465944b75 user: dan tags: trunk) | |
| 11:48 | Remove unnecessary sets of db->mallocFailed. (check-in: b787165b25 user: drh tags: trunk) | |
| 11:15 | Use sqlite3_malloc64() instead of sqlite3_malloc() in the spellfix extension. (check-in: 634d008c34 user: drh tags: trunk) | |
| 10:28 | Escape control characters in JSON. Fix for ticket [ad2559db380abf8]. (check-in: 4f1b5229a3 user: drh tags: trunk) | |
| 09:48 | Refinements to synchronous logic: (1) Use PAGER_SYNCHRONOUS_FULL rather than the corresponding magic number. (2) Honor SQLITE_NO_SYNC on xDelete calls with sync (3) Count xDelete syncs during testing (4) Fix #ifs on SQLITE_EXTRA_DURABLE so that directory syncs on journal unlink are off by default. (check-in: e3157cb5ad user: drh tags: trunk) | |
|
2016-02-03
| ||
| 22:14 | In the VDBE loop, only check for OOM errors at jumps rather than after every opcode, for about a 0.5% performance increase. (check-in: 632071bac5 user: drh tags: trunk) | |
| 20:04 | Improve performance of fts5 prefix queries on detail=col tables. (check-in: ca11f46db0 user: dan tags: trunk) | |
| 19:52 | Fix markup errors in comments used to generate the documentation - specifically in the documentation on the OP_Seek opcode. (check-in: ef252bc4b5 user: drh tags: trunk) | |
| 19:20 | Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. (check-in: af92401826 user: drh tags: trunk) | |
| 01:55 | Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. (check-in: ae8b9d2edf user: drh tags: trunk) | |
|
2016-02-02
| ||
| 21:19 | Add tests to restore full coverage of fts5 code. (check-in: 063755c815 user: dan tags: trunk) | |
| 17:40 | Enhance the performance of fts5 AND and OR queries. (check-in: 62ea9e5ab8 user: dan tags: trunk) | |
| 02:04 | Enhance the comment on the sqlite3_index_constraint object to bring attention to the fact than iColumn field can be negative for a rowid. (check-in: d8b7b1996e user: drh tags: trunk) | |
|
2016-02-01
| ||
| 21:48 | Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. (check-in: 6d7d4703eb user: drh tags: trunk) | |
| 20:12 | Improve performance of fts5 queries. (check-in: 2334e88244 user: dan tags: trunk) | |
| 17:20 | Number VDBE opcodes starting with 0 instead of 1, as this obviates the lower-bound test on "switch(opcode){...}", making the code smaller and faster. (check-in: 4c9222f75b user: drh tags: trunk) | |
| 16:36 | Update walcrash.test to ensure that, during a particular test, enough data is written to cause SQLite to sync the wal file 14 times. (check-in: 5d7c092869 user: dan tags: trunk) | |
| 13:58 | Fix a problem causing the OR/covering-index optimization to be disabled if compile time parameter SQLITE_MAX_ATTACHED were set to greater than 30. (check-in: a17712bf8d user: dan tags: trunk) | |
| 13:21 | Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. (check-in: a9b6a0672f user: drh tags: trunk) | |
| 00:21 | Fix an assert() that might fail on a corrupt database. (check-in: 22eaced727 user: drh tags: trunk) | |
|
2016-01-30
| ||
| 21:09 | Fix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: a2810cf65d user: dan tags: trunk) | |
| 19:16 | Performance enhancement for fts5 column filter queries on detail=full tables. (check-in: 13fb4aa6a8 user: dan tags: trunk) | |
| 16:59 | Merge the implementation of OP_IdxRowid and OP_Seek so that OP_Seek no longer requires the rowid register and a separate OP_IdxRowid call. Shorter and faster prepared statements result. (check-in: 9bec50a1e7 user: drh tags: trunk) | |
| 15:52 | Only honor the register subtype value if the MEM_Subtype flag is set. Revised and improved fix for ticket [f45ac567eaa9f9]. (check-in: 1f4c667f37 user: drh tags: trunk) | |
| 15:46 | A different way to clear the subtype on VDBE registers when the value of the register is overwritten with new content. To fix [[f45ac567eaa9f93]. (Closed-Leaf check-in: 2e9fb1295c user: dan tags: clear-subtype-flag) | |
| 14:17 | Output subtype information on register traces for PRAGMA vdbe_trace. (check-in: 96b780209c user: drh tags: trunk) | |
| 13:32 | Add the BTREE_FORDELETE and BTREE_AUXDELETE flags to the b-tree layer interface and use them. Add assert() statement to verify that they are correct. (check-in: 85c467041c user: drh tags: trunk) | |
| 12:50 | Simplification and size reduction to the printf logic. Remove the bFlags parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. (check-in: 0bdb41c45a user: drh tags: trunk) | |
| 02:10 | Make use of covering indexes in the OR optimization. (check-in: 9de3d71230 user: drh tags: trunk) | |
| 00:45 | Change the P4_INTARRAY so that always begins with a length integer. Print the content of the INTARRAY on EXPLAIN output. (Closed-Leaf check-in: 6c520d5726 user: drh tags: covering-or) | |
|
2016-01-29
| ||
| 21:16 | Add tests for the change on this branch. (check-in: 7cb697f829 user: dan tags: covering-or) | |
| 20:58 | Different comment on the alternative cursor fields of VdbeCursor. (check-in: 6e3dcb6d7d user: drh tags: covering-or) | |
| 19:29 | Experimental attempt to make better use of covering indexes within OR queries. (check-in: a323ac3a9d user: dan tags: covering-or) | |
| 19:04 | Improvements to FORDELETE processing, including bug fixes and adding assert() statements to help verify correct operation. (Closed-Leaf check-in: 46080b0474 user: drh tags: btree-fordelete-flag) | |
| 18:48 | Remove a stray "exit" in a test script. (Closed-Leaf check-in: 10c88bf9f2 user: drh tags: fordelete-assert) | |
| 18:11 | Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint. (check-in: 512caa1ad3 user: drh tags: trunk) | |
| 18:04 | Prepend "rc!=SQLITE_OK || " to the nExtraDelete assert() condition. (check-in: 2a055ed0af user: dan tags: fordelete-assert) | |
| 16:57 | Avoid unnecessary WHERE clause term tests when coding a join where one of the tables contains a OR constraint. (Closed-Leaf check-in: ab94603974 user: drh tags: OR-clause-improvement) | |
| 08:38 | Avoid two more instances of pointer arithmetic on freed pointers. (check-in: 2910ef6409 user: dan tags: trunk) | |
|
2016-01-28
| ||
| 18:22 | Modify the order of terms in an "if" condition to avoid implicitly comparing a dangling pointer to NULL following an OOM error. (check-in: 5372f80083 user: dan tags: trunk) | |
| 17:06 | Modifications to ensure the nExtraDelete-related assert() statement does not fail. (check-in: f43ff8f82d user: dan tags: fordelete-assert) | |
| 08:58 | Remove a duplicate "p->magic = VDBE_MAGIC_RUN;" line from vdbeaux.c. (check-in: 688eb3b400 user: dan tags: trunk) | |
| 02:47 | Fix for pthread detection in the configure scripts. (check-in: 47633ffdbf user: drh tags: trunk) | |
| 00:04 | Minor correction to the batch tool changes in the previous check-in. (check-in: 7c89d75de1 user: mistachkin tags: trunk) | |
|
2016-01-27
| ||
| 23:50 | Make the MSVC batch build tool sub-routine 'fn_UnsetVariable' a bit more robust. (check-in: 1edd5f31b9 user: mistachkin tags: trunk) | |
| 16:26 | Change the name of the BTREE_IDXDELETE flag to BTREE_AUXDELETE, to better reflect its purpose. (check-in: 1d3bf6bebd user: drh tags: fordelete-assert) | |
| 16:17 | Fix tests in fordelete.test to test for the BTREE_AUXDELETE flag. (check-in: bbd25cf179 user: dan tags: fordelete-assert) | |
| 15:49 | Add assert() statements on the nExtraDelete variable in vdbe.c to try to verify that the FORDELETE and IDXDELETE flags are being generated correctly. Those flags are not currently generated correctly, and so the assert()s trip on this check-in. (check-in: dde1db0dd2 user: drh tags: fordelete-assert) | |
| 07:28 | Support building for Windows 10 desktop using 'MinCore.lib'. (check-in: 4bf89891fb user: mistachkin tags: trunk) | |
|
2016-01-26
| ||
| 23:32 | Merge all recent trunk enhancements. (check-in: 9a71d56dce user: drh tags: btree-fordelete-flag) | |
| 20:19 | Performance improvements for fts5, particularly detail=col mode. (check-in: a3d7b8ac53 user: dan tags: trunk) | |
| 20:08 | Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. (Leaf check-in: b4ac61aeee user: dan tags: fts5-perf) | |
| 19:30 | Improve the performance of fts5 column filters on detail=col tables. (check-in: 249a2d070c user: dan tags: fts5-perf) | |
| 17:08 | Enhance fts5txt2db.tcl, a script used to generate fts5/fts4 databases for performance testing. (check-in: c646e40350 user: dan tags: fts5-perf) | |
| 14:48 | Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. (check-in: 4003db4a49 user: dan tags: trunk) | |
| 13:56 | Ensure that unixFullpathname() always nul-terminates its output buffer, even when returning an error. (Closed-Leaf check-in: 4a4385564d user: dan tags: follow-symlinks) | |
| 00:12 | Remove an unused variable. (check-in: 1c2656c1d3 user: drh tags: follow-symlinks) | |
|
2016-01-25
| ||
| 23:24 | Add the ability to do Windows builds to the amalgamation tarball. (check-in: abd2b357c5 user: drh tags: trunk) | |
| 23:19 | Minor changes to the autoconf/README.txt file. (Closed-Leaf check-in: 6df8a9c00a user: drh tags: msvcMakeMin) | |
| 22:08 | Fix a compiler warning about doing pointer arithmetic involving a NULL pointer even though the result of computation is never used. (check-in: 7c49a9478b user: drh tags: trunk) | |
| 18:43 | Only use lstat() if the HAVE_LSTAT macro is defined. Fix some test file issues. (check-in: 8a6e4147a6 user: dan tags: follow-symlinks) | |
| 18:05 | Simplify the unixFullpathname() function. This adds a dependency on lstat(). (check-in: f71249d3db user: dan tags: follow-symlinks) | |
| 17:04 | Fix issues on unix with opening database files via symlinks that are not in the current working directory. And with nested symlinks. (check-in: 80398fd44f user: dan tags: follow-symlinks) | |
| 15:57 | Replace the OP_SetIfNotPos operator with OP_OffsetLimit in the VDBE, for simpler and smaller code. (check-in: 7ac017a498 user: drh tags: trunk) | |
| 13:55 | Add the SQLITE_EXTRA_DURABLE compile-time option. (check-in: 30671345b1 user: drh tags: trunk) | |
| 02:15 | Small simplification to the prepare statement opcode memory reuse logic. Easier to read, and slightly smaller and faster. (check-in: 8a1deae497 user: drh tags: trunk) | |
| 01:07 | Small simplification and performance improvement in memsys5Free(). (check-in: 0a9cff5c48 user: drh tags: trunk) | |
|
2016-01-23
| ||
| 22:55 | Add the SQLITE_SPELLFIX_STACKALLOC_SZ compile-time option to control how much stack space is available for use as the Wagner matrix in editDest3 of the spellfix extension. (check-in: dd0100dd87 user: drh tags: trunk) | |
| 21:57 | More updates to the README. (check-in: 9f02868df7 user: mistachkin tags: msvcMakeMin) | |
| 20:43 | Updates to the autoconf README file. (check-in: 4ce60fa42d user: drh tags: msvcMakeMin) | |
| 20:34 | Move Makefile.min.msc into the autoconf subdir where it belongs and change its name to Makefile.msc. Adjust build scripts accordingly. (check-in: 12eb8db796 user: drh tags: msvcMakeMin) | |
| 20:16 | Minor coding style tweaks for the mkmsvcmin tool. (check-in: c15e0fc4be user: mistachkin tags: msvcMakeMin) | |
| 20:09 | Adjust the amalgamation-tarball build process so that it includes the MSVC makefile and the sqlite3.rc resource file. (check-in: e420f3dc93 user: drh tags: msvcMakeMin) | |
| 19:47 | Improved comments on the transformation script and on the generated Makefile. (check-in: c6e633ab73 user: drh tags: msvcMakeMin) | |
| 19:24 | Use the -integer option when sorting list elements. (check-in: 949aa614e1 user: mistachkin tags: msvcMakeMin) | |
| 18:51 | Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. (check-in: 72d53699bf user: dan tags: fts5-perf) | |
| 18:24 | Changes to spellfix to try to get it to use stack space instead of heap space in cases where that makes sense. (check-in: dfcebc7393 user: drh tags: trunk) | |
| 16:20 | Merge trunk changes (including fixes for warnings in fts5) with this branch. (check-in: ceccc9ad78 user: dan tags: fts5-perf) | |
| 15:57 | Fix some signed/unsigned comparison compiler warnings in fts5. (check-in: 3be336aa89 user: dan tags: trunk) | |
| 14:45 | Fix a problem involving detail=col and column filters. (check-in: 7558a0ad22 user: dan tags: fts5-perf) | |
| 14:05 | Remove an assert() that can be false if compiled with SQLITE_USE_ALLOCA. (check-in: f0a551edf8 user: drh tags: trunk) | |
| 07:53 | Add tooling to create an MSVC Makefile capable of building the core library and shell only, using a pre-built amalgamation. (check-in: c46f1a13cb user: mistachkin tags: msvcMakeMin) | |
| 00:07 | More work on the MSVC build. (check-in: a79c46bc61 user: mistachkin tags: trunk) | |
|
2016-01-22
| ||
| 23:17 | In the TCL interface, if a database connection object was opened with the -uri 1 option, then also honor URI filenames for the "backup" and "restore" commands. (check-in: a1c8116ced user: drh tags: trunk) | |
| 22:16 | More MSVC makefile cleanup. (check-in: df22556fd7 user: mistachkin tags: trunk) | |
| 19:48 | Experimental performance enhancements for fts5. (check-in: b5a57b812f user: dan tags: fts5-perf) | |
| 19:44 | Reenable the xCurrentTime and xGetLastError methods on the unix VFSes as long as SQLITE_OMIT_DEPRECATED is not defined. (check-in: c11c85fdb6 user: drh tags: trunk) | |
| 17:48 | Add the sqlite3TokenInit() utility function. (check-in: 7323175337 user: drh tags: trunk) | |
| 15:44 | Have the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statement before attempting to match it against the names of attached databases. (check-in: e60461e984 user: dan tags: trunk) | |
| 04:22 | Enable FTS4 when building the shell with the MSVC makefile. (check-in: e4c07df557 user: mistachkin tags: trunk) | |
| 03:54 | Further refinements to the MSVC makefile. (check-in: 67625b963a user: mistachkin tags: trunk) | |
| 01:25 | MSVC makefile enhancements for use with the Windows 10 SDK. (check-in: ac2e9d3de5 user: mistachkin tags: trunk) | |
|
2016-01-21
| ||
| 18:56 | Fix typo in 'Makefile.in'. (check-in: 29a51c6dcc user: mistachkin tags: trunk) | |
| 17:06 | Add a new hint bit on the flags parameter of sqlite3BtreeDelete(). The new BTREE_IDXDELETE bit indicates that the call is to delete an index entry corresponding to a table row that has already been deleted. (check-in: ac2cbadd80 user: drh tags: btree-fordelete-flag) | |
| 15:55 | Improved comments on the FORDELETE hint. No logic changes. (check-in: a3cec529f0 user: drh tags: trunk) | |
|
2016-01-20
| ||
| 18:47 | Add 'rbu' to the clean targets. (check-in: f60f025027 user: mistachkin tags: trunk) | |
| 16:36 | Add a -detail option to the loadfts5.tcl script. For creating tables with the detail= option set. (check-in: 81e830e21f user: dan tags: trunk) | |
| 15:19 | Fix a problem in autoconf/configure.ac causing --enable-readline to fail if libedit was not present. (check-in: e8adeb64d4 user: dan tags: trunk) | |
| 14:22 | Case folding in the LIKE operator should look at all bits of the character, not just the lower 8 bits. Fix for ticket [80369eddd5c94]. This is a back-out of check-in [0a99a8c4facf] with a testcase added. (check-in: 204432ee72 user: drh tags: trunk) | |
| 08:47 | Improve performance of sqlite3VtabImportErrmsg(). (check-in: 18d61c8e40 user: dan tags: trunk) | |
| 03:36 | Performance improvement in sqlite3DbMallocRaw(). (check-in: ff8eadbed5 user: drh tags: trunk) | |
| 02:36 | Suppress the display of the P4 operand in EXPLAIN output when an opcode has been converted into a No-op. (check-in: 9f8297f862 user: drh tags: trunk) | |
| 02:21 | Remove an unnecessary memset() from the symbol name resolver. (check-in: da527ddae0 user: drh tags: trunk) | |
| 02:01 | Remove an unnecessary memset() for a small size reduction and speed improvement. (check-in: 730d7efb6f user: drh tags: trunk) | |
| 01:48 | During compilation, transfer the azVar[0..nzVar-1] array from Parse to Vdbe rather than copying it. Smaller and faster code. (check-in: 80dd495f37 user: drh tags: trunk) | |
| 01:32 | Very small simplification to the btree balancer. (check-in: f421adf54c user: drh tags: trunk) | |
|
2016-01-19
| ||
| 21:36 | Fix an incorrect VFS version number check in the threadtest3.c test program. (check-in: 5bf6442bec user: drh tags: trunk) | |
| 17:54 | Fix two harmless compiler warnings about comparisons of dangling pointers. (check-in: 86944f193f user: drh tags: trunk) | |
| 16:06 | Add further fts5 tests. 100% code coverage is finally restored. (check-in: b914ece0d1 user: dan tags: trunk) | |
|
2016-01-18
| ||
| 17:48 | Add tests for fts5. Fix a crash that can occur in fts5 if the database content is corrupted. (check-in: acaf426449 user: dan tags: trunk) | |
| 13:18 | Avoid unnecessary calls to memset() for a small performance improvement. (check-in: 9e8c23acf7 user: drh tags: trunk) | |
| 09:08 | Add a debugging function to print human-readable versions of fts5 detail=none leaf pages. (check-in: 8358af3658 user: dan tags: trunk) | |
| 00:46 | Simplification of the VDBE bytecode for incremental blob I/O. (check-in: d23849f64a user: drh tags: trunk) | |
| 00:20 | Fix a problem with SQLITE_TEST_REALLOC_STRESS. (check-in: 0aaf3febb0 user: drh tags: trunk) | |
|
2016-01-16
| ||
| 21:06 | Add extra tests to cover untested branches in fts5. (check-in: 61deab043d user: dan tags: trunk) | |
| 20:50 | Improvements to the way sqlite3VdbeAddOpList() works, resulting in a slightly smaller and faster binary. (check-in: 88ceb588bc user: drh tags: trunk) | |
| 18:58 | Add further tests for fts5. Fix some problems with detail=col mode and auxiliary functions. (check-in: de77d6026e user: dan tags: trunk) | |