]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
12 years agoAdd an implementation of the REGEXP operator and function. Only defined regexp
drh [Wed, 12 Sep 2012 18:45:31 +0000 (18:45 +0000)] 
Add an implementation of the REGEXP operator and function.  Only defined
if compiled with SQLITE_ENABLE_REGEXP.

FossilOrigin-Name: 8398f77c5a689c795c5b1e8eea41a3b128dba2fd

12 years agoUpdate version number to 3.7.15. Delete some obsolete build scripts.
drh [Wed, 12 Sep 2012 00:11:20 +0000 (00:11 +0000)] 
Update version number to 3.7.15.  Delete some obsolete build scripts.

FossilOrigin-Name: 9402f81fade5fcae0a3a6efdc7a5cdf71fc2e79f

12 years agoAdded sqlite3_errstr API to translate a result code to the corresponding error message.
mistachkin [Tue, 11 Sep 2012 02:00:25 +0000 (02:00 +0000)] 
Added sqlite3_errstr API to translate a result code to the corresponding error message.

FossilOrigin-Name: bf8a9ca5b58404112a8af666f5840b462b7bbfe1

12 years agoCorrect two duplicated test names.
mistachkin [Mon, 10 Sep 2012 23:44:12 +0000 (23:44 +0000)] 
Correct two duplicated test names.

FossilOrigin-Name: ced49974a969f11e5ebe2280bd7eec20b059e501

12 years agoRemove the stale implementation of the ifnull and coalesce functions - code
drh [Mon, 10 Sep 2012 15:02:32 +0000 (15:02 +0000)] 
Remove the stale implementation of the ifnull and coalesce functions - code
that has been commented out for ages.  No functional changes.

FossilOrigin-Name: c2ad691174b8af2e8b158d8840cfc93f75d7db71

12 years agoAvoid using the sqlite3ErrStr function in the Tcl package if USE_SYSTEM_SQLITE is...
mistachkin [Mon, 10 Sep 2012 09:33:09 +0000 (09:33 +0000)] 
Avoid using the sqlite3ErrStr function in the Tcl package if USE_SYSTEM_SQLITE is defined.

FossilOrigin-Name: a716b9a3091072774d067c0a1258b0f4c39a4180

12 years agoMake header comments for some Tcl test commands more consistent. No changes to code.
mistachkin [Mon, 10 Sep 2012 08:48:05 +0000 (08:48 +0000)] 
Make header comments for some Tcl test commands more consistent.  No changes to code.

FossilOrigin-Name: af870ca9827d2079a35dbb545660f670c7ca9512

12 years agoRefine error messages in the sqlite3 Tcl command when a NULL database connection...
mistachkin [Mon, 10 Sep 2012 07:29:29 +0000 (07:29 +0000)] 
Refine error messages in the sqlite3 Tcl command when a NULL database connection is returned from sqlite3_open_v2.

FossilOrigin-Name: f260d7d567a1239c483c437d0b18a95bd0c96724

12 years agoFix typo in documentation for sqlite3_open_v2. No changes to code.
mistachkin [Mon, 10 Sep 2012 06:02:57 +0000 (06:02 +0000)] 
Fix typo in documentation for sqlite3_open_v2.  No changes to code.

FossilOrigin-Name: b532120a4a567a3fa54b87dd8ab94cc2c0347c7c

12 years agoAvoid repeating calls to the sqlite3_trace() callback when the same statement
drh [Tue, 4 Sep 2012 21:34:26 +0000 (21:34 +0000)] 
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.

FossilOrigin-Name: 39f763bfc04174ee0fe2cdf6a92b7c12f726bd1b

12 years agoVersion 3.7.14 version-3.7.14
drh [Mon, 3 Sep 2012 15:42:36 +0000 (15:42 +0000)] 
Version 3.7.14

FossilOrigin-Name: c0d89d4a9752922f9e367362366efde4f1b06f2a

12 years agoFix compiler warnings in test_spellfix1.c
drh [Mon, 3 Sep 2012 12:40:32 +0000 (12:40 +0000)] 
Fix compiler warnings in test_spellfix1.c

FossilOrigin-Name: ebb08d0b4d1ed674e4a23c3754206ca2df9063ff

