/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 descendants and 100 ancestors of [43e474d3]

2012-10-28
19:35
Merge VSIX tooling and packaging enhancements to trunk. check-in: 99f27d64 user: mistachkin tags: trunk
2012-10-26
19:22
Fix a 32-bit integer overflow problem that could cause an error in a CREATE INDEX statement that writes more than 16GB of data. check-in: e24ba5be user: dan tags: trunk
18:40
Make sure the automatic index optimization is checked even if the covering index scan optimization was previously selected. check-in: ac1d5d8a user: drh tags: trunk
13:46
Add QNX-specific performance tweaks to the unix VFS. (Cherry-pick merge of [b02849e7bde458].) check-in: 63a7dd75 user: drh tags: trunk
00:55
Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. The test case for this is in TH3, in the main39.test module. check-in: 6d42d806 user: drh tags: trunk
00:11
Make sure all virtual table cursors have been closed on a prepared statement prior to unlinking the perpared statement from its database connection. Closed-Leaf check-in: f7c5abe8 user: drh tags: deferred-close-order
2012-10-25
23:47
Further work on getting ssdsim to run. This is an incremental checkin to save my place while jumping off to work on other things. Leaf check-in: ae2f1627 user: drh tags: ssdsim
19:25
Fix a bug in fts3 causing it to return SQLITE_NOMEM when NEAR, OR and some auxiliary functions were used together. Also a segfault in vtab.c that could follow an OOM condition. check-in: 33f4f981 user: dan tags: trunk
15:43
Fix typo in usage text for the command-line shell. Also, in the same usage text, make the file name argument to -init uppercase for consistency. check-in: a6d906cf user: mistachkin tags: trunk
15:32
Merge the command-line shell enhancements from trunk. Other edits toward trying to get ssdsim to run. check-in: 848f87e2 user: drh tags: ssdsim
15:23
Improvements to the command-line argument parsing in the command-line shell. Command-line options can now occur either before or after the database name and first command and are still accepted and processed. Command-line options are processed even if no database name is given (and :memory: is assumed). check-in: 317c80cb user: drh tags: trunk
03:07
Implementation of the INSTR() SQL function, as found in SQL Server, MySQL, and Oracle. Closed-Leaf check-in: 49ccae96 user: drh tags: instr
01:50
Initial check-in of a test VFS designed to simulate a NAND-flash SSD for the purpose of measuring and subsequently minimizing write amplification caused by SQLite. The code in this check-in compiles but does not run. check-in: 9e6efcf0 user: drh tags: ssdsim
2012-10-24
00:47
Translate the Debug/Release project configurations to the Debug/Retail VSIX package configurations. Closed-Leaf check-in: 5023a7ad user: mistachkin tags: vsixFlavor
2012-10-20
09:35
Modify clean target to handle all VSIX package flavors. check-in: 023217ea user: mistachkin tags: vsixFlavor
08:40
Modify VSIX build tools in support of an additional package flavor. check-in: 702ebc64 user: mistachkin tags: vsixFlavor
2012-10-19
02:10
Make sure substructure elements have proper alignment in the ICU tokenizers of FTS2 and FTS3. check-in: aaa2d9b0 user: drh tags: trunk
00:23
Add detailed comments to the build tools used to generate the VSIX package. Also, allow the build configurations and native library directories to be overridden for the multi-platform build tool for MSVC. check-in: 0482c73b user: mistachkin tags: trunk
2012-10-18
20:49
Put auxiliary libraries after libsqlite3.a in the testfixture target of the "main.mk" makefile. check-in: 8fc8548f user: drh tags: trunk
15:01
Merge Watcom compiler warning fixes into trunk. check-in: 5be96788 user: drh tags: trunk
10:35
More warning fixes. Closed-Leaf check-in: 51a6a797 user: mistachkin tags: warnings
09:39
Fix harmless compiler warnings. check-in: 018e09c7 user: mistachkin tags: warnings
2012-10-17
20:28
Add a comment to fts3_snippet.c. check-in: b5f5ba31 user: dan tags: trunk
20:15
Initialize variables used as outputs of custom tokenizer method calls in fts4. check-in: 514505a8 user: dan tags: trunk
16:20
Add a test for the problem fixed by [bf44d73d3e]. check-in: db9b1fa5 user: dan tags: trunk
15:28
Change the way the tcl crash-test code works to avoid triggering an assert() in os_unix.c. check-in: b8b7b8f9 user: dan tags: trunk
13:15
Remove an incorrect "#ifndef SQLITE_OMIT_AUTOVACUUM" from pager. check-in: bf44d73d user: drh tags: trunk
2012-10-16
23:17
Enable optimization of IN operators on constraints to virtual tables. check-in: aa650746 user: drh tags: vtab-IN-opt
23:08
Merge updates from trunk. check-in: f021559d user: mistachkin tags: configReadOnly
21:08
An optimization that converts "a IN (b)" into "a==b". Seems to work, but needs additional test cases. Leaf check-in: 8b4c3c5e user: drh tags: degenerate_IN
2012-10-15
20:28
Correct comments and enhance readability of the mkvsix tool. check-in: 2c3af657 user: mistachkin tags: trunk
18:02
Hold the mutex on the shared-cache for the duration of a VACUUM operation. check-in: 629a42d4 user: dan tags: trunk
16:24
Dequote column names generated by the query flattener. check-in: 5526e0aa user: drh tags: trunk
14:25
Merge all the latest core changes into the sessions branch. check-in: 76767d65 user: drh tags: sessions
11:28
Fix a failing assert() in wal.c. check-in: 8745530b user: dan tags: trunk
2012-10-13
23:16
Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. check-in: ca86138b user: drh tags: trunk
20:55
Mark an always-true conditional as such. Closed-Leaf check-in: ae025cae user: drh tags: zero-byte-backup-fix
20:20
Modify backup4 test name prefix to make the resulting test names unique. check-in: 637fb1c1 user: mistachkin tags: zero-byte-backup-fix
19:58
Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. check-in: af5c9ee4 user: dan tags: zero-byte-backup-fix
09:31
Allow the showdb tool to be compiled with MSVC. check-in: dce391fc user: mistachkin tags: trunk
2012-10-12
18:06
Tooling support for including the debug build in the VSIX package. check-in: de784399 user: mistachkin tags: trunk
2012-10-10
13:59
Fix duplicate test name in whereD.test. check-in: 1182b54a user: mistachkin tags: trunk
12:14
Define the sqlite3PagerWalFramesize() function even if SQLITE_OMIT_WAL is used. check-in: 96247853 user: drh tags: trunk
10:52
Add support for URI filenames in sqlite3_analyzer. check-in: 6dc987d3 user: drh tags: trunk
09:46
Move a couple of WAL-related function declarations in sqliteInt.h and pager.h into "#ifndef SQLITE_OMIT_WAL" blocks. Otherwise, the amalgamation fails to build using some compilers with SQLITE_OMIT_WAL (static function declared but not defined). check-in: f7437153 user: dan tags: trunk
2012-10-09
21:07
Merge the fix for ticket [d02e1406a58ea02] into trunk. check-in: dd34bec3 user: drh tags: trunk
18:51
Attempt to suppress warnings generated by Coverity. check-in: 7b1a6e6c user: drh tags: trunk
14:58
Merge the latest trunk changes, especially the ORDER BY optimizer enhancements but also other fixes, onto the sessions branch. check-in: f1fbb8c5 user: drh tags: sessions
14:36
Avoid an assertion fault and/or freeing memory while it is still in use when an error occurs during virtual table construction. check-in: a02599ad user: drh tags: trunk
09:26
Bring some comments up to date in the query planner, and especially the ORDER BY optimizer. Also add testcase() macros. check-in: bb5c0f1c user: drh tags: trunk
01:39
Remove an unused variable. Fix code that occurs before a variable declaration. check-in: 01dc032b user: drh tags: trunk
01:23
Replace an always-false conditional with an assert(). check-in: 981b9943 user: drh tags: trunk
2012-10-08
23:25
Changes to facilitate full test coverage. check-in: 28d1eb40 user: drh tags: trunk
21:51
Merge ORDER BY optimization refactoring and repair into trunk. check-in: c027a9af user: drh tags: trunk
21:01
All test cases (veryquick.tcl and min.rc) pass. A few branch operations in ORDER BY optimization logic are untested by min.rc. Closed-Leaf check-in: 8314fd60 user: drh tags: qp-enhancements
20:27
Further tweaks to the ORDER BY optimizer, to fix a bug and to get the optimizer to recognize some additional cases. check-in: bcb4f262 user: drh tags: qp-enhancements
19:41
Bug fixes in the ORDER BY optimizer. check-in: 301bbee4 user: drh tags: qp-enhancements
18:23
Continued refactoring of the ORDER BY optimization logic. This check-in is close to working, but it still has issues. A few test cases fail. check-in: adbdc663 user: drh tags: qp-enhancements
14:36
Manually define the Win32 file-mapping APIs for WAL if SQLITE_WIN32_FILEMAPPING_API is defined. check-in: 1c2c0a28 user: mistachkin tags: trunk
2012-10-07
14:14
Merge updates from trunk. check-in: bbb0d189 user: mistachkin tags: configReadOnly
05:34
Corrections to test names to eliminate duplicates and follow naming conventions. check-in: 50679889 user: mistachkin tags: trunk
00:52
Manually define the Win32 file-mapping APIs for WAL if SQLITE_WIN32_FILEMAPPING_API is defined. Closed-Leaf check-in: 585e2070 user: mistachkin tags: winFileMapping
2012-10-06
03:48
Changes for WinRT compatibility. Also, allow version resource compilation and embedding to be disabled at compile-time. check-in: 4b0facc1 user: mistachkin tags: trunk
2012-10-05
19:43
Fix a problem in shared-cache mode where a COMMIT statement might cause a busy-handler belonging to a shared-cache connection other than the current writer to be invoked. check-in: e0c889d6 user: dan tags: trunk
17:44
Merge the shared-cache related fixes from the shared-cache-fix branch to the trunk. check-in: 698ec776 user: dan tags: trunk
17:18
Add a test for the collation-sequence/CHECK constraint problem fixed by the previous commit. Closed-Leaf check-in: 82b6aa77 user: dan tags: shared-cache-fix
16:30
Fix a problem with shared-cache mode and CHECK constraints causing one db handle to invoke a collation sequence function registered with another. check-in: c2c776ab user: dan tags: shared-cache-fix
14:43
Consolidate all occurrences of the "no such collation sequence" error message into a single spot. check-in: 8ea67522 user: drh tags: trunk
07:36
Rename a tool batch file subroutine to avoid confusion about its purpose. check-in: 43155b15 user: mistachkin tags: trunk
2012-10-04
19:33
Shared-cache mode fixes for views and virtual tables. check-in: 2b370dea user: dan tags: shared-cache-fix
12:10
Yet another refactoring of ORDER BY logic in the query planner. This particular check-in works mostly, but still has a few minor issues. check-in: 8f448745 user: drh tags: qp-enhancements
2012-10-03
20:25
Merge updates from trunk. check-in: 1138815c user: mistachkin tags: configReadOnly
18:09
Fix an out-of-order memset() that occurs before all variable declarations are finished. Also fix a line that exceeds the 80-character line length limit. check-in: ba2f492f user: drh tags: trunk
12:56
Update the query planner to recognize more cases where ORDER BY clauses can be optimized out. Add test cases to verify correct behavior of the ORDER BY optimization when the covering-index-scan optimization is disabled. Fix a harmless compiler warning in the TCL interface. check-in: 956e4d7f user: drh tags: trunk
12:38
Fix a query planner problem that only occurs when covering-index-scan is disabled. Fix to tests whose output changed due to the new and more aggressive ORDER BY optimization. Closed-Leaf check-in: 0f9bb901 user: drh tags: qp-enhancements
11:02
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: c1f10a26 user: drh tags: trunk
00:25
Further attempts to optimize out unnecessary ORDER BY clauses. check-in: 6744d9a3 user: drh tags: qp-enhancements
2012-10-02
22:54
Work around an optimization issue with the MSVC compiler for ARM. check-in: 7d301fdf user: mistachkin tags: trunk
15:19
More lenient handling of ORDER BY optimization in joins with mixed ASC/DESC. This is a better and less restrictive fix for the problem addressed by the previous check-in. check-in: abcf6a5d user: drh tags: trunk
14:11
Only continue an ORDER BY optimization into inner loops if the equality constraints on the inner loop match terms of an outer ordered index that are actually used by the ORDER BY clause. check-in: b0e7b4df user: drh tags: trunk
01:46
Factor an invariant out the loop termination condition for the ORDER BY satisfied-by-index analyzer routine. check-in: 545bb336 user: drh tags: trunk
01:25
Make sure the outer loop cursor numbers are recorded in time for them to be used by the ORDER BY optimizer. check-in: 351dc8d9 user: drh tags: trunk
01:10
Improvements to the wheretrace output. check-in: 76b27765 user: drh tags: trunk
2012-10-01
20:32
Fix harmless compiler warnings. check-in: 59c2be75 user: drh tags: trunk
20:12
Fix several compiler warnings seen with MSVC. Closed-Leaf check-in: 8b5f617c user: mistachkin tags: msvcWarnings
18:44
Add SQLITE_FCNTL_BUSYHANDLER. Invoked to provide access to the busy-handler callback to custom VFS implementations. check-in: 1262d2f4 user: dan tags: trunk
17:44
Minor changes to the query planner for improved test coverage. check-in: c12044df user: drh tags: trunk
12:44
Omit the sqlite3GetReservedNoMutex() routine in build configurations where it is not used. check-in: f193dbb6 user: drh tags: trunk
12:16
Make sure the size parameter to read and write VFS methods in the unix VFS do not become too big or go negative. This was not actually possible in the current code. The checks are added to make sure some future bug does not make it possible. check-in: daebe3bd user: drh tags: trunk
06:50
Ensure that the value returned by xSectorSize() is reasonable (currently defined as between 2^5 and 2^16 bytes) before using it to calculate the amount of padding to add to a wal file. check-in: 6b4ff83b user: dan tags: trunk
2012-09-29
19:10
Improved ORDER BY optimization when outer loops of a join return a single row. check-in: 62225b4a user: drh tags: trunk
15:45
Disable the bigfile tests on Macs. check-in: d869edda user: drh tags: trunk
14:45
Fix compiler warnings found on Lion. check-in: fd74d3d9 user: drh tags: trunk
2012-09-28
20:23
Avoid calling sqlite3BtreeEnter() in a corner case where the corresponding database handle mutex (sqlite3.mutex) may not be held. This prevents a potential deadlock or crash that can occur if the backup API, shared-cache mode and SQLITE_HAVE_CODEC are all in use. check-in: 89b8c377 user: dan tags: trunk
18:13
Modify the clearCell function to use SQLITE_CORRUPT_BKPT in the one place it was not. check-in: 472beb30 user: mistachkin tags: trunk
13:05
Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the ORDER BY query planner optimizations) into the sessions branch. check-in: 6ca8eae1 user: drh tags: sessions
10:57
Merge the latest trunk changes (PRAGMA busy_timeout and the ORDER BY query planner enhancements) into the apple-osx branch. check-in: 6a5c59dd user: drh tags: apple-osx
00:44
Query planner enhancements to be more agressive about optimizing out ORDER BY clauses - in particular the query planner now has the ability to omit ORDER BY clauses that span multiple tables in a join. check-in: 1e874629 user: drh tags: trunk
2012-09-27
21:03
Modify generation of resource header file for MSVC so that it can work from outside the working directory. check-in: 20caf80c user: mistachkin tags: trunk
12:11
Merge the "PRAGMA busy_timeout" change into trunk. check-in: 1a679a1e user: drh tags: trunk
2012-09-07
20:10
Correct two test names to make them unique. Closed-Leaf check-in: 43e474d3 user: mistachkin tags: busy-timeout-pragma
18:49
Have PRAGMA busy_timeout return 0 if the busy handler has been changed or cancelled. check-in: 7be5bc36 user: drh tags: busy-timeout-pragma
16:46
Add an experimental busy_timeout pragma to facilitate access to the sqlite3_busy_timeout() interfaces for programmers that are working from behind a language wrapper that does not expose that interface. check-in: 22ebc668 user: drh tags: busy-timeout-pragma
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
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
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
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:44
Update the spellfix virtual table so that all OOM errors are reported out to the application. check-in: 573770f5 user: drh tags: trunk
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
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-15
16:43
Changes to the spellfix test script to make the results deterministic. check-in: 31c07db2 user: drh tags: trunk
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
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
2012-08-06
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
2012-07-17
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
22:16
Fix compiler warnings about unused code in spellfix. Fix the editDist3Core() routine to return the matchlen in characters instead of bytes. Closed-Leaf check-in: f96d4e7b user: drh tags: spellfix-matchlen
14:52
Fix a bug in the phonetic-hash routine in spellfix1: Even if the first character of a word is deemed to be "silent", do not apply the special handling intended for the first character of each word to the second. check-in: 6333b42d user: dan tags: spellfix-matchlen
10:25
Merge trunk changes. check-in: 90df64ab user: dan tags: spellfix-matchlen
10:06
If a specific database is nominated as part of a "PRAGMA integrity_check" or "PRAGMA quick_check" command, search for problems in the nominated database only. i.e. "PRAGMA main.quick_check" now only scans the main database, not all attached databases as before. check-in: 4353e40b user: dan tags: trunk
2012-07-13
19:26
Add the "matchlen" column to the spellfix1 virtual table. check-in: f24b9d87 user: dan tags: spellfix-matchlen
16:15
Update test_spellfix.c with latest changes. check-in: cba2a658 user: dan tags: trunk
2012-06-30
22:22
Setup the necessary library paths for cross-compilation with MSVC. check-in: 7fac56ed user: mistachkin tags: trunk
19:24
Simplify usage of some linker options in the MSVC makefile. check-in: 03016020 user: mistachkin tags: trunk
16:22
Make use of the predefined nmake command macro CC when possible instead of the literal string 'cl.exe'. Improve support for cross-compilation. Eliminate problematic use of double quotes in macro preprocessing expressions. check-in: 6c88229a user: mistachkin tags: trunk
2012-06-27
16:41
Another changes to the shell in support of SQLITE_OMIT_AUTOINIT. check-in: 3b4f5add user: drh tags: trunk
16:12
Update the shell so that it works with SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT. check-in: 95c0c995 user: drh tags: trunk