]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
14 years agoRemove unreachable branches from the 8.3 filename logic.
drh [Wed, 18 May 2011 02:41:10 +0000 (02:41 +0000)] 
Remove unreachable branches from the 8.3 filename logic.

FossilOrigin-Name: 4f7e7b44f2d17681318a1fd22466d3cc03103fc4

14 years agoUpdate multiplex VFS to handle empty filenames which can occur for during vacuuming...
shaneh [Wed, 18 May 2011 02:22:41 +0000 (02:22 +0000)] 
Update multiplex VFS to handle empty filenames which can occur for during vacuuming (temp file names.)

FossilOrigin-Name: a074986045f1a81fb831ffee4a29af13c978b053

14 years agoAdd the ability to limit filenames to 8+3 using the
drh [Tue, 17 May 2011 20:36:21 +0000 (20:36 +0000)] 
Add the ability to limit filenames to 8+3 using the
SQLITE_ENABLE_8_3_NAMES compile-time option together with a URI
parameter of "8_3_names=1".

FossilOrigin-Name: 96d609856025919571f781207dfa6a24b1732e8d

14 years agoFix an off-by-one error in the new sqlite3_uri_parameter() function.
drh [Tue, 17 May 2011 19:43:38 +0000 (19:43 +0000)] 
Fix an off-by-one error in the new sqlite3_uri_parameter() function.

FossilOrigin-Name: 9593a640795458ce6e57e02dd5d702b642858f76

14 years agoAdd the sqlite3_uri_parameter() interface function for use in building
drh [Tue, 17 May 2011 18:53:08 +0000 (18:53 +0000)] 
Add the sqlite3_uri_parameter() interface function for use in building
new VFSes.

FossilOrigin-Name: 6b5de95fb575c7ceb3034068c4f5e0fccb1b15ac

14 years agoAdd extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the...
dan [Tue, 17 May 2011 15:56:16 +0000 (15:56 +0000)] 
Add extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the sqlite tables used internally by a virtual table module are invalid or inconsistent.

FossilOrigin-Name: 8844e8bfb87314fb40ecb92705e8fff88f72bb38

14 years agoAvoid exceeding array bounds when reading a corrupt database file in
drh [Tue, 17 May 2011 15:21:56 +0000 (15:21 +0000)] 
Avoid exceeding array bounds when reading a corrupt database file in
autovacuum mode.  Fixes a problem discovered by John Regehr and Peng Li
using a customized clang compiler.

FossilOrigin-Name: f7c525f5fc31e909721df2b1e66fc62dfb105718

14 years agoAvoid including fts3_term.c in the amalgamation, as it contains test code only.
dan [Tue, 17 May 2011 14:41:36 +0000 (14:41 +0000)] 
Avoid including fts3_term.c in the amalgamation, as it contains test code only.

FossilOrigin-Name: f392b7ae0266b4c694836583cb91b10f2b6c0752

14 years agoEnhance WAL mode so that the WAL file honors the journal size limit set
drh [Mon, 16 May 2011 21:00:27 +0000 (21:00 +0000)] 
Enhance WAL mode so that the WAL file honors the journal size limit set
by PRAGMA journal_size_limit.

FossilOrigin-Name: db7e500f69faf1906a84991ba67d26a195f02ae5

14 years agoMake arrangements so that virtual table inserts into shadow tables do
drh [Fri, 13 May 2011 18:51:42 +0000 (18:51 +0000)] 
Make arrangements so that virtual table inserts into shadow tables do
not modify the sqlite3_last_insert_rowid() return.  Document that this
is how sqlite3_last_insert_rowid() works.

FossilOrigin-Name: e569f18b989aef853c9d71eaf73d6967f0a8c583

14 years agoAlso add fts3_term.c to main.mk.
drh [Fri, 13 May 2011 17:11:20 +0000 (17:11 +0000)] 
Also add fts3_term.c to main.mk.

FossilOrigin-Name: 966f2d2c1f01b6345eab5df87a40d337ced1c087

14 years agoAdd fts3_term.c to amalg gen script and configure input files.
shaneh [Thu, 12 May 2011 21:01:12 +0000 (21:01 +0000)] 
Add fts3_term.c to amalg gen script and configure input files.

FossilOrigin-Name: 6ee0773290a4c4aac2b2b5e1741e65170e08a8bb