12 years agoAdd resources describing the version number and other information to EXEs
drh [Mon, 3 Sep 2012 11:39:59 +0000 (11:39 +0000)] 
Add resources describing the version number and other information to EXEs
and DLLs generated using MSVC.

FossilOrigin-Name: a15a70840e1af55ffe4035f53e894a2d582d8f74

12 years agoInsert additional tab character. win32Resources
mistachkin [Mon, 3 Sep 2012 11:14:53 +0000 (11:14 +0000)] 
Insert additional tab character.

FossilOrigin-Name: 3af7c1a6afacea7b5e47bebce2541aa340c6e946

12 years agoLinking and cleaning fixes for the tclsqlite3.exe target in the MSVC makefile.
mistachkin [Mon, 3 Sep 2012 11:01:21 +0000 (11:01 +0000)] 
Linking and cleaning fixes for the tclsqlite3.exe target in the MSVC makefile.

FossilOrigin-Name: 96d43c7a35684cd8ca6ac0d8325193e69f102fb8

12 years agoAdd Win32 version resources to the applicable binaries built by the MSVC makefile.
mistachkin [Mon, 3 Sep 2012 10:32:32 +0000 (10:32 +0000)] 
Add Win32 version resources to the applicable binaries built by the MSVC makefile.

FossilOrigin-Name: e2f27d28b590164bc6b0d856e79c9345e2188d03

12 years agoIn the spellfix phonehash() function, add letter W into the same character
drh [Fri, 31 Aug 2012 14:55:05 +0000 (14:55 +0000)] 
In the spellfix phonehash() function, add letter W into the same character
class as V.

FossilOrigin-Name: 7536101317c00fbb5bf555120feb55b9bc40e8ba

12 years agoChanges for ERROR_PATH_NOT_FOUND in addition to ERROR_FILE_NOT_FOUND in
drh [Fri, 31 Aug 2012 12:31:18 +0000 (12:31 +0000)] 
Changes for ERROR_PATH_NOT_FOUND in addition to ERROR_FILE_NOT_FOUND in
winAccess().

FossilOrigin-Name: 527340abff18aedbcb0f82ac1296a9f548e24ac4

12 years agoExclude the atof1.test test script from the valgrind permutations test since
drh [Thu, 30 Aug 2012 20:24:39 +0000 (20:24 +0000)] 
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.

FossilOrigin-Name: d3cf6832a59fe4c5723761abb4c89614406b03db

12 years agoFix an out-of-bounds read in the demonstration code in test_spellfix.c.
dan [Thu, 30 Aug 2012 11:22:16 +0000 (11:22 +0000)] 
Fix an out-of-bounds read in the demonstration code in test_spellfix.c.

FossilOrigin-Name: 59194311543b95c2aeebe2aba83da3c29b7c6460

12 years agoFix a typo in a comment in vdbe.c. No changes to code.
drh [Wed, 29 Aug 2012 10:28:43 +0000 (10:28 +0000)] 
Fix a typo in a comment in vdbe.c.  No changes to code.

FossilOrigin-Name: 9fbe858b625a346690d5cefca3a6fa2a557bea11

12 years agoFix a case where SQLite was failing to detect a syntax error in queries like "SELECT...
dan [Tue, 28 Aug 2012 14:45:50 +0000 (14:45 +0000)] 
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.

FossilOrigin-Name: 200a81358c3117401d2258dd06bb8d2ea4f0ef51

12 years agoIssue a log message if the temporary directory has not been set when running on WinRT.
mistachkin [Tue, 28 Aug 2012 04:20:56 +0000 (04:20 +0000)] 
Issue a log message if the temporary directory has not been set when running on WinRT.

FossilOrigin-Name: 9ee39102942d4a4830417f61f0969f29ac0282a1

12 years agoEnable the use of a simpler command line when cross-compiling in the MSVC build envir...
mistachkin [Tue, 28 Aug 2012 01:44:13 +0000 (01:44 +0000)] 
Enable the use of a simpler command line when cross-compiling in the MSVC build environment.

FossilOrigin-Name: 8ade136a038ee71d741af4a9f9e692fdff4e7911

12 years agoFormatting changes to the C code example in the documentation for
drh [Tue, 28 Aug 2012 00:17:56 +0000 (00:17 +0000)] 
Formatting changes to the C code example in the documentation for
sqlite3_temp_directory().  No changes to code.

