]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
14 years agoHave test_syscall.c include "sqliteInt.h". Otherwise the SQLITE_OS_UNIX symbol may...
dan [Mon, 4 Apr 2011 14:03:58 +0000 (14:03 +0000)] 
Have test_syscall.c include "sqliteInt.h". Otherwise the SQLITE_OS_UNIX symbol may not be defined correctly.

FossilOrigin-Name: fda8fadd837e399d3fab7a9e6894617a5788d679

14 years agoMove the expired-statement test for OP_Function until after all memory has
drh [Mon, 4 Apr 2011 12:29:20 +0000 (12:29 +0000)] 
Move the expired-statement test for OP_Function until after all memory has
been freed.  The test is still commented out, however.

FossilOrigin-Name: 425e3edb146c497817855dd741878709a25c8b98

14 years agoChanges to oserror.test and syscall.test so that they work with the in-memory journal...
dan [Mon, 4 Apr 2011 07:05:38 +0000 (07:05 +0000)] 
Changes to oserror.test and syscall.test so that they work with the in-memory journal permutation test.

FossilOrigin-Name: 4e996f36c73c5e768a954394fcbbf5e17576c807

14 years agoSuppress unused parameter warnings in sqlite3VdbeEnter() and related routines.
drh [Mon, 4 Apr 2011 03:27:16 +0000 (03:27 +0000)] 
Suppress unused parameter warnings in sqlite3VdbeEnter() and related routines.

FossilOrigin-Name: f8e98ab3062a6e56924a86e8f3204c30d0f3d906

14 years agoRemove the BtreeMutexArray object - use the Vdbe.btreeMask field to accomplish
drh [Mon, 4 Apr 2011 00:14:43 +0000 (00:14 +0000)] 
Remove the BtreeMutexArray object - use the Vdbe.btreeMask field to accomplish
the same result.  Add a generation counter to btree mutexes in order to assert
that mutexes are never temporarily dropped over a range of instructions in order
to do deadlock avoidance in some subroutine.  Lock all btrees in any Vdbe
program that uses OP_ParseSchema.

FossilOrigin-Name: d81708f7d1eee399bfe76f6b8dac950a85dc2582

14 years agoMake sure that the constant 1 is cast to yDbType before shifting to create
drh [Sun, 3 Apr 2011 18:19:25 +0000 (18:19 +0000)] 
Make sure that the constant 1 is cast to yDbType before shifting to create
an attached database mask.  This check-in is a follow-up and fix to the
[7aaf8772274422] change that increases the maximum number of attached databases
from 30 to 62.

FossilOrigin-Name: e2a09ea73c76a0bec1e09d1fc11092517e3ebdf9

14 years agoFix typos in comments. No changes to code.
drh [Sun, 3 Apr 2011 02:41:00 +0000 (02:41 +0000)] 
Fix typos in comments.  No changes to code.

FossilOrigin-Name: 28c5f12e98655d5c6167b13e8a15085eca43dd5b

14 years agoChange the name of the "tAttachMask" datatype to "yDbMask".
drh [Sat, 2 Apr 2011 20:01:02 +0000 (20:01 +0000)] 
Change the name of the "tAttachMask" datatype to "yDbMask".

FossilOrigin-Name: 3d6f2e82358c0d8c0ca04e0da20b84fc65c3f7fa

14 years agoAvoid returning SQLITE_NOTFOUND when the unix xSetSystemCall interface is invoked...
dan [Sat, 2 Apr 2011 17:00:47 +0000 (17:00 +0000)] 
Avoid returning SQLITE_NOTFOUND when the unix xSetSystemCall interface is invoked with NULL passed as the second argument, even if all the default system calls are already installed.

FossilOrigin-Name: 3b91eaaa0b3c25022332ba3d1a5651848fc5d84c

14 years agoFix a race condition in OP_ParseSchema.
dan [Sat, 2 Apr 2011 09:44:43 +0000 (09:44 +0000)] 
Fix a race condition in OP_ParseSchema.

FossilOrigin-Name: 71a799b02a3b3cf2e12758dea29fd2465bbec3e1

14 years agoDo not attempt to run tests that use the 'wholenumber' virtual table if the build...
dan [Sat, 2 Apr 2011 09:25:14 +0000 (09:25 +0000)] 
Do not attempt to run tests that use the 'wholenumber' virtual table if the build does not support virtual tables.

FossilOrigin-Name: 20afd81a4cf4d23962ec841bbd375f36a5156fb6

14 years agoFix additional test cases so that they work with DEFAULT_AUTOVACUUM.
dan [Sat, 2 Apr 2011 06:44:38 +0000 (06:44 +0000)] 
Fix additional test cases so that they work with DEFAULT_AUTOVACUUM.