14 years agoImprovements to documentation hyperlinks. Change the value of
drh [Wed, 11 May 2011 20:54:32 +0000 (20:54 +0000)] 
Improvements to documentation hyperlinks.  Change the value of
SQLITE_OPEN_URI to an unreserved value.

FossilOrigin-Name: 851ab75d5f5d64d95d6237c28658bbc32145b78b

14 years agoURI filename documentation updates.
drh [Wed, 11 May 2011 19:00:10 +0000 (19:00 +0000)] 
URI filename documentation updates.

FossilOrigin-Name: 8885c8677b239d4cbef24b9409a1736e1ae97a3f

14 years agoHave flags passed to sqlite3_open_v2() apply to the main and any attached databases...
dan [Tue, 10 May 2011 18:39:10 +0000 (18:39 +0000)] 
Have flags passed to sqlite3_open_v2() apply to the main and any attached databases. And change things so that any "mode=xxx" or "cache=xxx" options specified as part of a URI for the main database do not also apply to attached databases.

FossilOrigin-Name: 3e490915301216e242a5cdeb0febaff12ed53cb9

14 years agoUpdate URI test cases to account for the new error message format.
dan [Tue, 10 May 2011 17:43:28 +0000 (17:43 +0000)] 
Update URI test cases to account for the new error message format.

FossilOrigin-Name: 5bde568028216f5bbf76fa0b61bf5b736699f4b1

14 years agoAdd new documentation keywords to the sqlite3_vfs description.
drh [Tue, 10 May 2011 10:17:02 +0000 (10:17 +0000)] 
Add new documentation keywords to the sqlite3_vfs description.

FossilOrigin-Name: ad3389a9ab07f6b811841ffa76a5292719c4487d

14 years agoReturn a suitable error message if the mode= argument to a URI specifies
drh [Mon, 9 May 2011 19:20:17 +0000 (19:20 +0000)] 
Return a suitable error message if the mode= argument to a URI specifies
a higher mode than what is allowed by context.  Other minor cleanups for
the URI parsing logic.

FossilOrigin-Name: d9bc1c7fe0ca5f6973a85827330958f4d09f8171

14 years agoSet the sqlite3.mallocFailed flag if sqlite3ParseUri fails with SQLITE_NOMEM.
drh [Sat, 7 May 2011 18:40:36 +0000 (18:40 +0000)] 
Set the sqlite3.mallocFailed flag if sqlite3ParseUri fails with SQLITE_NOMEM.

FossilOrigin-Name: ca3797d4967361e31a8a5ce1ce8190b095f3ed4c

14 years agoReturn SQLITE_MISUSE from the sqlite3_open_v2() function if the 3rd parameter
drh [Sat, 7 May 2011 18:18:33 +0000 (18:18 +0000)] 
Return SQLITE_MISUSE from the sqlite3_open_v2() function if the 3rd parameter
is not a valid set of bit-values.

FossilOrigin-Name: 3c926ce0976e765b4c51fcd81d251268ff21a741

14 years agoFix minor compiler warnings.
drh [Sat, 7 May 2011 14:40:29 +0000 (14:40 +0000)] 
Fix minor compiler warnings.

FossilOrigin-Name: 139eecbe1b072711a36128f1eeb24fc3e3bacc1c

14 years agoMerge the uri branch with the trunk.
dan [Fri, 6 May 2011 18:55:31 +0000 (18:55 +0000)] 
Merge the uri branch with the trunk.

FossilOrigin-Name: 88df33c45fd5875ea82bc757b239fe3e61663c12

14 years agoRemove some unnecessary modifications from the uri branch. Add a test to show that... uri
dan [Fri, 6 May 2011 18:53:27 +0000 (18:53 +0000)] 
Remove some unnecessary modifications from the uri branch. Add a test to show that ATTACH only interprets its argument as a URI if the connection was opened with SQLITE_OPEN_URI (or URI interpretation is globally enabled).

FossilOrigin-Name: aa90b943254cf348aa2d23ac05e1895b188e2101

14 years agoUpdate comments and documentation associated with new URI parsing code. Add test...
dan [Fri, 6 May 2011 18:34:54 +0000 (18:34 +0000)] 
Update comments and documentation associated with new URI parsing code. Add test file e_uri.test, containing tests mapped to documentation regarding URI filenames.

FossilOrigin-Name: 92751788eae082e3104838cb6dd8b9793cb325d1