FossilOrigin-Name: 5b4b39788ed9ac5962a17315d5549fc5e3f38c5e

12 years agoUpdate API docs to include notes about the WinRT temporary directory. No changes...
mistachkin [Tue, 28 Aug 2012 00:09:58 +0000 (00:09 +0000)] 
Update API docs to include notes about the WinRT temporary directory.  No changes to code.

FossilOrigin-Name: eaeeb0699297dde824788e2907a0cfd2acd8f642

12 years agoAdd to #undef statements to the command-line shell, go make sure that the
drh [Mon, 27 Aug 2012 21:19:03 +0000 (21:19 +0000)] 
Add to #undef statements to the command-line shell, go make sure that the
macros definitions that follow do not collide with system definitions.

FossilOrigin-Name: 24420d6d2077d745cc26dd269e76b48c8a3eeb3c

12 years agoFix an incorrect assert in the virtual table logic - it could fire following
drh [Mon, 27 Aug 2012 14:39:47 +0000 (14:39 +0000)] 
Fix an incorrect assert in the virtual table logic - it could fire following
an I/O error after sqlite3_close_v2() was added.

FossilOrigin-Name: 4ccc18e999c51f7f6637ee48ccca35c7706bfe6d

12 years agoFix all known instances of 'repeated the' style typos in comments. No changes to...
mistachkin [Sat, 25 Aug 2012 10:01:29 +0000 (10:01 +0000)] 
Fix all known instances of 'repeated the' style typos in comments.  No changes to code.

FossilOrigin-Name: 9b19b847533f944f289d93dcdba29c0d67bf251c

12 years agoFix a harmless compiler warning.
drh [Sat, 25 Aug 2012 02:11:13 +0000 (02:11 +0000)] 
Fix a harmless compiler warning.

FossilOrigin-Name: 929b51840b83ee1ca5add8fe430913e7c4e2a3d6

12 years agoWhen the same index is used for all OR-terms in a WHERE clause, then try to
drh [Fri, 24 Aug 2012 23:56:19 +0000 (23:56 +0000)] 
When the same index is used for all OR-terms in a WHERE clause, then try to
use that index as a covering index.

FossilOrigin-Name: 62678be3df35cdcb09172ba8c860f7b73517f1ea

12 years agoMove field WhereLevel.pCovidx inside the union to WhereLevel.u.pCovidx. multi-or-covering-index
drh [Fri, 24 Aug 2012 23:24:15 +0000 (23:24 +0000)] 
Move field WhereLevel.pCovidx inside the union to WhereLevel.u.pCovidx.

FossilOrigin-Name: b722143d075979ba3d92b7b29e576ce2307187d1

12 years agoRemove a NEVER() that is in fact reachable on an OOM. This probably
drh [Fri, 24 Aug 2012 21:54:11 +0000 (21:54 +0000)] 
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.

FossilOrigin-Name: 5499af53ebcdc21ae288aa2347aa21f6891d79ef

12 years agoAnother test for whereD.test.
dan [Fri, 24 Aug 2012 19:58:18 +0000 (19:58 +0000)] 
Another test for whereD.test.

FossilOrigin-Name: 29d586178dcfdb99eaf7ce768668ab0aa9898c83

12 years agoAdd extra tests to whereD.test.
dan [Fri, 24 Aug 2012 19:52:25 +0000 (19:52 +0000)] 
Add extra tests to whereD.test.

FossilOrigin-Name: 7e961eef6b7260dd8deb8b3812218a874c382885

12 years agoFix a problem to do with multi-or queries and automatic indexes.
dan [Fri, 24 Aug 2012 18:44:56 +0000 (18:44 +0000)] 
Fix a problem to do with multi-or queries and automatic indexes.

FossilOrigin-Name: a3e26038a1d9f3331239f777c67d1920d904aab0

12 years agoMore test cases for OR-optimization covering indices.
drh [Fri, 24 Aug 2012 17:52:54 +0000 (17:52 +0000)] 
More test cases for OR-optimization covering indices.

FossilOrigin-Name: e5c3190c27b69dc50f348c849a81b79031b2fb67

12 years agoAdditional test cases for OR-optimization with covering indices, including
drh [Fri, 24 Aug 2012 15:29:03 +0000 (15:29 +0000)] 
Additional test cases for OR-optimization with covering indices, including
one test case that currently fails.