FossilOrigin-Name: 139bc5655ed1d0fd1b7ca86d05a998fcc5fbc18e

14 years agoAdd the "wholenumber" virtual table module to the test suite - useful in
drh [Fri, 1 Apr 2011 23:49:44 +0000 (23:49 +0000)] 
Add the "wholenumber" virtual table module to the test suite - useful in
populating tables with many rows of content prior to a test.

FossilOrigin-Name: 975dff155bd9db42f2b6855b24c861852bb7a201

14 years agoFix up the Makefile.in so that the configuration script works for
drh [Fri, 1 Apr 2011 20:54:38 +0000 (20:54 +0000)] 
Fix up the Makefile.in so that the configuration script works for
"make test".

FossilOrigin-Name: 2e03830c1e1b05f7b22f9fe553ae708b65a4e942

14 years agoMerge the word-fuzzer branch into trunk.
drh [Fri, 1 Apr 2011 20:47:27 +0000 (20:47 +0000)] 
Merge the word-fuzzer branch into trunk.

FossilOrigin-Name: f77609d44194ee8871b3fb281ea6b90a9182f69f

14 years agoAdd additional test data and documentation to the fuzzer virtual table. word-fuzzer
drh [Fri, 1 Apr 2011 20:28:31 +0000 (20:28 +0000)] 
Add additional test data and documentation to the fuzzer virtual table.

FossilOrigin-Name: a6a81d4fdafabba514e8f8e1958d6132b3850772

14 years agoChanges to wal tests so that they work with DEFAULT_AUTOVACUUM defined.
dan [Fri, 1 Apr 2011 19:14:40 +0000 (19:14 +0000)] 
Changes to wal tests so that they work with DEFAULT_AUTOVACUUM defined.

FossilOrigin-Name: b477852f82c1fddbda61fad83d55055ad8503dda

14 years agoMerge the multiplexer enhancements back into the trunk.
drh [Fri, 1 Apr 2011 18:39:24 +0000 (18:39 +0000)] 
Merge the multiplexer enhancements back into the trunk.

FossilOrigin-Name: 2c125710cbf04198464d436b16e5ef37c5b219cf

14 years agoAdd a script that will break the amalgamation source file up into 4 or 5
drh [Fri, 1 Apr 2011 18:12:58 +0000 (18:12 +0000)] 
Add a script that will break the amalgamation source file up into 4 or 5
smaller source files, each 32K lines or fewer, and a single "sqlite3-all.c"
source file that #includes the others.

FossilOrigin-Name: 5d34e64d4d2398aa9a54fd0a4f1de37ced7ea5dd

14 years agoChange analyze7.test so that it works without SQLITE_ENABLE_STAT2 defined.
dan [Fri, 1 Apr 2011 17:53:19 +0000 (17:53 +0000)] 
Change analyze7.test so that it works without SQLITE_ENABLE_STAT2 defined.

FossilOrigin-Name: 9415201c8a0b9b640f5997c5348c5df812e88230

14 years agoWhen simulating an error in the close() system call, close the file descriptor anyway...
dan [Fri, 1 Apr 2011 16:50:07 +0000 (16:50 +0000)] 
When simulating an error in the close() system call, close the file descriptor anyway. Otherwise long running tests leak too many file-descriptors and crash.

FossilOrigin-Name: 81ddbf43366c18ebdd46558d6a0fbee2ce6a4c4e

14 years agoEnsure that it is not possible to add a column to a system table using ALTER TABLE.
dan [Fri, 1 Apr 2011 15:15:58 +0000 (15:15 +0000)] 
Ensure that it is not possible to add a column to a system table using ALTER TABLE.

FossilOrigin-Name: d9707ef8dcd29667b6d366897f6ad02c87aa0041

14 years agoMerge the ANALYZE-index enhancement into trunk.
drh [Fri, 1 Apr 2011 14:26:14 +0000 (14:26 +0000)] 
Merge the ANALYZE-index enhancement into trunk.

FossilOrigin-Name: 7e237aea22084416d02b89d5223de4e1ca76882d

14 years agoRemoved dependency on sqliteInt.h so that multiplex VFS shim can be compiled as loada... multiplex-enhancements
shaneh [Fri, 1 Apr 2011 14:22:46 +0000 (14:22 +0000)] 
Removed dependency on sqliteInt.h so that multiplex VFS shim can be compiled as loadable module.

FossilOrigin-Name: 718f1ad7df9115871ba6159012d3183183fc40a1