14 years agoMerge windows test case fixes. No changes to code.
dan [Fri, 6 May 2011 13:58:03 +0000 (13:58 +0000)] 
Merge windows test case fixes. No changes to code.

FossilOrigin-Name: 2e5c0ed724060388b97e0c0881bb1b68ec1a23b4

14 years agoIncrease the iVersion for sqlite3_module needed for the xSavepoint,
drh [Fri, 6 May 2011 00:19:57 +0000 (00:19 +0000)] 
Increase the iVersion for sqlite3_module needed for the xSavepoint,
xRelease, and xRollbackTo methods from 1 to 2.  This is so that it will
conform to published documentation.

FossilOrigin-Name: 0f4954e9793332573d4ffa0c1e199180f4cb990a

14 years agoFix an incorrect assert() in sqlite3_value_config(). Updates to the
drh [Thu, 5 May 2011 23:07:43 +0000 (23:07 +0000)] 
Fix an incorrect assert() in sqlite3_value_config().  Updates to the
sqlite3_value_config() documentation.

FossilOrigin-Name: 22cbc01a2600c6100112315d9afb5f2d8f80b3df

14 years agoChanges to various test scripts so that they pass on windows. win32-test-fixes
dan [Thu, 5 May 2011 19:44:22 +0000 (19:44 +0000)] 
Changes to various test scripts so that they pass on windows.

FossilOrigin-Name: 1586244b6d86d5a98af8c6f7a8324672e02df9c3

14 years agoHave the xFullpath method in os_win.c discard the initial "/" if a filename begins...
dan [Thu, 5 May 2011 18:53:48 +0000 (18:53 +0000)] 
Have the xFullpath method in os_win.c discard the initial "/" if a filename begins with "/X:", where X is any alphabetic character. Also fix some test issues in uri.test.

FossilOrigin-Name: fe57a8f621944fd2af5a4e9349c8fd77c4aba237

14 years agoFix sqlite3_vtab_on_conflict() to return the correct values for
drh [Thu, 5 May 2011 17:41:58 +0000 (17:41 +0000)] 
Fix sqlite3_vtab_on_conflict() to return the correct values for
ABORT, FAIL, and IGNORE.

FossilOrigin-Name: f0617d619dc6654f6d27543999c0aad724a0d967

14 years agoFix a bug in memory usage tracking that was introduced by
drh [Thu, 5 May 2011 17:00:51 +0000 (17:00 +0000)] 
Fix a bug in memory usage tracking that was introduced by
check-in [4e33a0eaf83922].

FossilOrigin-Name: 8ba456ae0b3d0c0b6f72f98bd0bc28f72dfa4ff5

14 years agoBump the version number to 3.7.7 on account of the new sqlite3_vtab_config()
drh [Thu, 5 May 2011 15:39:50 +0000 (15:39 +0000)] 
Bump the version number to 3.7.7 on account of the new sqlite3_vtab_config()
and sqlite3_vtab_on_conflict() interfaces.  Updates to the documentation on
those interfaces.

FossilOrigin-Name: 930be6a1bdec8c150caafd790973f7a401fc1970

14 years agoChange sqlite3_create_module() so that it avoids resetting the schema as
drh [Thu, 5 May 2011 13:54:28 +0000 (13:54 +0000)] 
Change sqlite3_create_module() so that it avoids resetting the schema as
long as preexisting modules are unchanged.

FossilOrigin-Name: 8485855afc71fb8078d53719c3da75021890ce9e

14 years agoAdd a #include to test_demovfs.c in an effort to get it to compile on Solaris.
drh [Thu, 5 May 2011 13:53:46 +0000 (13:53 +0000)] 
Add a #include to test_demovfs.c in an effort to get it to compile on Solaris.

FossilOrigin-Name: 8f06ea33c9070de8ea85368d76cf26237d1aee73

14 years agoFix a problem in the URI code preventing the amalgamation from building. Add comments...
dan [Thu, 5 May 2011 12:35:33 +0000 (12:35 +0000)] 
Fix a problem in the URI code preventing the amalgamation from building. Add comments describing SQLITE_CONFIG_URI and SQLITE_OPEN_URI to sqlite.h.in.

FossilOrigin-Name: ea562d6d67c2f2ef8baca02a77634c21b945196f

14 years agoMerge latest trunk changes with uri branch.
dan [Wed, 4 May 2011 17:35:12 +0000 (17:35 +0000)] 
Merge latest trunk changes with uri branch.