FossilOrigin-Name: d8b7ab37120ac20e60b6a600cd0e5b34a09cf97a

12 years agoExperimental change to support the covering index optimization for queries with OR...
dan [Fri, 24 Aug 2012 10:52:35 +0000 (10:52 +0000)] 
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.

FossilOrigin-Name: 1dc8c7c741a82bb98a07f3fdb8142d8bc8d8a98b

12 years agoMerge the nested aggregate query enhancements into trunk.
drh [Fri, 24 Aug 2012 01:07:52 +0000 (01:07 +0000)] 
Merge the nested aggregate query enhancements into trunk.

FossilOrigin-Name: d4cd6017c9875947a05b1dc36538d4272fb18739

12 years agoMerge changes for the new sqlite3_win32_set_directory API to trunk.
mistachkin [Thu, 23 Aug 2012 22:45:34 +0000 (22:45 +0000)] 
Merge changes for the new sqlite3_win32_set_directory API to trunk.

FossilOrigin-Name: 20f184f2d5908badd9d44d4fe2ad7c9e182c8803

12 years agoAdd test cases and fix bugs associated with the previous check-in nested-agg
drh [Thu, 23 Aug 2012 19:46:11 +0000 (19:46 +0000)] 
Add test cases and fix bugs associated with the previous check-in
enhancements to nested aggregate subquery processing.

FossilOrigin-Name: 00b1dc71be4c3420730b5f7840af824ea86165e7

12 years agoFurther improvements to the processing of nested aggregate queries.
drh [Thu, 23 Aug 2012 16:18:10 +0000 (16:18 +0000)] 
Further improvements to the processing of nested aggregate queries.

FossilOrigin-Name: 3c3ffa901f5ce8a523028ff15563ce3e0f55a641

12 years agoModify the MSVC makefile to make it easier to select the heap subsystem to use.
mistachkin [Wed, 22 Aug 2012 00:39:34 +0000 (00:39 +0000)] 
Modify the MSVC makefile to make it easier to select the heap subsystem to use.

FossilOrigin-Name: b1dbf490869d7fc55ce797cf80cf3bf7141d2d15

12 years agoAdd assert to check that the memory block for the previous directory value was alloca... win32SetDir
mistachkin [Wed, 22 Aug 2012 00:18:27 +0000 (00:18 +0000)] 
Add assert to check that the memory block for the previous directory value was allocated via sqlite3_malloc or related function.

FossilOrigin-Name: 1246f15b146ebf6518fb8f5c92a1ebc9495cd9dc

12 years agoAdded sqlite3_win32_set_directory API to assist in portability to WinRT.
mistachkin [Tue, 21 Aug 2012 23:33:45 +0000 (23:33 +0000)] 
Added sqlite3_win32_set_directory API to assist in portability to WinRT.

FossilOrigin-Name: 600de08d40ceead24f425d20429d60f5732f8ba7

12 years agoUpdate the spellfix virtual table so that all OOM errors are reported out
drh [Tue, 21 Aug 2012 17:44:05 +0000 (17:44 +0000)] 
Update the spellfix virtual table so that all OOM errors are reported out
to the application.

FossilOrigin-Name: 573770f5a66fa4d708931b30350149eb739da607

12 years agoAdd the SQLITE_DISABLE_FTS4_DEFERRED compile time option.
dan [Mon, 20 Aug 2012 17:24:48 +0000 (17:24 +0000)] 
Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option.

FossilOrigin-Name: e799222f3b8246e65657a758437914ece7069ba9

12 years agoChange the checkSpacing utility program to ignore whitespace at end-of-line
drh [Mon, 20 Aug 2012 16:23:36 +0000 (16:23 +0000)] 
Change the checkSpacing utility program to ignore whitespace at end-of-line
unless the --wseol option is used.

FossilOrigin-Name: be1faadebd9464f1c7d4cc26104f219ed35384b8

12 years agoSilence harmless compiler warnings in the test code.
drh [Mon, 20 Aug 2012 16:08:29 +0000 (16:08 +0000)] 
Silence harmless compiler warnings in the test code.

FossilOrigin-Name: 7653973a525638b5e5e70ea8459f64e1a88befca