14 years agoTest cases for ANALYZE-index. analyze-idx
drh [Fri, 1 Apr 2011 14:04:36 +0000 (14:04 +0000)] 
Test cases for ANALYZE-index.

FossilOrigin-Name: 365896cb0868fa476e3b4f5a965a1344a2914cc2

14 years agoMove a variable declaration inside an #ifdef to avoid a compiler warning.
drh [Fri, 1 Apr 2011 13:29:29 +0000 (13:29 +0000)] 
Move a variable declaration inside an #ifdef to avoid a compiler warning.

FossilOrigin-Name: 7a6d05dfbc36310683dd51a280e9283cef4f9056

14 years agoIn os_unix.c, do not return SQLITE_BUSY to SQLite following an error in fcntl(F_UNLCK...
dan [Fri, 1 Apr 2011 11:56:32 +0000 (11:56 +0000)] 
In os_unix.c, do not return SQLITE_BUSY to SQLite following an error in fcntl(F_UNLCK), regardless of the value of errno.

FossilOrigin-Name: ff6dfe6ed74f9ff1669b2bda41d61a01cd0a1bc6

14 years agoFix some problems in os_unix.c when compiled with ENABLE_LOCKING_STYLE on OSX. Also...
dan [Fri, 1 Apr 2011 09:04:36 +0000 (09:04 +0000)] 
Fix some problems in os_unix.c when compiled with ENABLE_LOCKING_STYLE on OSX. Also some minor issues with test scripts.

FossilOrigin-Name: 8088031bc949bd4efb5edf33bbd1bce5700fca56

14 years agoFix two compiler errors associated with non-standard compile-time options.
drh [Fri, 1 Apr 2011 02:26:36 +0000 (02:26 +0000)] 
Fix two compiler errors associated with non-standard compile-time options.

FossilOrigin-Name: e3bf2d5ce4f87535e030a446e03d911f421805f7

14 years agoFix a compiler warning and an unreachable branch. Restore 100% branch test
drh [Fri, 1 Apr 2011 01:38:02 +0000 (01:38 +0000)] 
Fix a compiler warning and an unreachable branch.  Restore 100% branch test
coverage.

FossilOrigin-Name: 4dc148bb4cec5ecba167cdcb4959a4f0fa05a96f

14 years agoEnable/disable support.
shaneh [Thu, 31 Mar 2011 15:11:53 +0000 (15:11 +0000)] 
Enable/disable support.

FossilOrigin-Name: b3c6d9aa9e2124a2f2a1a5f9dbbd7db3b1d01a31

14 years agoTests and bug fixes for SELECT multiplex_control(op, val);
shaneh [Thu, 31 Mar 2011 13:14:12 +0000 (13:14 +0000)] 
Tests and bug fixes for SELECT multiplex_control(op, val);
Add tests and fixes for SELECT multiplex_control(op, val);

FossilOrigin-Name: fee9734c193a8bec9599e02e16938179e642bf5e

14 years agoAdditional test cases; Round chunk size up to a multiple of max page size;
shaneh [Thu, 31 Mar 2011 05:31:24 +0000 (05:31 +0000)] 
Additional test cases;  Round chunk size up to a multiple of max page size;

FossilOrigin-Name: 36e364a3fe7d3a9a521189ff0262611a492c21dc

14 years agoChange the ANALYZE command so that it will accept an index name as its
drh [Thu, 31 Mar 2011 02:03:28 +0000 (02:03 +0000)] 
Change the ANALYZE command so that it will accept an index name as its
argument and only reanalyze that one index.  A quick smoke-test works.
Need to study the implications to the query planner and test corner cases.

FossilOrigin-Name: c8f9edd962442cbdd848c48f1a134557ab8c6ef5

14 years agoUpdates to multiplex.test script; misc. bug fixes;
shaneh [Wed, 30 Mar 2011 21:03:07 +0000 (21:03 +0000)] 
Updates to multiplex.test script;  misc. bug fixes;

FossilOrigin-Name: c41ff2358e8af0fe2186ab4173b81fba204a57ab

14 years agoFurther tests for os_unix.c.
dan [Wed, 30 Mar 2011 19:08:03 +0000 (19:08 +0000)] 
Further tests for os_unix.c.

FossilOrigin-Name: a84f7711949ea3885b0e36e48118d2c76a8a5b82

14 years agoDo not generate sqlite_stat1 entries for empty tables when running
drh [Wed, 30 Mar 2011 14:54:05 +0000 (14:54 +0000)] 
Do not generate sqlite_stat1 entries for empty tables when running
ANALYZE.  Ticket [83ea97620bd31016451]

FossilOrigin-Name: 3a27af5b3c688c651ba1fae261026ef77b7ff5e3

14 years agoMove to an O(NlogN) algorithm for the priority queue. An insertion sort
drh [Wed, 30 Mar 2011 01:43:00 +0000 (01:43 +0000)] 
Move to an O(NlogN) algorithm for the priority queue.  An insertion sort
was way too slow.

FossilOrigin-Name: 7958cbba736a599c1293b06602eec43dfe4fd7d1

14 years agoAdd support for rowid.
drh [Tue, 29 Mar 2011 23:41:31 +0000 (23:41 +0000)] 
Add support for rowid.

FossilOrigin-Name: 2cf4158ff051916717fc2c0f4b6332d5f6ea6e3d

14 years agoAdd tests to syscall.test and sysfault.test.
dan [Tue, 29 Mar 2011 18:28:35 +0000 (18:28 +0000)] 
Add tests to syscall.test and sysfault.test.

FossilOrigin-Name: 3d2de011814002e2e25b7645f94ff8fc7aab9cdd

14 years agoThe first simple test-case appears to be working now.
drh [Tue, 29 Mar 2011 18:21:59 +0000 (18:21 +0000)] 
The first simple test-case appears to be working now.

FossilOrigin-Name: dd41155bc7459cafc1a2d5c75233193abfbac05d

14 years agoFix a problem whereby following an IO error in CommitPhaseTwo() of a multi-file trans...
dan [Tue, 29 Mar 2011 15:40:55 +0000 (15:40 +0000)] 
Fix a problem whereby following an IO error in CommitPhaseTwo() of a multi-file transaction the b-tree layer could be left in TRANS_WRITE state, causing problems later on.

FossilOrigin-Name: dbe569a099c2855480e35c0cc4d9332821ad80da

14 years agoFurther improvements to the fuzzer. It still is not quite working. Pausing
drh [Tue, 29 Mar 2011 14:08:09 +0000 (14:08 +0000)] 
Further improvements to the fuzzer.  It still is not quite working.  Pausing
to work on other things....

FossilOrigin-Name: 5f2f2fce40f43debeb0492c9b460b85c7dad2bde

14 years agoFix a problem in the unix VFS implementation of xNextSystemCall(). Also some typos...
dan [Tue, 29 Mar 2011 10:04:23 +0000 (10:04 +0000)] 
Fix a problem in the unix VFS implementation of xNextSystemCall(). Also some typos that prevent compilation when HAVE_POSIX_FALLOCATE is defined.

FossilOrigin-Name: bc6cce81565b17f886478bd51500bba2ed11ec1d

14 years agoIn-progress changes - do not use; Removed prefix support; Added file control interfac...
shaneh [Tue, 29 Mar 2011 05:06:46 +0000 (05:06 +0000)] 
In-progress changes - do not use; Removed prefix support; Added file control interface to enable/disable and adjust chunk size;
added app-def function for same;

FossilOrigin-Name: bc02d0c193225bd49a8d8a3295aeac752d3c2e30

14 years agoFix the documentation for the sqlite3_column_*_name() functions to describe
drh [Tue, 29 Mar 2011 01:47:22 +0000 (01:47 +0000)] 
Fix the documentation for the sqlite3_column_*_name() functions to describe
that the information can be invalidated when a prepared statement is
reprepared by the first invocation of an sqlite3_step() for a particular
execution cycle.

FossilOrigin-Name: 7270f80ac5dd17b979f1f790b2dfcf811866c1dc

14 years agoAdd test infrastructure (and some tests) to inject faults into os_unix.c using the...
dan [Mon, 28 Mar 2011 19:10:06 +0000 (19:10 +0000)] 
Add test infrastructure (and some tests) to inject faults into os_unix.c using the new xSetSystemCall interface.

FossilOrigin-Name: 0e1d20dfaeea5ab285d16aa4b8f02b61b1d2bc10

14 years agoAdded most of the logic. Simple test runs without segfaulting but does not
drh [Sat, 26 Mar 2011 19:04:47 +0000 (19:04 +0000)] 
Added most of the logic.  Simple test runs without segfaulting but does not
give the correct answer.

FossilOrigin-Name: fb4c31eac8a7290f61c50a3552245660e1271871

14 years agoSkeleton code for the word-fuzzer virtual table.
drh [Sat, 26 Mar 2011 15:05:27 +0000 (15:05 +0000)] 
Skeleton code for the word-fuzzer virtual table.

FossilOrigin-Name: ea3a4ee136ff6699c3099178f0efaa8bb517715f

14 years agoMinor change to sqlite3Utf8Read() to make consistent with READ_UTF8() usage and avoid...
shaneh [Thu, 24 Mar 2011 17:43:18 +0000 (17:43 +0000)] 
Minor change to sqlite3Utf8Read() to make consistent with READ_UTF8() usage and avoid implementation defined usages of <<.
Added some additional UTF-8 test cases.

FossilOrigin-Name: 7173b3929fae4e678223b0e978a2da7fa50a9005

14 years agoFix problem with tableapi.test on Windows.
shaneh [Thu, 24 Mar 2011 17:37:24 +0000 (17:37 +0000)] 
Fix problem with tableapi.test on Windows.

FossilOrigin-Name: 69fe0c873d702ef1d781453ee6ac2b1fb77fce48

14 years agoThe changes to fix [f7b4edece25c9948] mean that the schema is always loaded
drh [Thu, 24 Mar 2011 01:34:03 +0000 (01:34 +0000)] 
The changes to fix [f7b4edece25c9948] mean that the schema is always loaded
whenever a prepared statement is running.  This means that a couple of
branches can be eliminated and one operand of OP_ParseSchema can be removed.

FossilOrigin-Name: b6e268fce12829f058f1dfa223731ec8479493f8

14 years agoFix a signed/unsigned comparison compiler warning.
drh [Wed, 23 Mar 2011 22:54:59 +0000 (22:54 +0000)] 
Fix a signed/unsigned comparison compiler warning.

FossilOrigin-Name: c81da6f98d89935442c447a51736e11baf5a7bc1

14 years agoUpdate the test_vfstrace.c shim to conform to the new VFS interface for
drh [Wed, 23 Mar 2011 22:51:46 +0000 (22:51 +0000)] 
Update the test_vfstrace.c shim to conform to the new VFS interface for
xSetSystemCall and xGetSystemCall.

FossilOrigin-Name: ad4dc7b95f94fc9a5430c1305fb61d9de79b3365

14 years agoChange the xSetSyscall methods of the VFS so that they do not cast object
drh [Wed, 23 Mar 2011 22:02:23 +0000 (22:02 +0000)] 
Change the xSetSyscall methods of the VFS so that they do not cast object
pointers into function pointers.  Fix other unrelated compiler warnings.

FossilOrigin-Name: e059152adce3a8fb693f082b82b5669a238c8d6f

14 years agoIncrease the upper bound on SQLITE_MAX_ATTACHED from 30 to 62.
drh [Wed, 23 Mar 2011 18:22:34 +0000 (18:22 +0000)] 
Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62.

FossilOrigin-Name: 7aaf8772274422f5020fad9eea490e195170720f

14 years agoFix a bug in fts4 to do with matchinfo and deferred tokens.
dan [Wed, 23 Mar 2011 17:10:43 +0000 (17:10 +0000)] 
Fix a bug in fts4 to do with matchinfo and deferred tokens.

FossilOrigin-Name: 30d42dc66f19ef5cc5b27d6273eadf56619a3ce8

14 years agoIn the shell, make sure the ".log" command has at least one argument.
drh [Wed, 23 Mar 2011 11:16:22 +0000 (11:16 +0000)] 
In the shell, make sure the ".log" command has at least one argument.

FossilOrigin-Name: 1ed5e361ca7bfa9226fec265704394e0f228f0c5

14 years agoFix a numbering issue in rtree6.test. Add a couple of extra tests.
dan [Wed, 23 Mar 2011 10:52:23 +0000 (10:52 +0000)] 
Fix a numbering issue in rtree6.test. Add a couple of extra tests.

FossilOrigin-Name: 0b7668a71ef8995ea0306c7d890f87761961426e

14 years agoChange the rtree module to support queries with multiple comparison operators (i...
dan [Wed, 23 Mar 2011 10:38:49 +0000 (10:38 +0000)] 
Change the rtree module to support queries with multiple comparison operators (i.e. > or <) of the same type on a single column.

FossilOrigin-Name: 387b55aa9bb0f978641f9c2fa40f84fd98662047

14 years agoAdd the ability to enable and disable foreign key constraints and triggers
drh [Mon, 21 Mar 2011 17:15:58 +0000 (17:15 +0000)] 
Add the ability to enable and disable foreign key constraints and triggers
using calls to sqlite3_db_config().

FossilOrigin-Name: 09e167f9c14625924b17bbb1f292f89ac9ddc93a

14 years agoAdd a test case to verify that ticket [f7b4edece25c994857] is fixed.
drh [Sat, 19 Mar 2011 02:04:02 +0000 (02:04 +0000)] 
Add a test case to verify that ticket [f7b4edece25c994857] is fixed.

FossilOrigin-Name: eedbcf0a0ba91bb8b9cd3d115081ba297e9959fe

14 years agoAdd a generation counter to the Schema object and enhance OP_VerifySchema
drh [Fri, 18 Mar 2011 21:55:46 +0000 (21:55 +0000)] 
Add a generation counter to the Schema object and enhance OP_VerifySchema
to also check the Schema generation.  Fix for
ticket [f7b4edece25c99].

FossilOrigin-Name: 36c04dd1695f0899b53ce58738181b146fc005ed

14 years agoUpdate the implementation of ".testctrl" in the command-line shell to use
drh [Thu, 17 Mar 2011 16:45:50 +0000 (16:45 +0000)] 
Update the implementation of ".testctrl" in the command-line shell to use
a look-up table rather than a long sequence of if-elses.  Shorten source
code lines of shell.c to 80 characters or less.

FossilOrigin-Name: 54bacb95dd6e2d6ac4971391a40484ccb9126d29

14 years agoComment enhancement to better explain the logic in the "x IS NULL"
drh [Thu, 17 Mar 2011 01:58:21 +0000 (01:58 +0000)] 
Comment enhancement to better explain the logic in the "x IS NULL"
optimization.

FossilOrigin-Name: 869f894798a65f8bc0e0b083866a784fa0189f68

14 years agoEnhances to the query planner such that "x IS NULL" constraints take the
drh [Thu, 17 Mar 2011 01:34:26 +0000 (01:34 +0000)] 
Enhances to the query planner such that "x IS NULL" constraints take the
STAT2 statistics into account, just like "x=VALUE" constraints.

FossilOrigin-Name: 2353176811f752a16c1f2351a3d3431919b062a9

14 years agoAdditional interpretation of flags and constants in the VFS trace output.
drh [Wed, 16 Mar 2011 18:54:23 +0000 (18:54 +0000)] 
Additional interpretation of flags and constants in the VFS trace output.

FossilOrigin-Name: 3e984195f1f6d28734456dd726d226cedf207da2

14 years agoAdd the -vfstrace option to the usage error message in the shell.
drh [Wed, 16 Mar 2011 17:05:28 +0000 (17:05 +0000)] 
Add the -vfstrace option to the usage error message in the shell.

FossilOrigin-Name: baca45c549e1c144257ee657258939640120e094

14 years agoAdd the VFS-trace shim.
drh [Wed, 16 Mar 2011 16:56:29 +0000 (16:56 +0000)] 
Add the VFS-trace shim.

FossilOrigin-Name: f49a9ef3387bd4453f5654ebe83fea445c03cf4d

14 years agoMake the "unix-excl" VFS work exactly like "unix" if the database
drh [Tue, 15 Mar 2011 19:08:48 +0000 (19:08 +0000)] 
Make the "unix-excl" VFS work exactly like "unix" if the database
file is read-only.

FossilOrigin-Name: d9846834993079fb2e42d6bd2644b2154ef324d1

14 years agoFix an out-of-order variable declaration in shell.c.
drh [Tue, 15 Mar 2011 18:35:44 +0000 (18:35 +0000)] 
Fix an out-of-order variable declaration in shell.c.

FossilOrigin-Name: 725708465072fc63736e99610cc9cb0ac336145a

14 years agoAllow multiplex file names to be preceeded by prefix of the form ":multiplex:chunksiz...
shaneh [Tue, 15 Mar 2011 04:45:48 +0000 (04:45 +0000)] 
Allow multiplex file names to be preceeded by prefix of the form ":multiplex:chunksize:maxchunks:"
Still work to be done, though it compiles and prefixes are ignored.

FossilOrigin-Name: cfa4a2f7ea948be0925227efca82baea509249c9

14 years agoFix cut-and-paste typo in debugging print statement in winMutexTry().
shaneh [Tue, 15 Mar 2011 02:55:28 +0000 (02:55 +0000)] 
Fix cut-and-paste typo in debugging print statement in winMutexTry().

FossilOrigin-Name: def98fd23e42bda13547e38ab13fed0e6554ce99

14 years agoMerge the unix-excl VFS into the trunk. This merge also adds the -vfs
drh [Mon, 14 Mar 2011 13:54:01 +0000 (13:54 +0000)] 
Merge the unix-excl VFS into the trunk.  This merge also adds the -vfs
option to the command-line shell.

FossilOrigin-Name: 3934b004e93852c89b937ec20431de96a2e99440

14 years agoIn the "unix-excl" VFS, use the heap for shared memory, since only a single unix-excl
drh [Sat, 12 Mar 2011 18:10:44 +0000 (18:10 +0000)] 
In the "unix-excl" VFS, use the heap for shared memory, since only a single
process is able to read or write the database.

FossilOrigin-Name: a05a6d40875df674f9c2b46e33128c6878d4edaa

14 years agoAdd the new optional "unix-excl" VFS. This VFS grabs an exclusive lock on
drh [Sat, 12 Mar 2011 17:02:57 +0000 (17:02 +0000)] 
Add the new optional "unix-excl" VFS.  This VFS grabs an exclusive lock on
the database preventing other processes from accessing it, but continues to
allow other database connections from the same process.

FossilOrigin-Name: 00051c3296e11211b2bb5ae28f016b17dca857d7

14 years agoMore tests for SQLITE_OMIT_UNIQUE_ENFORCEMENT and minor change to implementation.
shaneh [Sat, 12 Mar 2011 04:58:55 +0000 (04:58 +0000)] 
More tests for SQLITE_OMIT_UNIQUE_ENFORCEMENT and minor change to implementation.

FossilOrigin-Name: b86999436ec2414c990ba720441fe316f647eef6

14 years agoRemove an unused field from the unix sqlite3_file object.
drh [Fri, 11 Mar 2011 16:15:48 +0000 (16:15 +0000)] 
Remove an unused field from the unix sqlite3_file object.

FossilOrigin-Name: f957f23a8a392bb1720720960bda2c7b24de9663

14 years agoSimplification of tests and more added for SQLITE_OMIT_UNIQUE_ENFORCEMENT tests.
shaneh [Thu, 10 Mar 2011 21:48:02 +0000 (21:48 +0000)] 
Simplification of tests and more added for SQLITE_OMIT_UNIQUE_ENFORCEMENT tests.

FossilOrigin-Name: 75a38411a89bd2969ec5cecca13c13a390b3d478

14 years agoSkip unique constraint enforcement if compiled with SQLITE_OMIT_UNIQUE_ENFORCEMENT.
shaneh [Thu, 10 Mar 2011 21:13:18 +0000 (21:13 +0000)] 
Skip unique constraint enforcement if compiled with SQLITE_OMIT_UNIQUE_ENFORCEMENT.

FossilOrigin-Name: ba85bf8cb88f7ae220d919f5c23f51d9dcedc843

14 years agoMinor clean-up of previous mem5 allocator fix.
shaneh [Thu, 10 Mar 2011 03:54:55 +0000 (03:54 +0000)] 
Minor clean-up of previous mem5 allocator fix.

FossilOrigin-Name: 3643842316239ff7859f0ec522736a2b9c03d22c

14 years agoFix issue with mem5 allocator when min request size is larger thatn 2^30.
shaneh [Wed, 9 Mar 2011 21:36:17 +0000 (21:36 +0000)] 
Fix issue with mem5 allocator when min request size is larger thatn 2^30.

FossilOrigin-Name: d7dae06fb2d57ed6b9555b774712f42077ae4155

14 years agoOmit unnecessary OP_Next and OP_Prev operators when uniqueness constraints
drh [Wed, 9 Mar 2011 21:02:31 +0000 (21:02 +0000)] 
Omit unnecessary OP_Next and OP_Prev operators when uniqueness constraints
guarantee that the code will only make one pass through the loop.

FossilOrigin-Name: f000c9b2b7348238fe2085140d2dd05294a19709

14 years agoUpdates to the OS/2 implementation from Rich Walsh.
drh [Wed, 9 Mar 2011 11:04:07 +0000 (11:04 +0000)] 
Updates to the OS/2 implementation from Rich Walsh.

FossilOrigin-Name: dc46156a2237701679433779b871844f4f2abe4b

14 years agoMerge the syscall-override changes into trunk.
drh [Tue, 8 Mar 2011 16:39:29 +0000 (16:39 +0000)] 
Merge the syscall-override changes into trunk.

FossilOrigin-Name: 36d79e6f54cdc4129c6e6366a49722e2cf1cccbd

14 years agoUnix errno integer can vary from one system to the next. So do not
drh [Tue, 8 Mar 2011 14:05:07 +0000 (14:05 +0000)] 
Unix errno integer can vary from one system to the next.  So do not
depend on specific errno values in test cases.

FossilOrigin-Name: ddb747d33a004c7fe532a661e879ccba68c79c59

14 years agoFix two compiler warnings. No functional code changes.
drh [Tue, 8 Mar 2011 13:06:41 +0000 (13:06 +0000)] 
Fix two compiler warnings.  No functional code changes.

FossilOrigin-Name: c829868aa2254c5e2268cdb803462cc6ec5cb71e

14 years agoFix additional cases of possible signed integer overflow, especially with
drh [Tue, 8 Mar 2011 02:38:28 +0000 (02:38 +0000)] 
Fix additional cases of possible signed integer overflow, especially with
regard to negation.

FossilOrigin-Name: 2d5800bd8cfc7d7f5578a71b1aeaa74b2ec4b372

14 years agoAnother minor simplification brought to light by clang.
drh [Sun, 6 Mar 2011 21:54:33 +0000 (21:54 +0000)] 
Another minor simplification brought to light by clang.

FossilOrigin-Name: 3bfbf026dd6a0eeef07f8f5f1ebf74c9cfebcd61

14 years agoRemove dead code identified by the clang static analyzer.
drh [Sun, 6 Mar 2011 21:28:32 +0000 (21:28 +0000)] 
Remove dead code identified by the clang static analyzer.

FossilOrigin-Name: 01a79d5a7af48fb7e50291c0c7c6283d3fb359d0

14 years agoSimplifications to the overflow-free multiplier. Also remove some commented-out
drh [Sat, 5 Mar 2011 21:41:34 +0000 (21:41 +0000)] 
Simplifications to the overflow-free multiplier.  Also remove some commented-out
code that was left in that subroutine by mistake on the previous check-in.

FossilOrigin-Name: 55fc25fdab61e6094289e068c343e012fec10439

14 years agoFix all known instances of signed-integer overflow. Within SQL expressions,
drh [Sat, 5 Mar 2011 20:59:46 +0000 (20:59 +0000)] 
Fix all known instances of signed-integer overflow.  Within SQL expressions,
integer overflow now forces coercion to floating point.  The shift operators
work with any integer right-hand operand with negative values reversing
the direction of the shift.

FossilOrigin-Name: abf21394124a0af46f072793718964cee2ce55d0

14 years agoFix an instance of signed arithmetic overflow and an one bit-shift overflow.
drh [Sat, 5 Mar 2011 13:54:15 +0000 (13:54 +0000)] 
Fix an instance of signed arithmetic overflow and an one bit-shift overflow.
Mark six other signed arithmetic overflow locations that need fixing.

FossilOrigin-Name: 04abab71ecd52f6070b9f84781a3df3d6dba7722

14 years agoHandle EINTR errors from open(). syscall-override
drh [Fri, 4 Mar 2011 15:43:57 +0000 (15:43 +0000)] 
Handle EINTR errors from open().

FossilOrigin-Name: a7d176b27cd73791d45eb3a31df78187ae10ce20

14 years agoDo a better job of choosing the join table order when the tables having
drh [Fri, 4 Mar 2011 00:56:58 +0000 (00:56 +0000)] 
Do a better job of choosing the join table order when the tables having
very different numbers of rows.

FossilOrigin-Name: 952f5e8c69904c48f2decfabf8ea60a2e9f3e134

14 years agoFix quoting of the result in rtreeB.test.
drh [Wed, 2 Mar 2011 22:07:29 +0000 (22:07 +0000)] 
Fix quoting of the result in rtreeB.test.

FossilOrigin-Name: c6532b35cc5a81cc753a22e0165bfdd5143941f1

14 years agoAdd additional VFS methods to retrieve system call pointers and to get a
drh [Wed, 2 Mar 2011 19:06:42 +0000 (19:06 +0000)] 
Add additional VFS methods to retrieve system call pointers and to get a
list of all changeable system calls.

FossilOrigin-Name: 38558363494e3a736dcb091dd859e76b7ccd78b0

14 years agoAdd more system calls to the set that can be overridden in os_unix.c.
drh [Wed, 2 Mar 2011 18:01:10 +0000 (18:01 +0000)] 
Add more system calls to the set that can be overridden in os_unix.c.
Also merge in recent fixes from trunk.

FossilOrigin-Name: 80fac2a6e07221bb67613af84ab9dda3e18b5ceb

14 years agoFix bugs in [7b6e30e6a7] that only show up on Mac.
drh [Wed, 2 Mar 2011 17:54:32 +0000 (17:54 +0000)] 
Fix bugs in [7b6e30e6a7] that only show up on Mac.

FossilOrigin-Name: ec55e8c6bb4f2419b3813aa2fd1a20d8f5016159

14 years agoMake sure the rtreenode() testing and analysis routine in the RTREE extension
drh [Wed, 2 Mar 2011 15:44:35 +0000 (15:44 +0000)] 
Make sure the rtreenode() testing and analysis routine in the RTREE extension
can handle 64-bit rowids.  This fix is in response to a message on the
mailing list.

FossilOrigin-Name: 24602557fc3295fe2836d269175f12ec680ac011