FossilOrigin-Name: af279f367e01732560b8b2b6aeb5ede4f04415dd

14 years agoMerge vtab-conflict branch with trunk.
dan [Wed, 4 May 2011 17:23:19 +0000 (17:23 +0000)] 
Merge vtab-conflict branch with trunk.

FossilOrigin-Name: 8f9666af5f9459cbd0305a86281d745ea6163acf

14 years agoFix a couple of compiler warnings in the FTS code. vtab-conflict
dan [Wed, 4 May 2011 16:30:05 +0000 (16:30 +0000)] 
Fix a couple of compiler warnings in the FTS code.

FossilOrigin-Name: 1a113359705d307efa1833b1dfa5542b045dae43

14 years agoFix a performance problem in queries that use "ORDER BY rowid DESC" and one or more...
dan [Wed, 4 May 2011 15:41:18 +0000 (15:41 +0000)] 
Fix a performance problem in queries that use "ORDER BY rowid DESC" and one or more FTS auxiliary functions.

FossilOrigin-Name: 95e09b20e9aad28f829c8950f3632debe473070a

14 years agoOptimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables.
dan [Wed, 4 May 2011 12:52:59 +0000 (12:52 +0000)] 
Optimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables.

FossilOrigin-Name: 13395121e3d17ab6581dc5f6736ea324321a374c

14 years agoRemove some unused code related to URI parsing.
dan [Tue, 3 May 2011 15:09:05 +0000 (15:09 +0000)] 
Remove some unused code related to URI parsing.

FossilOrigin-Name: 008cd0ef6b504cf4549468f795aa46f8472f0130

14 years agoAllow only "localhost" and "" as authorities in URIs. Do not allow escapes (%HH)...
dan [Tue, 3 May 2011 11:53:20 +0000 (11:53 +0000)] 
Allow only "localhost" and "" as authorities in URIs. Do not allow escapes (%HH) in the authority part of a URI.

FossilOrigin-Name: b8a0f1b523d1f31c8e7a102ba4bae5935b07104a

14 years agoChange the supported URI options to "mode" and "cache".
dan [Tue, 3 May 2011 10:22:32 +0000 (10:22 +0000)] 
Change the supported URI options to "mode" and "cache".

FossilOrigin-Name: 0a694a0b27e3ce251ce313cb5d19a7637c2fa309

14 years agoMerge the latest trunk changes into uri branch.
dan [Mon, 2 May 2011 17:41:01 +0000 (17:41 +0000)] 
Merge the latest trunk changes into uri branch.

FossilOrigin-Name: 7fdd0786c7e0d66baf3aba4485128e16a4e5ea46

14 years agoHave r-tree virtual tables support on-conflict clauses.
dan [Thu, 28 Apr 2011 18:46:46 +0000 (18:46 +0000)] 
Have r-tree virtual tables support on-conflict clauses.

FossilOrigin-Name: 822ab52f1023b1c4973c806cc75454acd4e95fd0

14 years agoIn windows, ignore ERROR_NOT_LOCKED when calling the read-lock removal
drh [Wed, 27 Apr 2011 19:54:44 +0000 (19:54 +0000)] 
In windows, ignore ERROR_NOT_LOCKED when calling the read-lock removal
routine.

FossilOrigin-Name: f55156c5194e85c47728b8a97fde3e5f0a5c9b56

14 years agoChange the name of an internal function to avoid conflicts with the math
drh [Wed, 27 Apr 2011 18:08:42 +0000 (18:08 +0000)] 
Change the name of an internal function to avoid conflicts with the math
library.

FossilOrigin-Name: 1bd1484cd7e09709d87aa84b82e87597d00a4162

14 years agoExpose the UTF8 to MBCS conversion routine in os_win.c to external
drh [Wed, 27 Apr 2011 16:05:42 +0000 (16:05 +0000)] 
Expose the UTF8 to MBCS conversion routine in os_win.c to external
applications.

FossilOrigin-Name: 7b479b9bee93df909edecd44c7d6584d943b39c9

14 years agoAdd documentation for the newly introduced sqlite3_vtab_config() and on_conflict...
dan [Wed, 27 Apr 2011 16:02:46 +0000 (16:02 +0000)] 
Add documentation for the newly introduced sqlite3_vtab_config() and on_conflict() API functions. Test that encountering an SQLITE_MISMATCH in fts3 does not corrupt the full text index.

FossilOrigin-Name: abdd70ae0424ccadb7edaf16e970c78b5257d23c