12 years agoRemove tab characters from source code files. Replace them with spaces.
drh [Mon, 20 Aug 2012 15:53:54 +0000 (15:53 +0000)] 
Remove tab characters from source code files.  Replace them with spaces.

FossilOrigin-Name: 7edd10a960d5ff121e470b0549b0aa9fb7760022

12 years agoAdd a command-line program to tool/ that will check source code files for
drh [Mon, 20 Aug 2012 15:46:08 +0000 (15:46 +0000)] 
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.

FossilOrigin-Name: 656a9c8b47d262e0982ad3a35db490e2ff4d856e

12 years agoClarify that the number-of-bytes parameter to sqlite3_bind_blob() must
drh [Fri, 17 Aug 2012 13:44:31 +0000 (13:44 +0000)] 
Clarify that the number-of-bytes parameter to sqlite3_bind_blob() must
be non-negative.

FossilOrigin-Name: b1b01c4cd9798d69951665ed7d6d9f79f6b463a1

12 years agoFix MSVC compiler warning in the spellfix module. Also, add an assert.
mistachkin [Fri, 17 Aug 2012 12:13:11 +0000 (12:13 +0000)] 
Fix MSVC compiler warning in the spellfix module.  Also, add an assert.

FossilOrigin-Name: e66cf0401fab766f62c1d263dcb1efb67b2075a9

12 years agoSkip defining some WAL specific things in the Win32 VFS code when compiling without...
mistachkin [Fri, 17 Aug 2012 11:47:32 +0000 (11:47 +0000)] 
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.

FossilOrigin-Name: 61b1ae121782525b37882a559d0fbb7c85237fd5

12 years agoChanges to the spellfix test script to make the results deterministic.
drh [Wed, 15 Aug 2012 16:43:07 +0000 (16:43 +0000)] 
Changes to the spellfix test script to make the results deterministic.

FossilOrigin-Name: 31c07db2560ee867723c41cdb634e2aa7993634d

12 years agoChange autoconf so that the --with-tcl=DIR option will override the
drh [Wed, 15 Aug 2012 16:06:54 +0000 (16:06 +0000)] 
Change autoconf so that the --with-tcl=DIR option will override the
TCL configuration that is found using tclsh.

FossilOrigin-Name: 772d0de3f311f2035f8a42f01371c96c9fa587ce

12 years agoSilence three harmless compiler warnings in vdbesort.c.
drh [Tue, 14 Aug 2012 19:04:27 +0000 (19:04 +0000)] 
Silence three harmless compiler warnings in vdbesort.c.

FossilOrigin-Name: a5431c86df442c6e6dfaeae8e8aa62b56d204e97

12 years agoAdd an assert() to the btree rebalancer in order to silence a
drh [Tue, 14 Aug 2012 18:43:39 +0000 (18:43 +0000)] 
Add an assert() to the btree rebalancer in order to silence a
clang/scan-build warning.

FossilOrigin-Name: 6730579cf5c6c74cb293e7237d896d3a3a36b691

12 years agoUpdate the spellfix virtual table to the latest development code.
drh [Tue, 14 Aug 2012 17:29:27 +0000 (17:29 +0000)] 
Update the spellfix virtual table to the latest development code.

FossilOrigin-Name: 6954fef006431d153de6e63e362b8d260ebeb1c6

12 years agoRefer to the file mapping Win32 API functions only when absolutely necessary.
mistachkin [Tue, 14 Aug 2012 01:45:12 +0000 (01:45 +0000)] 
Refer to the file mapping Win32 API functions only when absolutely necessary.

FossilOrigin-Name: 1de2237d005fa1a1e1d034820d17daf64a860f81

12 years agoRefer to the WaitForSingleObjectEx and SetFilePointerEx Win32 functions only for...
mistachkin [Mon, 13 Aug 2012 22:05:22 +0000 (22:05 +0000)] 
Refer to the WaitForSingleObjectEx and SetFilePointerEx Win32 functions only for platforms where they are going to be used.

FossilOrigin-Name: 9888ce9294c09749f5c958f965f949561867fea0

12 years agoWhen populating an index b-tree as part of a CREATE INDEX or REINDEX statement, distr...
dan [Wed, 8 Aug 2012 14:04:56 +0000 (14:04 +0000)] 
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.

