]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
13 years agoIf the read() system call in unix returns fewer bytes than expected, retry retry-short-reads
drh [Tue, 1 Nov 2011 15:45:28 +0000 (15:45 +0000)] 
If the read() system call in unix returns fewer bytes than expected, retry
it until it either returns zero or an error.

FossilOrigin-Name: 72256634773f6cba0aabaa3c953cd5daefd50e67

13 years agoVersion 3.7.9 version-3.7.9
drh [Tue, 1 Nov 2011 00:52:41 +0000 (00:52 +0000)] 
Version 3.7.9

FossilOrigin-Name: c7c6050ef060877ebe77b41d959e9df13f8c9b5e

13 years agoFix a typo in a comment. No code changes.
drh [Mon, 31 Oct 2011 12:25:01 +0000 (12:25 +0000)] 
Fix a typo in a comment.  No code changes.

FossilOrigin-Name: 6635cd9a7714b681dd8aa96e90be462a40d10178

13 years agoAdd new file ext/fts3/README.content, describing the experimental FTS4 content option.
dan [Mon, 31 Oct 2011 11:36:29 +0000 (11:36 +0000)] 
Add new file ext/fts3/README.content, describing the experimental FTS4 content option.

FossilOrigin-Name: 13a9d085e1a5654a97b8d26bae7182ca6c0c237b