14 years agoFix problems related to savepoint rollback and fts3.
dan [Wed, 27 Apr 2011 12:08:04 +0000 (12:08 +0000)] 
Fix problems related to savepoint rollback and fts3.

FossilOrigin-Name: ff69f823f23e6fb6e8b2857c4576d9c0732d9572

14 years agoFix a comment typo.
drh [Wed, 27 Apr 2011 01:00:17 +0000 (01:00 +0000)] 
Fix a comment typo.

FossilOrigin-Name: 19c6625abd5b4e6a4406a8e421ae22527529e305

14 years agoExtra tests for fts3. And fixes for conflict-handling related problems in fts3.
dan [Tue, 26 Apr 2011 19:21:34 +0000 (19:21 +0000)] 
Extra tests for fts3. And fixes for conflict-handling related problems in fts3.

FossilOrigin-Name: fb4a355871d9482ccb28b6ba03b842b3cc87b696

14 years agoAdd support for on conflict clauses to fts3/fts4.
dan [Mon, 25 Apr 2011 18:49:57 +0000 (18:49 +0000)] 
Add support for on conflict clauses to fts3/fts4.

FossilOrigin-Name: 6d2633a6d0a9bb88fb1a6adac0827dc51df2d4d2

14 years agoTest case for the ".log" command to the command-line shell.
drh [Mon, 25 Apr 2011 18:20:04 +0000 (18:20 +0000)] 
Test case for the ".log" command to the command-line shell.

FossilOrigin-Name: 7d0ff26a95cb1e9fcace4641245dda787f3522b4

14 years agoAdd the (deliberately undocumented) sqlite_log() SQL function as a built-in.
drh [Mon, 25 Apr 2011 18:03:10 +0000 (18:03 +0000)] 
Add the (deliberately undocumented) sqlite_log() SQL function as a built-in.

FossilOrigin-Name: f7806e03995b314771aa72a08ce55d56d60096cf

14 years agoInvoke the unix open() system call through a wrapper to avoid problems
drh [Mon, 25 Apr 2011 18:01:27 +0000 (18:01 +0000)] 
Invoke the unix open() system call through a wrapper to avoid problems
resulting from differing declarations to that function in various systems.

FossilOrigin-Name: 4c7ff4dd352276e9c01cc536e188cbcd69396952

14 years agoDisable the transfer optimization if the destination table contains
drh [Sun, 24 Apr 2011 22:56:07 +0000 (22:56 +0000)] 
Disable the transfer optimization if the destination table contains
any foreign key constraint and foreign key constraints are enabled.
Ticket [6284df89debdf].

FossilOrigin-Name: ddeea5ab5f6c0c4a86cdfbbb9f24d9d54bf8d301

14 years agoTest that it is now possible to use different VFSs for two databases attached to...
dan [Sat, 23 Apr 2011 19:06:26 +0000 (19:06 +0000)] 
Test that it is now possible to use different VFSs for two databases attached to a single handle.

FossilOrigin-Name: 2af51f856c6203f836d8bb62b6b79b19554886e7

14 years agoHave the ATTACH command do URI interpretation in the same way as sqlite3_open() and...
dan [Sat, 23 Apr 2011 15:54:54 +0000 (15:54 +0000)] 
Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do.

FossilOrigin-Name: 68240e75e87a54cde93352b0ec364d34365a8170

14 years agoFix parsing of %00 in uri handling code.
dan [Sat, 23 Apr 2011 10:12:30 +0000 (10:12 +0000)] 
Fix parsing of %00 in uri handling code.

FossilOrigin-Name: 44f0874a95408c75a296964a04eef00341abb94a

14 years agoAdd the "getlock" utility for determining if a database file (on unix) is
drh [Fri, 22 Apr 2011 22:55:10 +0000 (22:55 +0000)] 
Add the "getlock" utility for determining if a database file (on unix) is
currently locked.

FossilOrigin-Name: 0ab24b133e332ad7f4517b8e113e9c241ee9af9f

14 years agoAdd the start of the "uri-filenames" feature.
dan [Fri, 22 Apr 2011 19:37:32 +0000 (19:37 +0000)] 
Add the start of the "uri-filenames" feature.

FossilOrigin-Name: b8a8132e7148a7c90ca1352f20ab71d97b0bc4b0