FossilOrigin-Name: b0d31e779ecf01c5a235443c05f488b177ac3045

12 years agoWhen building a b-tree as part of a CREATE INDEX or REINDEX statement, attempt to...
dan [Wed, 8 Aug 2012 11:55:15 +0000 (11:55 +0000)] 
When building a b-tree as part of a CREATE INDEX or REINDEX statement, attempt to pack keys into pages as tightly as possible.

FossilOrigin-Name: efea62b96c6a242c8ac2bdad70e50c87aee5e871

12 years agoChange to securedel2.test so that it works even if SQLITE_DEFAULT_AUTOVACUUM=1 is...
dan [Wed, 8 Aug 2012 10:14:10 +0000 (10:14 +0000)] 
Change to securedel2.test so that it works even if SQLITE_DEFAULT_AUTOVACUUM=1 is defined.

FossilOrigin-Name: 1e6f5ea48174e3cb59e6d9fe1293fd87bd9c78f5

12 years agoSimplifications to the sorter to support full-coverage testing.
drh [Tue, 7 Aug 2012 22:53:01 +0000 (22:53 +0000)] 
Simplifications to the sorter to support full-coverage testing.

FossilOrigin-Name: de804f4c90f02ca98991da185ed5e28bdd319e92

12 years agoAdd extra tests for secure-delete mode.
dan [Tue, 7 Aug 2012 17:41:50 +0000 (17:41 +0000)] 
Add extra tests for secure-delete mode.

FossilOrigin-Name: e380cd3ce34d509e184081ecccf27fda11ce1da7

12 years agoFix a bug in hash.c introduced by [305b66672653].
dan [Tue, 7 Aug 2012 15:19:27 +0000 (15:19 +0000)] 
Fix a bug in hash.c introduced by [305b66672653].

FossilOrigin-Name: 17cb5e951e419b1221ae4595d20059d90a361a39

12 years agoDo not run test script spellfix.test if SQLITE_OMIT_VIRTUAL_TABLE is defined. Fix...
dan [Tue, 7 Aug 2012 14:18:18 +0000 (14:18 +0000)] 
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.

FossilOrigin-Name: 26428b459b45d0fa9fcad7eb5e58bd60b04a0f83

12 years agoFix a bug in walthread.test causing intermittent failures.
dan [Tue, 7 Aug 2012 13:55:41 +0000 (13:55 +0000)] 
Fix a bug in walthread.test causing intermittent failures.

FossilOrigin-Name: a192a718d513002b58ad585fcb3d8b9b49b4b123

12 years agoModify VSIX package generation tool to put the PDB files in the Debug directory.
mistachkin [Mon, 6 Aug 2012 22:29:26 +0000 (22:29 +0000)] 
Modify VSIX package generation tool to put the PDB files in the Debug directory.

FossilOrigin-Name: 9d0720833fd52b25e62aca9ab4cf1e234fd792aa

12 years agoMerge the sorter-coalesce-writes branch into the trunk. This improves CREATE INDEX...
dan [Mon, 6 Aug 2012 19:28:20 +0000 (19:28 +0000)] 
Merge the sorter-coalesce-writes branch into the trunk. This improves CREATE INDEX performance on some platforms.

FossilOrigin-Name: e1e9cb08b011e67b767091e42225f22ec862fa64

12 years agoFix a crash that could follow an OOM condition. sorter-coalesce-writes
dan [Mon, 6 Aug 2012 19:12:17 +0000 (19:12 +0000)] 
Fix a crash that could follow an OOM condition.

FossilOrigin-Name: 2e5741f774248abc678b50711c43e38ca30c9091

12 years agoWhen reusing pages as part of creating a new index, allocate the leaves from each...
dan [Mon, 6 Aug 2012 18:50:11 +0000 (18:50 +0000)] 
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.

FossilOrigin-Name: d045f8b2d44e388d8c4549ff02d4ca7eff4e2038

12 years agoUpdate sorter-coalesce-writes branch with latest trunk changes.
dan [Mon, 6 Aug 2012 18:10:09 +0000 (18:10 +0000)] 
Update sorter-coalesce-writes branch with latest trunk changes.

FossilOrigin-Name: 214f8cda1727e0eee51605be487d4cf4f2dfb6db