13 years agoUpdate fts3fault.test to account for the sqlite3_errmsg() related changes in [8f88cc4...
dan [Mon, 31 Oct 2011 06:52:51 +0000 (06:52 +0000)] 
Update fts3fault.test to account for the sqlite3_errmsg() related changes in [8f88cc4e61] and [dcb7879347].

FossilOrigin-Name: 3f2d49c6786beb6ff9d56376364ebc6cd9136346

13 years agoUpdate fkey_malloc.test to account for the sqlite3_errmsg() related changes in [8f88c...
dan [Sat, 29 Oct 2011 19:25:08 +0000 (19:25 +0000)] 
Update fkey_malloc.test to account for the sqlite3_errmsg() related changes in [8f88cc4e61] and [dcb7879347].

FossilOrigin-Name: 5b82ec6fbbd2f4195ad06dd911de3817373ad5bf

13 years agoAdd a test for [48f29963] that does not depend on FTS.
dan [Sat, 29 Oct 2011 15:29:43 +0000 (15:29 +0000)] 
Add a test for [48f29963] that does not depend on FTS.

FossilOrigin-Name: fb15f5458eb3e17ce9795c09bffe1224fea0eecd

13 years agoFix some code formatting in sqlite3Ext.h to avoid lines longer than 80
drh [Sat, 29 Oct 2011 12:42:31 +0000 (12:42 +0000)] 
Fix some code formatting in sqlite3Ext.h to avoid lines longer than 80
characters.

FossilOrigin-Name: 3ec20c3020e1bb5ec2815848af75cf4847a218e5

13 years agoAvoid attempting to call savepoint related methods on deleted sqlite3_vtab objects...
dan [Sat, 29 Oct 2011 11:43:04 +0000 (11:43 +0000)] 
Avoid attempting to call savepoint related methods on deleted sqlite3_vtab objects. Fix for [48f299634a].

FossilOrigin-Name: 3565fcf898960d7a23d23a2f363b039b2e29447b

13 years agoAvoid reporting a NOMEM error if a memory allocation fails while copying
drh [Sat, 29 Oct 2011 01:33:24 +0000 (01:33 +0000)] 
Avoid reporting a NOMEM error if a memory allocation fails while copying
the error message from a prepared statement into the database connection.

FossilOrigin-Name: dcb78793474e533c3e4f5c6389ba3c997f062eee

13 years agoIf an error occurs within sqlite3_step() on a statement prepared using sqlite3_prepar...
dan [Thu, 27 Oct 2011 15:19:58 +0000 (15:19 +0000)] 
If an error occurs within sqlite3_step() on a statement prepared using sqlite3_prepare_v2(), transfer both the error code and error message to the database handle before sqlite3_step() returns (so that they are available via sqlite3_errcode() and sqlite3_errmsg(). Prior to this commit, only the error code was transfered. The error message was not available until after either sqlite3_reset() or sqlite3_finalize() had been called on the statement handle.

FossilOrigin-Name: 8f88cc4e616b4b30ed349f89e148f782da5cb6c4

13 years agoAvoid a harmless reference to an uninitialized variable following an
drh [Sat, 22 Oct 2011 21:00:46 +0000 (21:00 +0000)] 
Avoid a harmless reference to an uninitialized variable following an
error in FTS3.  This is not a bug.  The change is to silence a valgrind
warning.

FossilOrigin-Name: d980c5b22fd700afb3cac5de5501c9350f2f589e

13 years agoPurge lingering references to SQLITE_STAT2 from the code and test scripts.
drh [Fri, 21 Oct 2011 19:06:32 +0000 (19:06 +0000)] 
Purge lingering references to SQLITE_STAT2 from the code and test scripts.

FossilOrigin-Name: aed2bf7a3c828a7191389b3f8235a9387977b476

13 years agoRemove stale requirements marks from the query planner.
drh [Fri, 21 Oct 2011 16:47:31 +0000 (16:47 +0000)] 
Remove stale requirements marks from the query planner.

FossilOrigin-Name: 76de9914bed11abda3898928633ad09d5a284f84

13 years agoIf an error occurs while writing to the database file during a VACUUM, discard the...
dan [Fri, 21 Oct 2011 14:27:32 +0000 (14:27 +0000)] 
If an error occurs while writing to the database file during a VACUUM, discard the contents of the in-memory cache. This is required as if the database is a zipvfs database, the contents of the cache may be inconsistent with respect to the database as stored on disk.

FossilOrigin-Name: 07159e84b40b01fa40cac5fad1f433888e5984f8

13 years agoFix an issue with finding the access permissions of journal files when
drh [Thu, 20 Oct 2011 18:23:35 +0000 (18:23 +0000)] 
Fix an issue with finding the access permissions of journal files when
8+3 filenames are in use.

FossilOrigin-Name: 2b35c5144ddcc2ed6d0fcaa8c0ba5d20b9487be7

13 years agoEnhancements to the omittest.tcl script used to verify that the
drh [Thu, 20 Oct 2011 00:55:54 +0000 (00:55 +0000)] 
Enhancements to the omittest.tcl script used to verify that the
SQLITE_OMIT compile-time options are working.

FossilOrigin-Name: 4344483f7d7f64dffadde0053e6c745948db9486

13 years agoFix harmless compiler warnings in FTS4.
drh [Wed, 19 Oct 2011 18:21:47 +0000 (18:21 +0000)] 
Fix harmless compiler warnings in FTS4.

FossilOrigin-Name: 1af4a25631c4077a9bfc64e15eb92fbf5146c89c

13 years agoFix comments on SQLITE_CONFIG_HEAP so that they do not interfere with the
drh [Wed, 19 Oct 2011 17:13:08 +0000 (17:13 +0000)] 
Fix comments on SQLITE_CONFIG_HEAP so that they do not interfere with the
requirements scanner.

FossilOrigin-Name: a3151ce15c256219646013d695b6e162e306cef8

13 years agoMerge the fts4-content branch with the trunk.
dan [Wed, 19 Oct 2011 16:20:40 +0000 (16:20 +0000)] 
Merge the fts4-content branch with the trunk.

FossilOrigin-Name: 8a4077057ddeb08e8edc5f20a75abaaba7a278ba

13 years agoHave FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables. fts4-content
dan [Wed, 19 Oct 2011 15:52:48 +0000 (15:52 +0000)] 
Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables.

FossilOrigin-Name: df36ac948179f37b432a88701b6c79299e073ce8

13 years agoChange the way ^ tokens work in FTS so that the filtering is done as part of reading...
dan [Wed, 19 Oct 2011 11:57:13 +0000 (11:57 +0000)] 
Change the way ^ tokens work in FTS so that the filtering is done as part of reading the FTS index instead of waiting until an entire doclist has been retrieved and then filtering it.

FossilOrigin-Name: 9b58c59eb4efaa38ce50a3ce1b52f9ba578c71d6

13 years agoAdd tests for FTS ^ searches and matchinfo().
dan [Wed, 19 Oct 2011 10:18:01 +0000 (10:18 +0000)] 
Add tests for FTS ^ searches and matchinfo().

FossilOrigin-Name: 92618c1463fb304cf8057d082b2c7096152dff27

13 years agoFix a problem in FTS to do with ^ tokens and the snippet() function.
dan [Wed, 19 Oct 2011 09:40:49 +0000 (09:40 +0000)] 
Fix a problem in FTS to do with ^ tokens and the snippet() function.

FossilOrigin-Name: 2c03b24f4cc6f2c28c9d5b9984320d41b8486c32

13 years agoFix the virtual table rename logic so that it works even if the database
drh [Tue, 18 Oct 2011 22:07:47 +0000 (22:07 +0000)] 
Fix the virtual table rename logic so that it works even if the database
encoding is something other than UTF8.
Ticket [8290242b2a9a81683]

FossilOrigin-Name: d65f63531c3f8e3e55e656f049240714a3d7433f

13 years agoIf a token within an FTS query is prefixed with a '^' character, it must be the first...
dan [Tue, 18 Oct 2011 19:39:41 +0000 (19:39 +0000)] 
If a token within an FTS query is prefixed with a '^' character, it must be the first token in a column of data to match.

FossilOrigin-Name: 63ac33c860eb32ce96699f06bf83121cec2ffaca

13 years agoFix an uninitialized variable in OR-clause processing.
drh [Tue, 18 Oct 2011 19:14:33 +0000 (19:14 +0000)] 
Fix an uninitialized variable in OR-clause processing.

FossilOrigin-Name: 54aecd929867606d14a062b501abbfb6f5f05e37

13 years agoImproved handling of USING and NATURAL JOIN in 3-way and higher joins.
drh [Tue, 18 Oct 2011 18:10:40 +0000 (18:10 +0000)] 
Improved handling of USING and NATURAL JOIN in 3-way and higher joins.
Ticket [3338b3fa19ac4ab]

FossilOrigin-Name: 551ce407bd77149865423511bd52eba2f404161a

13 years agoCherrypick patch [3126754c72] from the trunk into the content= branch.
dan [Tue, 18 Oct 2011 12:49:59 +0000 (12:49 +0000)] 
Cherrypick patch [3126754c72] from the trunk into the content= branch.

FossilOrigin-Name: f9b5b217088a6aeb25eba184ab92d1a842a680a6

13 years agoFix a floating-point exception that can occur when an FTS4 query contains a large...
dan [Tue, 18 Oct 2011 12:44:04 +0000 (12:44 +0000)] 
Fix a floating-point exception that can occur when an FTS4 query contains a large number of tokens connected by AND or NEAR operators.

FossilOrigin-Name: 3126754c72351c724be29d75a194bfc3e7b67205

13 years agoChange the OP_JournalMode implementation so that it works even if a
drh [Mon, 17 Oct 2011 23:15:31 +0000 (23:15 +0000)] 
Change the OP_JournalMode implementation so that it works even if a
substitute sqlite3PagerFilename() that might return NULL is used.

FossilOrigin-Name: 491ff5fb2504173d6905e38b8ea35737338aaa84

13 years agoAvoid 32-bit integer overflow when evaluating the exponent of a floating point
drh [Mon, 17 Oct 2011 20:41:46 +0000 (20:41 +0000)] 
Avoid 32-bit integer overflow when evaluating the exponent of a floating point
value during ascii to binary conversion.

FossilOrigin-Name: 4becc47eb4d48686faca4f61e93e5f379b227fcc

13 years agoPerformance improvement for ascii to floating-point conversions with very
drh [Mon, 17 Oct 2011 12:14:26 +0000 (12:14 +0000)] 
Performance improvement for ascii to floating-point conversions with very
large exponents.

FossilOrigin-Name: 59bb999c8ba5e4ee7a4e388fc724b8606136d60c

13 years agoAdded the tool/warnings-clang.sh script. Changes so that there are no
drh [Sat, 15 Oct 2011 00:16:30 +0000 (00:16 +0000)] 
Added the tool/warnings-clang.sh script.  Changes so that there are no
warnings with either gcc or clang even including FTS4 and RTREE and
both with and without SQLITE_THREADSAFE=0.

FossilOrigin-Name: 39408702a989f907261c298bf0947f3e68bd10fe

13 years agoFix a few minor and harmless clang warnings in FTS3 and RTREE.
drh [Fri, 14 Oct 2011 22:57:03 +0000 (22:57 +0000)] 
Fix a few minor and harmless clang warnings in FTS3 and RTREE.

FossilOrigin-Name: b3324f6cc27c3bfb32b12eacace2fc731c2dd644

13 years agoAdd assert() statements and eliminate needless variable assignments in order
drh [Fri, 14 Oct 2011 21:49:18 +0000 (21:49 +0000)] 
Add assert() statements and eliminate needless variable assignments in order
to get the clang scan-build utility to report zero problems against the
SQLite core.  Clang's static analysis did find one real problem - but it was
in the command-line shell, not in the SQLite core.

FossilOrigin-Name: 60fee9574b0125705787e33c16f116cf188c8323

13 years agoChange the makefile to delete both plain and ".exe" variants of build tools.
drh [Thu, 13 Oct 2011 18:08:04 +0000 (18:08 +0000)] 
Change the makefile to delete both plain and ".exe" variants of build tools.
Ticket [92bd6eaf04e117]

FossilOrigin-Name: 19536a382815c2ff4cb23625984b4ca92e5e17ee

13 years agoSimplifications to the upper() and lower() SQL functions.
drh [Thu, 13 Oct 2011 18:00:11 +0000 (18:00 +0000)] 
Simplifications to the upper() and lower() SQL functions.
Updates to documentation on sqlite3_bind_text() and sqlite3_result_text()
to make it clear that users should not try to create strings with
embedded NULs and that if they do the result of expression on those strings
is undefined.  Ticket [57c971fc74524a]

FossilOrigin-Name: 9984cc20ca70b7fb39c0b99580a1317a7b0c9c85

13 years agoHandle updating the only row of an FTS table correctly. Fix for [9fd058691].
dan [Thu, 13 Oct 2011 17:16:45 +0000 (17:16 +0000)] 
Handle updating the only row of an FTS table correctly. Fix for [9fd058691].

FossilOrigin-Name: 7e24645be2fe0ffe092212e7bcfa5b4500305811

13 years agoAn improved fix for the page_count and quick_check problem previously
drh [Thu, 13 Oct 2011 17:09:01 +0000 (17:09 +0000)] 
An improved fix for the page_count and quick_check problem previously
patched at [150592b4b4d8637]

FossilOrigin-Name: c3cb7f4fad725d5fa4d5acd9da63fc4538ce8e13

13 years agoProvide a complete prototype for isatty() in the command-line shell sources.
drh [Thu, 13 Oct 2011 16:36:29 +0000 (16:36 +0000)] 
Provide a complete prototype for isatty() in the command-line shell sources.

FossilOrigin-Name: 8bf13b036a77af9984f8f3d3a93da589fafd773f

13 years agoChange the command-line shell to do the ".dump" inside of a SAVEPOINT
drh [Thu, 13 Oct 2011 16:30:13 +0000 (16:30 +0000)] 
Change the command-line shell to do the ".dump" inside of a SAVEPOINT
rather than a transaction, since this allows it to be run from within
a transaction.

FossilOrigin-Name: 6df7343b4c3de9ad8221180dc959dbbdf54733c7

13 years agoEnable large-file support for fopen() and friends in the command-line shell.
drh [Thu, 13 Oct 2011 16:02:17 +0000 (16:02 +0000)] 
Enable large-file support for fopen() and friends in the command-line shell.
Ticket [92af7da36b6fbd]

FossilOrigin-Name: eeeba4f0d2207ec26c60a405e2705e5d40022dbb

13 years agoMake sure the query optimizer for aggregate queries knows that expressions
drh [Thu, 13 Oct 2011 15:35:52 +0000 (15:35 +0000)] 
Make sure the query optimizer for aggregate queries knows that expressions
(x='a') and (x='A') are different.  Ticket [fa7bf5ec94801e7e]

FossilOrigin-Name: e43da426e66e6b63d5ed9610a6308aba0089313b

13 years agoMake sure the page_count and quick_check pragmas work properly even when
drh [Thu, 13 Oct 2011 14:41:22 +0000 (14:41 +0000)] 
Make sure the page_count and quick_check pragmas work properly even when
their names are capitalized.  Fixes a problem reported on the mailing list.

FossilOrigin-Name: 150592b4b4d86372e70332d4f69e41a04c4c54c3

13 years agoAdjust the symbols.sh script for STAT3. Add the symbols-mingw.sh script for
drh [Thu, 13 Oct 2011 14:18:51 +0000 (14:18 +0000)] 
Adjust the symbols.sh script for STAT3.  Add the symbols-mingw.sh script for
testing on windows with MinGW.

FossilOrigin-Name: c41d1d4652b8c7608322e9360c30f06965fd0942

13 years agoMake sure all non-API functions in os_win.c have file scope.
drh [Thu, 13 Oct 2011 14:05:32 +0000 (14:05 +0000)] 
Make sure all non-API functions in os_win.c have file scope.
Ticket [35c54c874987]

FossilOrigin-Name: 17e4fde5c541f1bba723386938b6123b2431bffc

13 years agoDo the ".dump" command inside of a transaction to prevent other processes
drh [Thu, 13 Oct 2011 13:34:04 +0000 (13:34 +0000)] 
Do the ".dump" command inside of a transaction to prevent other processes
from modifying the database while the dump is underway.
Ticket [2466653295e65]

FossilOrigin-Name: 1c00d5454c85dfddb6c628c3742b4ddeaad6423a

13 years agoFix a harmless compiler warning introduced into os_unix.c by one of the
drh [Thu, 13 Oct 2011 01:01:14 +0000 (01:01 +0000)] 
Fix a harmless compiler warning introduced into os_unix.c by one of the
recent changes.

FossilOrigin-Name: 4bf4d5ebfbf5d157a8bf3a3817e2ce350f25af0e

13 years agoIf errors are encountered while processing the ".dump" command in the
drh [Thu, 13 Oct 2011 00:41:49 +0000 (00:41 +0000)] 
If errors are encountered while processing the ".dump" command in the
command-line shell, print error messages as comments in the output and
ROLLBACK at the end rather than committing.
Ticket [ee19e690ec9a5a2]

FossilOrigin-Name: 8a8dcd6bd043d82dc04b6ad0614c64d20ace8e5f

13 years agoBe sure to allocate plenty of space for error messages coming out of
drh [Thu, 13 Oct 2011 00:11:36 +0000 (00:11 +0000)] 
Be sure to allocate plenty of space for error messages coming out of
sqlite3_load_extension(), so that filenames and procedure names are
not truncated.  Ticket [7d32c69b50f89d]

FossilOrigin-Name: af8bcdd951c31f69966942d67833da30f6b121bf

13 years agoThe sqlite3_overload_function() interface returns an error if it is unable
drh [Wed, 12 Oct 2011 23:49:49 +0000 (23:49 +0000)] 
The sqlite3_overload_function() interface returns an error if it is unable
to create the overload function.  Ticket [20f9d4fbbff3a3]

FossilOrigin-Name: d5b6b374c5225d21c386fb3d6507d3938296e759

13 years agoThe date/time functions return NULL if the xCurrentTime or
drh [Wed, 12 Oct 2011 23:13:43 +0000 (23:13 +0000)] 
The date/time functions return NULL if the xCurrentTime or
xCurrentTimeInt64 VFS methods fail.
Ticket [0b803bff856c644c]

FossilOrigin-Name: c96651dd6ceadd51c9e1f4d942177d3c128c47b4

13 years agoSuppress a compiler warning that occurs with SQLITE_OMIT_VIRTUALTABLE.
drh [Wed, 12 Oct 2011 19:04:07 +0000 (19:04 +0000)] 
Suppress a compiler warning that occurs with SQLITE_OMIT_VIRTUALTABLE.

FossilOrigin-Name: 6bedb49d68f2960a6fc4701d02e177789abf9099

13 years agoClean up obsolete comments in printf.c.
drh [Wed, 12 Oct 2011 18:52:59 +0000 (18:52 +0000)] 
Clean up obsolete comments in printf.c.

FossilOrigin-Name: 97ef4f5013731fa3a0f72451b7e8c9aec5523104

13 years agoClarify a comment and fix a code formatting issue in btree.c.
drh [Wed, 12 Oct 2011 17:00:28 +0000 (17:00 +0000)] 
Clarify a comment and fix a code formatting issue in btree.c.

FossilOrigin-Name: 4f1a558d0013fbf3fe00bdf5883e61a1f3779831

13 years agoPut in code to defend against signed/unsigned character problems
drh [Tue, 11 Oct 2011 20:41:54 +0000 (20:41 +0000)] 
Put in code to defend against signed/unsigned character problems
in the command-line shell.

FossilOrigin-Name: b94a80a832777f0e639f6a81fcfe169bf970a8c0

13 years agoAdd a couple of asserts trying to make the operation of
drh [Tue, 11 Oct 2011 20:14:41 +0000 (20:14 +0000)] 
Add a couple of asserts trying to make the operation of
sqlite3SelectNew() clearer.

FossilOrigin-Name: b21b1c7bc490b193da8d8a277489eb875a507e30

13 years agoChange the behavior of the readonly_shm=1 query parameter so that it never
drh [Tue, 11 Oct 2011 18:18:54 +0000 (18:18 +0000)] 
Change the behavior of the readonly_shm=1 query parameter so that it never
attempts to open the -shm file read/write.

FossilOrigin-Name: f1364004836078378e4005ab3eb9c0a04e3d4ce7

13 years agoRemove all precision and width limits from formatting fields in the
drh [Tue, 11 Oct 2011 17:54:54 +0000 (17:54 +0000)] 
Remove all precision and width limits from formatting fields in the
sqlite3_mprintf() family of functions. Malloc for space as necessary.
The prevents a stack overflow on very large numbers using %f.

FossilOrigin-Name: 1f843fb383583ee7ef51c13b8a820744e450101a

13 years agoFix requirements marks associate with STAT3.
drh [Tue, 11 Oct 2011 12:39:19 +0000 (12:39 +0000)] 
Fix requirements marks associate with STAT3.

FossilOrigin-Name: 9325c1a8c413dfbf0381190d8347f0a446ae5f5b

13 years agoEnhance sqlite3_analyzer so that it is able to deal with multiplexed databases
drh [Mon, 10 Oct 2011 16:06:35 +0000 (16:06 +0000)] 
Enhance sqlite3_analyzer so that it is able to deal with multiplexed databases
that have 8+3 filenames.

FossilOrigin-Name: e5169f9a5b7e20b8adaf6ebb7868a64e44fd7321

13 years agoFix a typo in a comment for PRAGMA journal_mode. Also amplify that same
drh [Mon, 10 Oct 2011 12:04:14 +0000 (12:04 +0000)] 
Fix a typo in a comment for PRAGMA journal_mode.  Also amplify that same
comment.

FossilOrigin-Name: c8ff2a484005ca48c52407db9f4a9a7d9f747158

13 years agoAll the soft_heap_limit to be exceeded by 10% in test cases.
drh [Sat, 8 Oct 2011 21:39:11 +0000 (21:39 +0000)] 
All the soft_heap_limit to be exceeded by 10% in test cases.

FossilOrigin-Name: 4be9dccc711c9ad252e2cbd99bbcbe43247503a1

13 years agoAdd the SQLITE_DIRECT_OVERFLOW_READ compile time option.
dan [Sat, 8 Oct 2011 14:57:07 +0000 (14:57 +0000)] 
Add the SQLITE_DIRECT_OVERFLOW_READ compile time option.

FossilOrigin-Name: 2ab14a846727857175eac7961b7338c4d3b417ca

13 years agoChange the ANALYZE command so that it no longer tried to delete unused
drh [Fri, 7 Oct 2011 23:52:25 +0000 (23:52 +0000)] 
Change the ANALYZE command so that it no longer tried to delete unused
sqlite_stat2 and sqlite_stat3 tables.  Change the DROP TABLE command so
that it is able to drop those tables.

FossilOrigin-Name: 589f3f5652e3674d3203f8bd32784a46b5ed530c

13 years agoMake sure sqlite3_data_count() behaves as documented, even for
drh [Fri, 7 Oct 2011 18:24:25 +0000 (18:24 +0000)] 
Make sure sqlite3_data_count() behaves as documented, even for
EXPLAIN QUERY PLAN queries.

FossilOrigin-Name: d4f95b3b6e9f4a4072606af5daa17ea7c645382e

13 years agoImproved handling of OR terms in the WHERE clause with multi-column indexes.
drh [Fri, 7 Oct 2011 17:52:40 +0000 (17:52 +0000)] 
Improved handling of OR terms in the WHERE clause with multi-column indexes.

FossilOrigin-Name: b23ae131874bc5c621f0f5ea8d76fce1ec089cc2

13 years agoAdd testcase() macros to ensure good test coverage. or-opt
drh [Fri, 7 Oct 2011 17:45:58 +0000 (17:45 +0000)] 
Add testcase() macros to ensure good test coverage.

FossilOrigin-Name: 5c132592820e9dc2355e26ea14e155c797c335b3

13 years agoAdd the SQLITE_FCNTL_OVERWRITE file-control. Used by SQLite to indicate to the OS...
dan [Fri, 7 Oct 2011 16:57:59 +0000 (16:57 +0000)] 
Add the SQLITE_FCNTL_OVERWRITE file-control. Used by SQLite to indicate to the OS layer that the current transaction will overwrite the entire file.

FossilOrigin-Name: 1da87fcdacfa7d277c3ee98e410a9ea8b529c368

13 years agoMore test cases for the OR optimization.
drh [Fri, 7 Oct 2011 16:08:28 +0000 (16:08 +0000)] 
More test cases for the OR optimization.

FossilOrigin-Name: 4997d8b81cd3ea7c708911bfece00020d11224f9

13 years agoPrevent infinite recursion of in the query planner for some pathological
drh [Fri, 7 Oct 2011 14:40:59 +0000 (14:40 +0000)] 
Prevent infinite recursion of in the query planner for some pathological
test cases by disabling OR-clause processing upon first recursion.

FossilOrigin-Name: 9fca05eac503d712886a05d03794f76c61fb39ed

13 years agoBegin an effort to enhance the query planner to do a better job with OR terms
drh [Fri, 7 Oct 2011 13:33:10 +0000 (13:33 +0000)] 
Begin an effort to enhance the query planner to do a better job with OR terms
in the WHERE clause.  This change allows ANDs outside of the OR to be factored
into the OR terms if that is helpful in finding better indices.

FossilOrigin-Name: 876bd21aaac444c7e056730e35696a74e9a1af0a

13 years agoEnhance the sqlite3_data_count() routine so that it can be used to determine
drh [Fri, 7 Oct 2011 12:59:23 +0000 (12:59 +0000)] 
Enhance the sqlite3_data_count() routine so that it can be used to determine
if SQLITE_DONE has been seen on the prepared statement.

FossilOrigin-Name: 9913996e7b0f94ba1c51200b61433193002f3638

13 years agoAdd the --pageinfo and --stats options to the sqlite3_analyzer utility.
drh [Wed, 5 Oct 2011 19:46:03 +0000 (19:46 +0000)] 
Add the --pageinfo and --stats options to the sqlite3_analyzer utility.

FossilOrigin-Name: baa80c7bc31900decae0d8e6090b30fcde377492

13 years agoUpdate the sqlite3_analyzer utility program to provide more details about
drh [Wed, 5 Oct 2011 18:18:13 +0000 (18:18 +0000)] 
Update the sqlite3_analyzer utility program to provide more details about
the compression performance of ZIPVFS database files.

FossilOrigin-Name: fa5ed53296d45a5f963d20fb361555c432e0f31b

13 years agoFix test code related to reporting the size of overflow pages in zipvfs databases.
dan [Wed, 5 Oct 2011 17:36:27 +0000 (17:36 +0000)] 
Fix test code related to reporting the size of overflow pages in zipvfs databases.

FossilOrigin-Name: ad7c9eed8bbd607babce4f5965f587c873e7bc02

13 years agoWhen finding the appropriate file permissions for journal files with
drh [Wed, 5 Oct 2011 15:26:13 +0000 (15:26 +0000)] 
When finding the appropriate file permissions for journal files with
SQLITE_ENABLE_8_3_NAMES, ignore "-" characters in the name of the
containing directory.

FossilOrigin-Name: 328cc1867ffbbf1c953dfd843649f5f209c8e6ec

13 years agoChange FTS4 so that if both the content=xxx option and column names are specified...
dan [Wed, 5 Oct 2011 15:11:30 +0000 (15:11 +0000)] 
Change FTS4 so that if both the content=xxx option and column names are specified, the virtual table assumes that the named columns correspond to columns of table xxx.

FossilOrigin-Name: 289ee43179369fce2fde50870d72c445e184e896

13 years agoFix a problem with IO error handling in the rebuild-index code.
dan [Wed, 5 Oct 2011 06:07:00 +0000 (06:07 +0000)] 
Fix a problem with IO error handling in the rebuild-index code.

FossilOrigin-Name: c6ba81fcad32192674bd510e607f787adc1f7038

13 years agoImprove test coverage of fts3.c.
dan [Tue, 4 Oct 2011 19:41:50 +0000 (19:41 +0000)] 
Improve test coverage of fts3.c.

FossilOrigin-Name: 0f439944ab49a5691615bc170fdcf652055573df

13 years agoAdd tests to check that modifying the schema of an FTS content table does not cause...
dan [Tue, 4 Oct 2011 16:37:35 +0000 (16:37 +0000)] 
Add tests to check that modifying the schema of an FTS content table does not cause a crash in the FTS module. Also disable the deferred token optimization for content=xxx FTS tables.

FossilOrigin-Name: be86c7061b68f403730bf63ea1f7dc0d9ceb0a3b

13 years agoAdd experimental 'content' option to FTS4.
dan [Tue, 4 Oct 2011 11:22:59 +0000 (11:22 +0000)] 
Add experimental 'content' option to FTS4.

FossilOrigin-Name: 1d27ea741f61c624e18bdc6a3b1c2d8574a64ddc

13 years agoMerge the STAT3 changes into trunk.
drh [Mon, 3 Oct 2011 15:30:33 +0000 (15:30 +0000)] 
Merge the STAT3 changes into trunk.

FossilOrigin-Name: 774d0842bcce8862f2aac371f1689536ed234a0a

13 years agoUpdate MSVC makefile to allow targets to be built with support for ICU.
mistachkin [Sun, 2 Oct 2011 05:23:16 +0000 (05:23 +0000)] 
Update MSVC makefile to allow targets to be built with support for ICU.

FossilOrigin-Name: eb5da5e1dbe9c198095036827318fb381441cbd0

13 years agoDisable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket ...
dan [Fri, 30 Sep 2011 12:01:01 +0000 (12:01 +0000)] 
Disable the xfer optimization if "PRAGMA count_changes=1" is configured. Ticket [c48d99d690].

FossilOrigin-Name: 9ddfe1e41300413bc9af7e5ce0ec9d1daf9136b1

13 years agoIn the shell, allow arbitrary table names on the ".import" command.
drh [Wed, 28 Sep 2011 01:10:00 +0000 (01:10 +0000)] 
In the shell, allow arbitrary table names on the ".import" command.
Ticket [d1d84037b90a449].

FossilOrigin-Name: f4dd32d30ed54f847319664cf749fd0b92b4af3f

13 years agoEnhance the stat VFS to report out the total size of all pages used by
drh [Wed, 28 Sep 2011 00:50:14 +0000 (00:50 +0000)] 
Enhance the stat VFS to report out the total size of all pages used by
a table, even if the ZIPVFS compression backend is in play.  Update
the sqlite3_analyzer logic to use these new outputs.

FossilOrigin-Name: 19b8eaaf70db82d401d33beb7fd36045d5e8326f

13 years agoChanges to sqlite3_analyzer to try to avoid integer overflow problems
drh [Tue, 27 Sep 2011 13:40:26 +0000 (13:40 +0000)] 
Changes to sqlite3_analyzer to try to avoid integer overflow problems
when linking against older versions of TCL.

FossilOrigin-Name: 8c846311a0cd510bbf9361213bb60764e9b797aa

13 years agoChanges to the analyzer script to make it work with zipvfs databases.
dan [Mon, 26 Sep 2011 19:32:47 +0000 (19:32 +0000)] 
Changes to the analyzer script to make it work with zipvfs databases.

FossilOrigin-Name: d82cffab6acafcf9d91fea4ac47cad73f6f09775

13 years agoIf an open as read/write fails, do not try to reopen as read-only if in
drh [Sun, 25 Sep 2011 17:49:26 +0000 (17:49 +0000)] 
If an open as read/write fails, do not try to reopen as read-only if in
exclusive access mode.

FossilOrigin-Name: 263c5fb2802f8c84835e42fc66acb1065b7e42b9

13 years agoIf an open as read/write fails, do not try to reopen as read-only if in stat3-trunk
drh [Sun, 25 Sep 2011 17:47:58 +0000 (17:47 +0000)] 
If an open as read/write fails, do not try to reopen as read-only if in
exclusive access mode.

FossilOrigin-Name: 4a153f010037db83107314269b240c0ece8430f8

13 years agoFix misc3.test so that it works with OMIT_MERGE_SORT builds.
dan [Sat, 24 Sep 2011 09:54:14 +0000 (09:54 +0000)] 
Fix misc3.test so that it works with OMIT_MERGE_SORT builds.

FossilOrigin-Name: 87946c627f7230bea3739fd6aeec3e56115a3f93

13 years agoFix some test files so that they work with SQLITE_OMIT_WAL builds.
dan [Sat, 24 Sep 2011 05:55:36 +0000 (05:55 +0000)] 
Fix some test files so that they work with SQLITE_OMIT_WAL builds.

FossilOrigin-Name: a38668dcff0a4d241d959ea19330ad43295d757d

13 years agoAdd SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell.
drh [Fri, 23 Sep 2011 18:58:23 +0000 (18:58 +0000)] 
Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell.

FossilOrigin-Name: d279e1a309909a0897b6082753a0fadb5066c31a

13 years agoAdd the -DBUILD_sqlite option to the compiler when building testfixture.exe
drh [Fri, 23 Sep 2011 16:34:49 +0000 (16:34 +0000)] 
Add the -DBUILD_sqlite option to the compiler when building testfixture.exe
using the configure script.

FossilOrigin-Name: 15a13b6c59ddf145c3fc860d993a7fa5587a0799

13 years agoMerge the latest trunk changes into the stat3-trunk branch.
drh [Fri, 23 Sep 2011 14:40:31 +0000 (14:40 +0000)] 
Merge the latest trunk changes into the stat3-trunk branch.

FossilOrigin-Name: 0beb88a92c8f75231df120bef54616c7e4bb68c8

13 years agoTestability enhancements.
drh [Fri, 23 Sep 2011 13:59:33 +0000 (13:59 +0000)] 
Testability enhancements.

FossilOrigin-Name: be44928cf2a3c063c8228b769d90947acbfad1ef

13 years agoFix typos in the format description comment of analyze.c.
drh [Fri, 23 Sep 2011 13:25:03 +0000 (13:25 +0000)] 
Fix typos in the format description comment of analyze.c.

FossilOrigin-Name: 74e27fad339a2d7899c1f42805e615128929f07a

13 years agoRemove the restriction on the number of entries per index in sqlite_stat3.
drh [Thu, 22 Sep 2011 20:52:56 +0000 (20:52 +0000)] 
Remove the restriction on the number of entries per index in sqlite_stat3.

FossilOrigin-Name: 374343c8ad53829c4ad715ed623d16635797de9a