14 years agoUpdate a comment in e_createtable.test.
dan [Wed, 20 Apr 2011 13:35:44 +0000 (13:35 +0000)] 
Update a comment in e_createtable.test.

FossilOrigin-Name: d8b149f5e465f7794739ed0210e1e5c53110ee9a

14 years agoAvoid passing NULL to the xOpen method of an FTS3/4 tokenizer.
dan [Tue, 19 Apr 2011 06:43:22 +0000 (06:43 +0000)] 
Avoid passing NULL to the xOpen method of an FTS3/4 tokenizer.

FossilOrigin-Name: 0dd09fc034c127718366d3a3183e367d2f9fd82d

14 years agoChange the prototype for the open() system call to agree with Posix. Though
drh [Sun, 17 Apr 2011 17:09:58 +0000 (17:09 +0000)] 
Change the prototype for the open() system call to agree with Posix.  Though
a faulty function prototype in a pointer cast is a seemingly innocuous error,
the correct prototype is necessary for pthreads to work correctly on NetBSD.

FossilOrigin-Name: 3e135748f1efacb52b414b3ac3f4ae2c08bcd8fb

14 years agoAdjust some test cases in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPT...
shaneh [Sun, 17 Apr 2011 00:55:13 +0000 (00:55 +0000)] 
Adjust some test cases in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings.

FossilOrigin-Name: 9d6c6129fd8be42c164f14bb90011b252c1f2c46

14 years agoAdjust test case in quota.test to handle Windows dir seperators.
shaneh [Fri, 15 Apr 2011 21:37:33 +0000 (21:37 +0000)] 
Adjust test case in quota.test to handle Windows dir seperators.

FossilOrigin-Name: 75ed1bcee85587ddd54269156aa53df5f456a6c4

14 years agoUpdates to test code in os_win to bring winSync inline with unixSync (test code only).
shaneh [Fri, 15 Apr 2011 20:18:40 +0000 (20:18 +0000)] 
Updates to test code in os_win to bring winSync inline with unixSync (test code only).
Updated a few test scripts to account for dirsync counting issues on Windows.

FossilOrigin-Name: 8f99c5bf639ee4f6384cc3c2d7f056d1b08e4f16

14 years agoRemove stray semi-colon that MSVC complained about.
shaneh [Fri, 15 Apr 2011 19:30:42 +0000 (19:30 +0000)] 
Remove stray semi-colon that MSVC complained about.

FossilOrigin-Name: 7a085271ff85033479c2057c19a45a750168d228

14 years agoChanges to memory allocator usage tracking to delay the onset of integer
drh [Fri, 15 Apr 2011 16:39:52 +0000 (16:39 +0000)] 
Changes to memory allocator usage tracking to delay the onset of integer
overflow.

FossilOrigin-Name: 4e33a0eaf83922926f8d5ee988a20439a09bc795

14 years agoDo not do full table scans of unordered indices.
drh [Fri, 15 Apr 2011 14:46:27 +0000 (14:46 +0000)] 
Do not do full table scans of unordered indices.

FossilOrigin-Name: a8761a9128de945aa4b6196df5ffe64115d66b61

14 years agoFix #ifs involving SQLITE_ENABLE_LOCKING_STYLE so that they check the value of
drh [Fri, 15 Apr 2011 14:33:20 +0000 (14:33 +0000)] 
Fix #ifs involving SQLITE_ENABLE_LOCKING_STYLE so that they check the value of
that macro and not whether it is defined.

FossilOrigin-Name: 8775f159c129e1ee36a1a13c362184713376bd40

14 years agoMake sure the unix backend returns SQLITE_FULL if write() fails with an
drh [Fri, 15 Apr 2011 12:36:10 +0000 (12:36 +0000)] 
Make sure the unix backend returns SQLITE_FULL if write() fails with an
ENOSPC error code.

FossilOrigin-Name: 721e3c16b389a43f5d7c47a8fd0294473a39dad2

14 years agoRemove extra CR and NL characters from FormatMessage() generated error
drh [Wed, 13 Apr 2011 23:42:53 +0000 (23:42 +0000)] 
Remove extra CR and NL characters from FormatMessage() generated error
messages in the windows VFS.

FossilOrigin-Name: 8332949c28ac72890de82b49bc11f02064b2647d

14 years agoAdd new extended error codes for I/O errors on seek and shared-memory map.
drh [Wed, 13 Apr 2011 20:26:13 +0000 (20:26 +0000)] 
Add new extended error codes for I/O errors on seek and shared-memory map.
Add sqlite3_log() calls in the windows backend to record details of errors.