12 years agoUpdate description strings in the VSIX package.
mistachkin [Mon, 6 Aug 2012 10:51:55 +0000 (10:51 +0000)] 
Update description strings in the VSIX package.

FossilOrigin-Name: 541e9310a7b88e0b40c6530947803527f28e51de

12 years agoCorrect comment about WinRT compiler define. No changes to code.
mistachkin [Fri, 3 Aug 2012 10:00:56 +0000 (10:00 +0000)] 
Correct comment about WinRT compiler define.  No changes to code.

FossilOrigin-Name: 335e91e599555d9f4e42f90576d1676c381314f4

12 years agoFix typos of function names sqlite3_result_error_toobig and sqlite3_result_error_nome...
mistachkin [Wed, 1 Aug 2012 20:20:27 +0000 (20:20 +0000)] 
Fix typos of function names sqlite3_result_error_toobig and sqlite3_result_error_nomem in the documentation. No changes to code.

FossilOrigin-Name: bec97c98130f057321f3db1436a24377c3c64f81

12 years agoMake the list of platforms dynamic in the SDK manifest inside the VSIX package.
mistachkin [Tue, 31 Jul 2012 08:15:56 +0000 (08:15 +0000)] 
Make the list of platforms dynamic in the SDK manifest inside the VSIX package.

FossilOrigin-Name: 22b72e499d2aeba42d0531ae58f87ff023787f47

12 years agoModify metadata for the VSIX package and add tooling support for PDBs.
mistachkin [Tue, 31 Jul 2012 00:43:31 +0000 (00:43 +0000)] 
Modify metadata for the VSIX package and add tooling support for PDBs.

FossilOrigin-Name: 12cbf6a9343ffb24065f77f679e50b67bc2e43f9

12 years agoReplace a few sqlite3_malloc()+memset() sequences with calls to sqlite3MallocZero().
dan [Mon, 30 Jul 2012 14:53:54 +0000 (14:53 +0000)] 
Replace a few sqlite3_malloc()+memset() sequences with calls to sqlite3MallocZero().

FossilOrigin-Name: 305b6667265353b858b79bfea1745e64ff3bb7d3

12 years agoImprove consistency in handling of build outputs and native library paths in the...
mistachkin [Fri, 27 Jul 2012 23:03:47 +0000 (23:03 +0000)] 
Improve consistency in handling of build outputs and native library paths in the multi-platform build tool for MSVC.

FossilOrigin-Name: e71f2de2cc7c4ef5ee31da81b6615886f6e601e7

12 years agoMinor adjustments to the multi-platform build tool for MSVC.
mistachkin [Fri, 27 Jul 2012 22:29:25 +0000 (22:29 +0000)] 
Minor adjustments to the multi-platform build tool for MSVC.

FossilOrigin-Name: e76b8f7765a91f4306cddb245e731084008f0b8c

12 years agoFor the clean makefile targets, delete the generated VSIX file as well.
mistachkin [Fri, 27 Jul 2012 08:33:10 +0000 (08:33 +0000)] 
For the clean makefile targets, delete the generated VSIX file as well.

FossilOrigin-Name: d575d9619abd03322b73f89882d6da7c0820f285

12 years agoModify the multi-platform build tool for MSVC to support the latest RC version.
mistachkin [Fri, 27 Jul 2012 08:21:45 +0000 (08:21 +0000)] 
Modify the multi-platform build tool for MSVC to support the latest RC version.

FossilOrigin-Name: 95b65883bbf476a17f09ff978df4f51af615baab

12 years agoAdd tool to build the core DLL for multiple platforms using MSVC.
mistachkin [Fri, 27 Jul 2012 07:13:25 +0000 (07:13 +0000)] 
Add tool to build the core DLL for multiple platforms using MSVC.

FossilOrigin-Name: e42f5812f142522852f6dc72430bc7afdd6f2ed3

12 years agoAdd tool to generate a VSIX package usable by Visual Studio 2012 RC.
mistachkin [Fri, 27 Jul 2012 02:36:06 +0000 (02:36 +0000)] 
Add tool to generate a VSIX package usable by Visual Studio 2012 RC.

FossilOrigin-Name: 8b90e0c4dbcedaf3e61c5d49452997705be1ef98