FossilOrigin-Name: fe603217fce8e3a696bd108d5ae7f7a291b7e215

14 years agoFix a usage comment typo in the showdb utility.
drh [Wed, 13 Apr 2011 16:52:41 +0000 (16:52 +0000)] 
Fix a usage comment typo in the showdb utility.

FossilOrigin-Name: 8744ced4ec495852b7aa2de573001cb4993e6328

14 years agoVersion 3.7.6.1 version-3.7.6.1
drh [Wed, 13 Apr 2011 14:40:25 +0000 (14:40 +0000)] 
Version 3.7.6.1

FossilOrigin-Name: a35e83eac7b185f4d363d7fa51677f2fdfa27695

14 years agoBump the version number to 3.7.6.1 in preparation for a bug-fix release.
drh [Wed, 13 Apr 2011 14:02:43 +0000 (14:02 +0000)] 
Bump the version number to 3.7.6.1 in preparation for a bug-fix release.

FossilOrigin-Name: 5f0c394a5ab308946e72f20d6351c08c6737c63f

14 years agoMake sure the array of overloadable system calls is always correctly
drh [Wed, 13 Apr 2011 13:42:25 +0000 (13:42 +0000)] 
Make sure the array of overloadable system calls is always correctly
sized, regardless of the compile-time configuration.
Ticket [bb3a86e890c8e96ab].

FossilOrigin-Name: c6e727ab3b16e71b0151673bb24b0bafec368ee6

14 years agoVersion 3.7.6. version-3.7.6
drh [Tue, 12 Apr 2011 01:58:40 +0000 (01:58 +0000)] 
Version 3.7.6.

FossilOrigin-Name: f9d43fa363d54beab6f45db005abac0a7c0c47a7

14 years agoDo not override the fchmod system call in unix unless the
drh [Mon, 11 Apr 2011 18:35:09 +0000 (18:35 +0000)] 
Do not override the fchmod system call in unix unless the
SQLITE_ENABLE_LOCKING_STYLE compile-time option is engaged.

FossilOrigin-Name: 51029d8430d2dbc782f161577d47e3dd11c4e4d7

14 years agoUpdates to the OS/2 patches. This change also move the location of a global
drh [Mon, 11 Apr 2011 15:36:26 +0000 (15:36 +0000)] 
Updates to the OS/2 patches.  This change also move the location of a global
variable declaration in shell.c which might effect other build targets.

FossilOrigin-Name: 73906b67dc920e0c36e68ef9a302be3b495e8e3a

14 years agoFix a signed integer overflow problem in the testcase() macro.
drh [Mon, 11 Apr 2011 15:35:24 +0000 (15:35 +0000)] 
Fix a signed integer overflow problem in the testcase() macro.

FossilOrigin-Name: f18f5f5893a0d37ecedcfcfdddbe06cdbe0b4243

14 years agoApply OS2 WAL patch. Changes to os_os2.c only.
dan [Mon, 11 Apr 2011 13:57:26 +0000 (13:57 +0000)] 
Apply OS2 WAL patch. Changes to os_os2.c only.

FossilOrigin-Name: eac17106808fa54551a18ff9b44f8370cb5d7160

14 years agoChange exists.test to run all tests with and without "PRAGMA journal_mode=WAL".
dan [Mon, 11 Apr 2011 05:38:31 +0000 (05:38 +0000)] 
Change exists.test to run all tests with and without "PRAGMA journal_mode=WAL".

FossilOrigin-Name: c4e624db1a981fe6e520af51efc6ce33bca2c714

14 years agoAdd a simple test program to aid in verifying that journals are cross-platform.
drh [Sun, 10 Apr 2011 16:39:23 +0000 (16:39 +0000)] 
Add a simple test program to aid in verifying that journals are cross-platform.

FossilOrigin-Name: a65a7a59d19a64ba1aec388d23ada79aaaaa6f26

14 years agoAdd test file unordered.test.
dan [Sat, 9 Apr 2011 19:17:49 +0000 (19:17 +0000)] 
Add test file unordered.test.

FossilOrigin-Name: f346dae1278b5b0cc0cd8e05aa3b4d8f70d2dc1d

14 years agoRemove an always-true conditional. Replace it with an assert().
drh [Sat, 9 Apr 2011 17:53:30 +0000 (17:53 +0000)] 
Remove an always-true conditional.  Replace it with an assert().

FossilOrigin-Name: 1c2f0f8477bcf251fe874a2cfae4d7a403cb88ff

14 years agoAdd VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the specified...
dan [Sat, 9 Apr 2011 17:32:58 +0000 (17:32 +0000)] 
Add VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the specified database object does not exist when the statement is prepared.

FossilOrigin-Name: a46f32900a013aa6bb2dad2a9ed3ce00ab2493fd

14 years agoAdd an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. This way...
dan [Sat, 9 Apr 2011 15:39:02 +0000 (15:39 +0000)] 
Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. This way, if the specified database object existed when the statement was compiled but removed from the database before sqlite3_step() was called, the statement still works as expected (and creates the object).

FossilOrigin-Name: b9dbd9936191666c3fc9889e938344a82cc03aeb

14 years agoIf the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT
drh [Sat, 9 Apr 2011 03:20:59 +0000 (03:20 +0000)] 
If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT
column for an index, then use that index for equality lookups only, never
for range queries or sorting.  This feature is currently undocumented and
my change or be removed in a future release.

FossilOrigin-Name: 8a42e236701c8afd9ada7d4568712a21690ea087

14 years agoBack out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-option. It is an unneeded
drh [Sat, 9 Apr 2011 03:04:13 +0000 (03:04 +0000)] 
Back out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-option.  It is an unneeded
complication.

FossilOrigin-Name: 927e955b93e869727c55b784401de3ea07bee257

14 years agoWhen ATTACH-ing a new database to an existing database with a codec, do
drh [Sat, 9 Apr 2011 02:34:33 +0000 (02:34 +0000)] 
When ATTACH-ing a new database to an existing database with a codec, do
not enable the codec in the attached database if it is not enabled in the
existing database and it is not requested by the USING clause.

FossilOrigin-Name: 4caa5fc86e7fe404cd188713277f2801cd02dbc9

14 years agoDo not do a backup if the number of reserved bytes in the source and
drh [Sat, 9 Apr 2011 02:09:44 +0000 (02:09 +0000)] 
Do not do a backup if the number of reserved bytes in the source and
destination do not match.  Try to make the match, but if unable fail.

FossilOrigin-Name: 0ca8a2332b28d88585dc890e5162b095e783fc20

14 years agoAlways make sure the left-hand side of the IS NOT NULL operator is a
drh [Fri, 8 Apr 2011 21:35:26 +0000 (21:35 +0000)] 
Always make sure the left-hand side of the IS NOT NULL operator is a
smiple column, not a general expression, before applying the IS NOT NULL
query optimization.

FossilOrigin-Name: 543f75a6abe3aa4f49df43e71a462702d40b3251

14 years agoAdd some rtree tests to the backcompat.test script.
dan [Fri, 8 Apr 2011 18:47:24 +0000 (18:47 +0000)] 
Add some rtree tests to the backcompat.test script.

FossilOrigin-Name: 8ea3601cd11088ae4d62bd4a05d1675301b26ace

14 years agoFix incrvacuum2.test so that it works with the inmemory_journal permutation.
dan [Fri, 8 Apr 2011 17:22:30 +0000 (17:22 +0000)] 
Fix incrvacuum2.test so that it works with the inmemory_journal permutation.

FossilOrigin-Name: 7b8e176143bb8b55e34fd70cbfa639b1097b2c34

14 years agoChange two new internal functions in where.c from global to file scope.
drh [Thu, 7 Apr 2011 19:56:21 +0000 (19:56 +0000)] 
Change two new internal functions in where.c from global to file scope.

FossilOrigin-Name: 5bbfa17d4d6db18f8077f758d70c1bc253b58e2e

14 years agoAdd test case to verify [d03d63d77e] works.
dan [Thu, 7 Apr 2011 15:24:08 +0000 (15:24 +0000)] 
Add test case to verify [d03d63d77e] works.

FossilOrigin-Name: bf78acb9dfacde0f08a5b3ceac13480f12a06168

14 years agoWhen searching a list of freelist trunk pages looking for a specific page
drh [Thu, 7 Apr 2011 14:47:01 +0000 (14:47 +0000)] 
When searching a list of freelist trunk pages looking for a specific page
to allocate, avoid unnecessary journalling of the unchanged trunk pages towards
the start of the list.

FossilOrigin-Name: d03d63d77ed144ac2c02a0245c4b4b070b79c88e