12 years agoUpdate some comments in vdbesort.c.
dan [Thu, 26 Jul 2012 09:21:14 +0000 (09:21 +0000)] 
Update some comments in vdbesort.c.

FossilOrigin-Name: f4b3fded231231ef15bde98d2a996b4e16415d4c

12 years agoMark parameters to sorter interfaces as const where appropriate.
drh [Tue, 24 Jul 2012 19:46:38 +0000 (19:46 +0000)] 
Mark parameters to sorter interfaces as const where appropriate.

FossilOrigin-Name: d8da26f1f43610ac83af2a5d0e170be5abaf7aaa

12 years agoAdd another define to the MSVC makefile that is sometimes required to build cleanly...
mistachkin [Tue, 24 Jul 2012 06:02:35 +0000 (06:02 +0000)] 
Add another define to the MSVC makefile that is sometimes required to build cleanly for WinRT.

FossilOrigin-Name: d582cd890d88e873d76a23545bcd49cf093ee9d2

12 years agoRefactor field names in the SelectDest object to make them distinct and easier
drh [Mon, 23 Jul 2012 21:43:19 +0000 (21:43 +0000)] 
Refactor field names in the SelectDest object to make them distinct and easier
to grep for.

FossilOrigin-Name: b589f1efb3907a68058bf2ee981dca126d083e83

12 years agoFix an edge case in vdbesort.c.
dan [Mon, 23 Jul 2012 20:10:35 +0000 (20:10 +0000)] 
Fix an edge case in vdbesort.c.

FossilOrigin-Name: 4ba266fc534f390267180eca8d68b8d5f0b7f832

12 years agoModify the code in vdbesort.c so that most reads and writes to temporary files are...
dan [Mon, 23 Jul 2012 19:25:39 +0000 (19:25 +0000)] 
Modify the code in vdbesort.c so that most reads and writes to temporary files are aligned page-sized blocks.

FossilOrigin-Name: 55e47ef338c42f95f0f071d6ec92cd2480f9f1fe

12 years agoEnsure that there is always at least one aReadMark slot usable by an unprivileged...
dan [Tue, 17 Jul 2012 14:37:12 +0000 (14:37 +0000)] 
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.

FossilOrigin-Name: e4163596339c2166f9c4356ab824fff8bda8d0b0

12 years agoAmplification of a comment in wal.c. Change the aReadMark[] processing so
drh [Tue, 17 Jul 2012 02:56:05 +0000 (02:56 +0000)] 
Amplification of a comment in wal.c.  Change the aReadMark[] processing so
that one read mark is left at zero when a WAL resets.

FossilOrigin-Name: 8c9ee1d78f99394eef73a177141ca9e1c67e4e07

12 years agoMerge the spellfix1 changes for supporting matchlen into trunk.
drh [Mon, 16 Jul 2012 23:13:19 +0000 (23:13 +0000)] 
Merge the spellfix1 changes for supporting matchlen into trunk.

FossilOrigin-Name: 6f167adf6050632e8c52f9ac4fb5583bcf27c576

12 years agoFix compiler warnings about unused code in spellfix. Fix the editDist3Core() spellfix-matchlen
drh [Mon, 16 Jul 2012 22:16:44 +0000 (22:16 +0000)] 
Fix compiler warnings about unused code in spellfix.  Fix the editDist3Core()
routine to return the matchlen in characters instead of bytes.

FossilOrigin-Name: f96d4e7bd7d81b05b1490bf5d79c77ff583e444c

12 years agoFix a bug in the phonetic-hash routine in spellfix1: Even if the first character...
dan [Mon, 16 Jul 2012 14:52:49 +0000 (14:52 +0000)] 
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.

FossilOrigin-Name: 6333b42dd292e8e567c3fce1c371d6f58021af88

12 years agoMerge trunk changes.
dan [Mon, 16 Jul 2012 10:25:54 +0000 (10:25 +0000)] 
Merge trunk changes.

FossilOrigin-Name: 90df64ab803001819b3ebbb41d596aedbd9961b1

12 years agoIf a specific database is nominated as part of a "PRAGMA integrity_check" or "PRAGMA...
dan [Mon, 16 Jul 2012 10:06:12 +0000 (10:06 +0000)] 
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.

FossilOrigin-Name: 4353e40b74f577f224f190c429bfe03cf6a5c6d6