]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
17 years agoModify test_osinst.c so that it only uses public interfaces. (CVS 4995)
danielk1977 [Sat, 12 Apr 2008 11:30:12 +0000 (11:30 +0000)] 
Modify test_osinst.c so that it only uses public interfaces. (CVS 4995)

FossilOrigin-Name: 3866a5da2bdcfafe956e1a9bf117f3277207de05

17 years agoAdd a logfile option to test_osinst.c. (CVS 4994)
danielk1977 [Sat, 12 Apr 2008 10:53:11 +0000 (10:53 +0000)] 
Add a logfile option to test_osinst.c. (CVS 4994)

FossilOrigin-Name: f97d89458259978b7b1b5c5e5a0d19cabcb9e536

17 years agoAdd the speedtest8inst1.c program for running speed tests with an
drh [Fri, 11 Apr 2008 21:20:48 +0000 (21:20 +0000)] 
Add the speedtest8inst1.c program for running speed tests with an
instrumented VFS. (CVS 4993)

FossilOrigin-Name: baa8056c67c03ac78a1ed6da5a46fda793340739

17 years agoFaster implementation of hexToInt that uses not branches. Ticket #3047. (CVS 4992)
drh [Fri, 11 Apr 2008 19:37:55 +0000 (19:37 +0000)] 
Faster implementation of hexToInt that uses not branches.  Ticket #3047. (CVS 4992)

FossilOrigin-Name: a70e9587569c99dd05e79c6745ff930aa31d763c

17 years agoAvoid the use of uninitialized variables in sqlite3GenerateRowIndexDelete.
drh [Fri, 11 Apr 2008 19:18:24 +0000 (19:18 +0000)] 
Avoid the use of uninitialized variables in sqlite3GenerateRowIndexDelete.
Ticket #3048. (CVS 4991)

FossilOrigin-Name: a93b7a344a713a9ed9d72be4707eb28c2979648c

17 years agoRemove a recently added assert() that is failing with certain compilers on 32-bit...
danielk1977 [Fri, 11 Apr 2008 17:15:46 +0000 (17:15 +0000)] 
Remove a recently added assert() that is failing with certain compilers on 32-bit platforms. Ticket #3043. (CVS 4990)

FossilOrigin-Name: 03c0279d7b004ccc4264143e366c793b4d774f9f

17 years agoRemove entries from the sqlite_stat1 table whenever an index is dropped. Related...
danielk1977 [Fri, 11 Apr 2008 17:11:26 +0000 (17:11 +0000)] 
Remove entries from the sqlite_stat1 table whenever an index is dropped. Related to #3033. (CVS 4989)

FossilOrigin-Name: 349aab42c7896f04ecb6ca33f08a4c194051e837

17 years agoAdditional reductions in the use of memset(). (CVS 4988)
drh [Fri, 11 Apr 2008 15:36:03 +0000 (15:36 +0000)] 
Additional reductions in the use of memset(). (CVS 4988)

FossilOrigin-Name: 38746c54385e3cb456cda660ea50769b5424db30

17 years agoSpeed improvements by removing unnecessary memset() operations.
drh [Fri, 11 Apr 2008 14:56:53 +0000 (14:56 +0000)] 
Speed improvements by removing unnecessary memset() operations.
Also: do not resize the opcode array of a virtual machine to its
minimum size after code generation completes.  The extra resize
merely uses time. (CVS 4987)

FossilOrigin-Name: 2589955507fc1717891c4e07d1d658eb41660b87

17 years agoEnhancements to the change counter tests. Ticket #3013. (CVS 4986)
drh [Thu, 10 Apr 2008 18:44:36 +0000 (18:44 +0000)] 
Enhancements to the change counter tests.  Ticket #3013. (CVS 4986)

FossilOrigin-Name: 1aaed6a4694f60ebcec5dee98f09fe756c81dfa4

17 years agoCorrectly handle virtual tables that are created and dropped all within
drh [Thu, 10 Apr 2008 18:35:21 +0000 (18:35 +0000)] 
Correctly handle virtual tables that are created and dropped all within
a single transaction.  Ticket #2994. (CVS 4985)

FossilOrigin-Name: 0acb1b428d1181f597a2a665cae3eef5775f15f1

17 years agoAdd the --ostrace and --ossummary options to tester.tcl. To log calls the vfs layer...
danielk1977 [Thu, 10 Apr 2008 17:27:38 +0000 (17:27 +0000)] 
Add the --ostrace and --ossummary options to tester.tcl. To log calls the vfs layer from within test scripts. (CVS 4984)

FossilOrigin-Name: e1322415d0ca2d6b45f35ef9257b37161ec043e2

17 years agoEnhanced testing and documentation of sqlite3_result_error_code().
drh [Thu, 10 Apr 2008 17:14:07 +0000 (17:14 +0000)] 
Enhanced testing and documentation of sqlite3_result_error_code().
Ticket #2940. (CVS 4983)

FossilOrigin-Name: 5be56dbe879f89351239accf5069e4cb166e0792

17 years agoDisable nuisance warnings on borland compilers. ticket #2936. (CVS 4982)
drh [Thu, 10 Apr 2008 16:47:41 +0000 (16:47 +0000)] 
Disable nuisance warnings on borland compilers.  ticket #2936. (CVS 4982)

FossilOrigin-Name: 1e094ecfd7c6feaf8d524aa3c1477910b2328946

17 years agoMake sure check-in (4976) also fixes ticket #2935. (CVS 4981)
drh [Thu, 10 Apr 2008 16:42:58 +0000 (16:42 +0000)] 
Make sure check-in (4976) also fixes ticket #2935. (CVS 4981)

FossilOrigin-Name: e3f798b1cafc3458941cf86ac4f9d4269fdf5b7e

17 years agoGive file scope to the sqlite3Apis constant. Ticket #3024. (CVS 4980)
drh [Thu, 10 Apr 2008 16:01:10 +0000 (16:01 +0000)] 
Give file scope to the sqlite3Apis constant.  Ticket #3024. (CVS 4980)

FossilOrigin-Name: 30c5086068071385c13f02b3d33511127968335b

17 years agoVerify that a RAISE(ROLLBACK,...) works like RAISE(FAIL,...) when not
drh [Thu, 10 Apr 2008 15:12:45 +0000 (15:12 +0000)] 
Verify that a RAISE(ROLLBACK,...) works like RAISE(FAIL,...) when not
inside a transaction.  Ticket #3035. (CVS 4979)

FossilOrigin-Name: 87dc82d0436c6c3a9bd67544d52911012a5a7c66

17 years agoMake sure all memory allocations are 8-byte aligned. Ticket #3040.
drh [Thu, 10 Apr 2008 14:57:24 +0000 (14:57 +0000)] 
Make sure all memory allocations are 8-byte aligned.  Ticket #3040.
Note that the mem3.c memory allocator returns 4-byte aligned memory
allocations.  But as mem3.c is intended for use in 32-bit embedded
systems, we are not going to change that. (CVS 4978)

FossilOrigin-Name: d11e8e307af906db75ae7aede790464fabd06422

17 years agoAdd source file test_osinst.c. A wrapper vfs with instrumentation capabilities. ...
danielk1977 [Thu, 10 Apr 2008 14:51:00 +0000 (14:51 +0000)] 
Add source file test_osinst.c. A wrapper vfs with instrumentation capabilities. (CVS 4977)

FossilOrigin-Name: d9a6b653d3cb608610f13d2492fe9b3887acb3b9

17 years agoMake sure changes to virtual tables are counted the same as real tables.
drh [Thu, 10 Apr 2008 14:00:09 +0000 (14:00 +0000)] 
Make sure changes to virtual tables are counted the same as real tables.
Ticket #3038. (CVS 4976)

FossilOrigin-Name: 55591fc49c8ab8146c1f3eff733e637501bff627

17 years agoFix to the "copy" method in the TCL interface. Ticket #3039. (CVS 4975)
drh [Thu, 10 Apr 2008 13:42:56 +0000 (13:42 +0000)] 
Fix to the "copy" method in the TCL interface.  Ticket #3039. (CVS 4975)

FossilOrigin-Name: 6f07968ec4c9d773a852ecc8343df416d17af2a4

17 years agoDocument the fast that the result flag combinations to
drh [Thu, 10 Apr 2008 13:38:17 +0000 (13:38 +0000)] 
Document the fast that the result flag combinations to
sqlite3_open_v2() that are not defined in the documentation results
in undefined behavior.  Ticket #3037. (CVS 4974)

FossilOrigin-Name: b390e1f7f8d2b530a6765f2ab6804335c5550870

17 years agoFirst cut at optimizing single-row updates to use a one-pass algorithm. (CVS 4973)
drh [Thu, 10 Apr 2008 13:33:18 +0000 (13:33 +0000)] 
First cut at optimizing single-row updates to use a one-pass algorithm. (CVS 4973)

FossilOrigin-Name: fba97f7874d723111e873d1470fc1a95e64f922d

17 years agoAdd three new test cases to speed4p.test. Two of the three do single-row
drh [Thu, 10 Apr 2008 13:32:36 +0000 (13:32 +0000)] 
Add three new test cases to speed4p.test.  Two of the three do single-row
updates based on rowid and on primary key. (CVS 4972)

FossilOrigin-Name: a2da7f9ac24ed17329ce9bde2e521a5b945e4ec2

17 years agoFix a bug in the speed4p.test performance testing script. (CVS 4971)
drh [Thu, 10 Apr 2008 13:20:21 +0000 (13:20 +0000)] 
Fix a bug in the speed4p.test performance testing script. (CVS 4971)

FossilOrigin-Name: 80311594149af093f1719ec433a633c332a5955e

17 years agoReplace always-true condition with assertion (CVS 4970)
mlcreech [Tue, 8 Apr 2008 03:09:22 +0000 (03:09 +0000)] 
Replace always-true condition with assertion (CVS 4970)

FossilOrigin-Name: be7f3240c21c01509263005af2ccc3d7626fe729

17 years agoAdd test case for empty VFS list (CVS 4969)
mlcreech [Tue, 8 Apr 2008 03:07:54 +0000 (03:07 +0000)] 
Add test case for empty VFS list (CVS 4969)

FossilOrigin-Name: 6797814ec59fe819424e8e7f77779a719ecd82d3

17 years agoAdd the sqlite3PutVarint32 routine as an alternative to sqlite3PutVarint.
drh [Sat, 5 Apr 2008 18:41:42 +0000 (18:41 +0000)] 
Add the sqlite3PutVarint32 routine as an alternative to sqlite3PutVarint.
Gives 0.5% speed increase. (CVS 4968)

FossilOrigin-Name: b2517a7d8f7275943d44cc301f9d54fc8a4653e7

17 years agoSmaller and hopefully faster routine for converting blob literals into binary. (CVS...
drh [Fri, 4 Apr 2008 15:12:21 +0000 (15:12 +0000)] 
Smaller and hopefully faster routine for converting blob literals into binary. (CVS 4967)

FossilOrigin-Name: 92d49499ee3371db64267c7e2ba72a5e12ea76f3

17 years agoFix the output labels on the tests in malloc9. (CVS 4966)
drh [Fri, 4 Apr 2008 12:21:25 +0000 (12:21 +0000)] 
Fix the output labels on the tests in malloc9. (CVS 4966)

FossilOrigin-Name: 9987a7b193095dc90a83666bdac5e23105909cba

17 years agoFix the TCL interface so that it does not use unpublished interfaces. (CVS 4965)
drh [Fri, 4 Apr 2008 12:21:08 +0000 (12:21 +0000)] 
Fix the TCL interface so that it does not use unpublished interfaces. (CVS 4965)

FossilOrigin-Name: 046a98a8c88be7389c1571a819ccf1907a3f7217

17 years agoRemove superfluous code from btree.c. (CVS 4964)
drh [Thu, 3 Apr 2008 21:46:57 +0000 (21:46 +0000)] 
Remove superfluous code from btree.c. (CVS 4964)

FossilOrigin-Name: 40173010706fb52ecd60197ce6e97d51a1899267

17 years agoMake sure the zTail return from sqlite3_prepare() is initialized even
drh [Thu, 3 Apr 2008 21:42:21 +0000 (21:42 +0000)] 
Make sure the zTail return from sqlite3_prepare() is initialized even
if there is a malloc failure. (CVS 4963)

FossilOrigin-Name: 040cffe2727936ce9228666fce5b00db47493e7d

17 years agoFix to the previous check-in so that it works on a intel Mac. (CVS 4962)
drh [Thu, 3 Apr 2008 20:09:06 +0000 (20:09 +0000)] 
Fix to the previous check-in so that it works on a intel Mac. (CVS 4962)

FossilOrigin-Name: 1d67f41c885d052ab10a33892938a85b56882b3d

17 years agoUse an improved RDTSC access routine. (CVS 4961)
drh [Thu, 3 Apr 2008 19:40:59 +0000 (19:40 +0000)] 
Use an improved RDTSC access routine. (CVS 4961)

FossilOrigin-Name: b4eba9c533f6aac9dde4f2c9796fe02e25158a0f

17 years agoChanges speedtest8 and speedtest16 so that the database file can be specified
drh [Thu, 3 Apr 2008 17:57:24 +0000 (17:57 +0000)] 
Changes speedtest8 and speedtest16 so that the database file can be specified
on the command-line.  Allows speed testing against a :memory: database. (CVS 4960)

FossilOrigin-Name: 64badc50531668de45d76a3dcd90db17e1fe1ab1

17 years agoInstead of calling sqlite3_exec() to evaluate "PRAGMA encoding = UTF16" in sqlite3_op...
danielk1977 [Thu, 3 Apr 2008 16:28:24 +0000 (16:28 +0000)] 
Instead of calling sqlite3_exec() to evaluate "PRAGMA encoding = UTF16" in sqlite3_open16(), set the connection encoding flag directly. (CVS 4959)

FossilOrigin-Name: 33a12e737c343dbc452a25321a63456c1a8f7548

17 years agoAdd the speedtest8.c and speedtest16.c files to the tools subdirectory. (CVS 4958)
drh [Thu, 3 Apr 2008 16:01:27 +0000 (16:01 +0000)] 
Add the speedtest8.c and speedtest16.c files to the tools subdirectory. (CVS 4958)

FossilOrigin-Name: b8d211a76fa56d812fc1758b58d65eef832494cb

17 years agoAvoid an out-of-bounds read in sqlite3_prepare() and fix a case where the output...
danielk1977 [Thu, 3 Apr 2008 14:36:25 +0000 (14:36 +0000)] 
Avoid an out-of-bounds read in sqlite3_prepare() and fix a case where the output variable *pzTail was being set incorrectly. Fix for #3027. (CVS 4957)

FossilOrigin-Name: c287a7b29410be12cf88f886e8e2525a42aa9c03

17 years agoChange the allocator in mem2.c (used when SQLITE_MEMDEBUG is defined) so that allocat...
danielk1977 [Thu, 3 Apr 2008 10:13:01 +0000 (10:13 +0000)] 
Change the allocator in mem2.c (used when SQLITE_MEMDEBUG is defined) so that allocations are not rounded up to the nearest 4 byte boundary. Fix a couple of errors in malloc.test related to sqlite3OsAccess() returning -1. (CVS 4956)

FossilOrigin-Name: fd97f8762cb1e4653c932402940f74d7c0ebf71f

17 years agoMinor optimizations. (CVS 4955)
drh [Wed, 2 Apr 2008 18:33:07 +0000 (18:33 +0000)] 
Minor optimizations. (CVS 4955)

FossilOrigin-Name: e8529455803e0dab167f4faba5846fa1eafef741

17 years agoSimplifications to the LockTable opcode. (CVS 4954)
drh [Wed, 2 Apr 2008 16:29:30 +0000 (16:29 +0000)] 
Simplifications to the LockTable opcode. (CVS 4954)

FossilOrigin-Name: 66c5d715bbb732b0861a8a6f994cb4a8f259f2f8

17 years agoSet flags = MEM_Null on allocation failure in sqlite3VdbeMemGrow (CVS 4953)
mlcreech [Wed, 2 Apr 2008 04:23:32 +0000 (04:23 +0000)] 
Set flags = MEM_Null on allocation failure in sqlite3VdbeMemGrow (CVS 4953)

FossilOrigin-Name: 846f9739d3e288dc81e40f5bfab046bd80bb22b2

17 years agoAvoid factoring single-instruction constants that end up getting replaced
drh [Tue, 1 Apr 2008 18:04:11 +0000 (18:04 +0000)] 
Avoid factoring single-instruction constants that end up getting replaced
by an SCopy instruction. (CVS 4952)

FossilOrigin-Name: e84ff57b6217afa84d60547dcc3a270b5e116818

17 years agoAdd the testcase() macro. Additional CSE test coverage. (CVS 4951)
drh [Tue, 1 Apr 2008 15:06:33 +0000 (15:06 +0000)] 
Add the testcase() macro.  Additional CSE test coverage. (CVS 4951)

FossilOrigin-Name: 492490f9c86e52c7a706d9e1bf0ba216d5bb8aba

17 years agoFix a problem with CASTs and the new CSE mechanism. (CVS 4950)
drh [Tue, 1 Apr 2008 12:24:11 +0000 (12:24 +0000)] 
Fix a problem with CASTs and the new CSE mechanism. (CVS 4950)

FossilOrigin-Name: e25939fb25ec8bde8500a672ca5be3cbb514ac3a

17 years agoFix the CSE mechanism so that it takes into account column affinity
drh [Tue, 1 Apr 2008 05:07:14 +0000 (05:07 +0000)] 
Fix the CSE mechanism so that it takes into account column affinity
changes that might be imposed by comparison operators. (CVS 4949)

FossilOrigin-Name: 91cc646e2b0c1d62a1989405cc9384a2c22d98d0

17 years agoMore test cases and bug fixes with CSE. (CVS 4948)
drh [Tue, 1 Apr 2008 03:27:39 +0000 (03:27 +0000)] 
More test cases and bug fixes with CSE. (CVS 4948)

FossilOrigin-Name: 7e8156129d6d240fe046bbc4ea269ebe1657e2a1

17 years agoAdd a configure option for using gcov (makes things easier for versions of
mlcreech [Tue, 1 Apr 2008 02:45:22 +0000 (02:45 +0000)] 
Add a configure option for using gcov (makes things easier for versions of
GCC that fail to build otherwise) (CVS 4947)

FossilOrigin-Name: 7d1e79716246b0dd4a64d7c9575b2300e0f6123e

17 years agoInitial test cases and bug fixes in the CSE logic. (CVS 4946)
drh [Tue, 1 Apr 2008 01:42:41 +0000 (01:42 +0000)] 
Initial test cases and bug fixes in the CSE logic. (CVS 4946)

FossilOrigin-Name: e5aff09ac693946dc7ebb2f245b6434995b12155

17 years agoBreak up the implementation of OP_Move, OP_Copy, and OP_SCopy to reduce
drh [Tue, 1 Apr 2008 00:36:10 +0000 (00:36 +0000)] 
Break up the implementation of OP_Move, OP_Copy, and OP_SCopy to reduce
the number of branch instructions. (CVS 4945)

FossilOrigin-Name: 53e533d3a764d1973c24bffaacc505ea4b61a2b9

17 years agoAdd the veryquick.test script for a very fast overview test that omits
drh [Mon, 31 Mar 2008 23:51:35 +0000 (23:51 +0000)] 
Add the veryquick.test script for a very fast overview test that omits
all i/o and malloc testing. (CVS 4944)

FossilOrigin-Name: f61df8daa89f07dad2a0ded00c326ef35dead257

17 years agoAvoid duplicate OP_Column opcodes by remembering prior results.
drh [Mon, 31 Mar 2008 23:48:03 +0000 (23:48 +0000)] 
Avoid duplicate OP_Column opcodes by remembering prior results.
This is similar to CSE, but only applies to columns. (CVS 4943)

FossilOrigin-Name: c29ee0fed23dcdbd9dde6b1e42b603100ea2389c

17 years agoFactor constant subexpressions out of loops. (CVS 4942)
drh [Mon, 31 Mar 2008 18:19:54 +0000 (18:19 +0000)] 
Factor constant subexpressions out of loops. (CVS 4942)

FossilOrigin-Name: 2126db39854c751aea6c95c67894ed9b9dfc0763

17 years agoIn setQuotedToken(), only make a malloced copy if the argument contains one or more...
danielk1977 [Mon, 31 Mar 2008 17:41:18 +0000 (17:41 +0000)] 
In setQuotedToken(), only make a malloced copy if the argument contains one or more " characters. (CVS 4941)

FossilOrigin-Name: b266924b8975b69bdb9ab45cf462e41436f89cc2

17 years agoMinor cleanup: Use size_t for struct size cast (CVS 4940)
mlcreech [Sat, 29 Mar 2008 23:25:27 +0000 (23:25 +0000)] 
Minor cleanup: Use size_t for struct size cast (CVS 4940)

FossilOrigin-Name: 618df68b8b78d376d30cea79a273fd39140f5033

17 years agoSet exclusive locking mode by default on the speed4p test. (CVS 4939)
drh [Sat, 29 Mar 2008 17:26:01 +0000 (17:26 +0000)] 
Set exclusive locking mode by default on the speed4p test. (CVS 4939)

FossilOrigin-Name: 2d9fea95335ab8f399868f63c51bee89ed7633fa

17 years agoMake the sqlite3BtreeMoveto routine a no-op if the cursor is already pointing
drh [Sat, 29 Mar 2008 16:01:04 +0000 (16:01 +0000)] 
Make the sqlite3BtreeMoveto routine a no-op if the cursor is already pointing
at the cell we are trying to move to. (CVS 4938)

FossilOrigin-Name: 9b567ab61e7542141b7bc9c3c053c2d1180da92d

17 years agoadd two missing initializer values (CVS 4937)
rse [Sat, 29 Mar 2008 12:50:33 +0000 (12:50 +0000)] 
add two missing initializer values (CVS 4937)

FossilOrigin-Name: bf28f1c260b3efbec3b031edb97ccb7b4b039947

17 years agoeliminate compile-time warnings related to missing field initializations (CVS 4936)
rse [Sat, 29 Mar 2008 12:47:27 +0000 (12:47 +0000)] 
eliminate compile-time warnings related to missing field initializations (CVS 4936)

FossilOrigin-Name: d6a34d983e2181f1d1763bd3821a1e63f1e18818

17 years agoadd three missing initializers (CVS 4935)
rse [Sat, 29 Mar 2008 12:39:39 +0000 (12:39 +0000)] 
add three missing initializers (CVS 4935)

FossilOrigin-Name: f45f0593cf5dd8c0172b13c300a4a9393540e0d7

17 years agoAdd the --pause option to the main test driver. (CVS 4934)
drh [Sat, 29 Mar 2008 11:00:54 +0000 (11:00 +0000)] 
Add the --pause option to the main test driver. (CVS 4934)

FossilOrigin-Name: 37dfcdf529378a8ef37ed8672e28339a7d9e9da6

17 years agoFix a problem with min() and descending indexes. (CVS 4933)
danielk1977 [Fri, 28 Mar 2008 19:16:56 +0000 (19:16 +0000)] 
Fix a problem with min() and descending indexes. (CVS 4933)

FossilOrigin-Name: 39705b617a775d4299e98ac88fab4525a64d8b78

17 years agoFix a memory leak that can occur when the library API is misused. (CVS 4932)
danielk1977 [Fri, 28 Mar 2008 19:16:33 +0000 (19:16 +0000)] 
Fix a memory leak that can occur when the library API is misused. (CVS 4932)

FossilOrigin-Name: 2b6d3e015e3088531c62230c9b3bdab47ef534da

17 years agoDo not incorrectly report a malloc() failure when allocating 0 bytes. Fixes a problem...
danielk1977 [Fri, 28 Mar 2008 19:15:34 +0000 (19:15 +0000)] 
Do not incorrectly report a malloc() failure when allocating 0 bytes. Fixes a problem in bind.test. (CVS 4931)

FossilOrigin-Name: b99d19d651b00dcc7bdb36facfd9ecffe4fafd9f

17 years agoFix for #3022. Handle queries like "SELECT min(b) FROM T WHERE a = X AND b > X" when...
danielk1977 [Fri, 28 Mar 2008 18:11:16 +0000 (18:11 +0000)] 
Fix for #3022. Handle queries like "SELECT min(b) FROM T WHERE a = X AND b > X" when there is an index on (a,b). (CVS 4930)

FossilOrigin-Name: bce289753538ab504e55c4215d6cd4f5df137d9e

17 years agoChange the pager's sector size algorithm to the maximum of the size
drh [Fri, 28 Mar 2008 17:41:13 +0000 (17:41 +0000)] 
Change the pager's sector size algorithm to the maximum of the size
reported by xSectorSize() from the VFS and 512.  It was using the
maximum of xSectorSize() and the current page size, but that was adding
an extra 512 bytes to the size of the journal file in the common case. (CVS 4929)

FossilOrigin-Name: 17ea0c97a8bac1b34af1f9183d93a2f2a6af9690

17 years agoChanges to the Mem structure to reduce the frequency of freeing and reallocating...
danielk1977 [Fri, 28 Mar 2008 15:44:09 +0000 (15:44 +0000)] 
Changes to the Mem structure to reduce the frequency of freeing and reallocating the dynamic buffer. (CVS 4928)

FossilOrigin-Name: d0bf73d81453da1d8e602e0445064d9f5e348063

17 years agoPatch to the new memory tracing logic that allows it to build even if
drh [Fri, 28 Mar 2008 12:53:38 +0000 (12:53 +0000)] 
Patch to the new memory tracing logic that allows it to build even if
memory debugging is turned off. (CVS 4927)

FossilOrigin-Name: 0a9c63b227b9c6d2bd0e7b491245947ffc83c828

17 years agoIf memory is leaked when running a test script with the --malloctrace option, write...
danielk1977 [Fri, 28 Mar 2008 07:42:53 +0000 (07:42 +0000)] 
If memory is leaked when running a test script with the --malloctrace option, write out a file called leaks.sql in the same format as mallocs.sql containing th e leaked applications. The same tools can then be used to examine the stack traces associated with leaked allocations. (CVS 4926)

FossilOrigin-Name: f1b97ed93183378ff56b4fe7ae8ea269c24092fc

17 years agoAllow the xAccess method in the VFS to return -1 to signal an I/O
drh [Thu, 27 Mar 2008 22:42:51 +0000 (22:42 +0000)] 
Allow the xAccess method in the VFS to return -1 to signal an I/O
error, and in particular an SQLITE_IOERR_NOMEM. (CVS 4925)

FossilOrigin-Name: 3cb704c4c439425781644b1b653b7e50f02fd91e

17 years agoAllow creation of ephemeral pseudo-tables - pseudo-tables that copy a pointer to...
danielk1977 [Thu, 27 Mar 2008 17:59:01 +0000 (17:59 +0000)] 
Allow creation of ephemeral pseudo-tables - pseudo-tables that copy a pointer to a row when inserted instead of copying the row data. (CVS 4924)

FossilOrigin-Name: 1a58a87023f7780aee813ac64dda1a80021002a7

17 years agoAdded the speed4p.test script for testing performance of views and triggers. (CVS...
drh [Thu, 27 Mar 2008 15:07:04 +0000 (15:07 +0000)] 
Added the speed4p.test script for testing performance of views and triggers. (CVS 4923)

FossilOrigin-Name: adf7645f9a1e12389a7511d2adca9013b7f330fa

17 years agoChanges to delay freeing buffers associated with vdbe memory cells until either sqlit...
danielk1977 [Wed, 26 Mar 2008 18:34:43 +0000 (18:34 +0000)] 
Changes to delay freeing buffers associated with vdbe memory cells until either sqlite3_finalize() or sqlite3_release_memory() is called. (CVS 4922)

FossilOrigin-Name: 8c2f69521f13bc24cf005520efbe0589eeadd763

17 years agoWork around problems with compilers that do not allow C preprocessor
drh [Wed, 26 Mar 2008 17:18:48 +0000 (17:18 +0000)] 
Work around problems with compilers that do not allow C preprocessor
macros with empty arguments. (CVS 4921)

FossilOrigin-Name: afe1963ec5588d2195f027fa438cf63d49c89cd9

17 years agoChange comment in sqliteLimit.h to correctly describe the
drh [Wed, 26 Mar 2008 15:56:22 +0000 (15:56 +0000)] 
Change comment in sqliteLimit.h to correctly describe the
SQLITE_MAX_ATTACHED #define.  Ticket #3016. (CVS 4920)

FossilOrigin-Name: d016d0784097e6657de26ccc6bece34913093fb0

17 years agoMake sure ON clause terms of a LEFT JOIN are not used with an index on the
drh [Wed, 26 Mar 2008 14:56:34 +0000 (14:56 +0000)] 
Make sure ON clause terms of a LEFT JOIN are not used with an index on the
right table of the join.  Ticket #3015. (CVS 4919)

FossilOrigin-Name: 3fafa562593b51d38f58e7a691c193d34a812a05

17 years agoComment change on the previous check-in. No changes to code. (CVS 4918)
drh [Wed, 26 Mar 2008 12:50:14 +0000 (12:50 +0000)] 
Comment change on the previous check-in.  No changes to code. (CVS 4918)

FossilOrigin-Name: 72ae456239eb9f75b744f6733c4441b380bd1be1

17 years agoMake sure an imbalance in the number of columns on a compound SELECT is
drh [Wed, 26 Mar 2008 12:46:23 +0000 (12:46 +0000)] 
Make sure an imbalance in the number of columns on a compound SELECT is
detected and reported as an error before it can cause an assertion fault
or array-bounds overflow in the code generator.
Oops: part of the fix for ticket #3015 got included with this
check-in by mistake. (CVS 4917)

FossilOrigin-Name: 50de87dc808820a70d3a99277f532e418a2f97e2

17 years agoModify the {quote: IdxDelete} opcode so that it takes an array of registers rather
drh [Tue, 25 Mar 2008 17:23:32 +0000 (17:23 +0000)] 
Modify the {quote: IdxDelete} opcode so that it takes an array of registers rather
than a record formed using {quote: MakeRecord.}  This avoids a needless packing
and unpacking of the record to be deleted. (CVS 4916)

FossilOrigin-Name: ee381b43563e1b0637ee74389d076dff77deddf9

17 years agoTest string values passed to bind_text() and result_text() for a nul-terminator....
danielk1977 [Tue, 25 Mar 2008 16:16:29 +0000 (16:16 +0000)] 
Test string values passed to bind_text() and result_text() for a nul-terminator. (CVS 4915)

FossilOrigin-Name: 24c3ebc0c5c53c234516d16dce761d713fb29578

17 years agoHave each {quote: BtShared} structure hang on to a buffer of just under page-size...
danielk1977 [Tue, 25 Mar 2008 14:24:56 +0000 (14:24 +0000)] 
Have each {quote: BtShared} structure hang on to a buffer of just under page-size bytes for temporary use. This reduces the number of calls to malloc(). (CVS 4914)

FossilOrigin-Name: fe1bc0f3b7cd87cd65f7d03b91095b59788a6f8d

17 years agoFix for memory leak in malloc3.test. (CVS 4913)
danielk1977 [Tue, 25 Mar 2008 09:56:44 +0000 (09:56 +0000)] 
Fix for memory leak in malloc3.test. (CVS 4913)

FossilOrigin-Name: ef0e40e814b3d3a00721f8ca39bac0db1be24347

17 years agoUse a vdbe memory cell to allocate the space required for vdbe cursors. (CVS 4912)
danielk1977 [Tue, 25 Mar 2008 09:47:35 +0000 (09:47 +0000)] 
Use a vdbe memory cell to allocate the space required for vdbe cursors. (CVS 4912)

FossilOrigin-Name: 047153648155654b0cd70b811935209d2e21776c

17 years agoRemoved the direct btree tests - part of the ongoing effort to test by
drh [Tue, 25 Mar 2008 00:22:21 +0000 (00:22 +0000)] 
Removed the direct btree tests - part of the ongoing effort to test by
calling only public interfaces.  Modify the sqlite3VdbeRecordCompare
interface to used a pre-parsed second key - resulting in a 13%
performance improvement on speed1p.test. (CVS 4911)

FossilOrigin-Name: 0e1d84f2f456e7680bb667266745b629ddf3605f

17 years agoImproved documentation of sqlite3_blob_open(). (CVS 4910)
drh [Mon, 24 Mar 2008 12:51:46 +0000 (12:51 +0000)] 
Improved documentation of sqlite3_blob_open(). (CVS 4910)

FossilOrigin-Name: 1ed695f560a58786f2a8467c601f281c67034fd4

17 years agoRemove redundant tests from the reparenter in the btree module. (CVS 4909)
drh [Sun, 23 Mar 2008 00:20:36 +0000 (00:20 +0000)] 
Remove redundant tests from the reparenter in the btree module. (CVS 4909)

FossilOrigin-Name: a807e7184b857414ce203af129ac1adf2012096c

17 years agoBug fix in the newly revised sqllimit1.test script. (CVS 4908)
drh [Sat, 22 Mar 2008 23:59:58 +0000 (23:59 +0000)] 
Bug fix in the newly revised sqllimit1.test script. (CVS 4908)

FossilOrigin-Name: 2a89fb3c3e991b2c02e07b8b86b67b8d80e0360d

17 years agoAdd the speed1p.test script. Like speed1.test except that it tries to take
drh [Sat, 22 Mar 2008 01:08:00 +0000 (01:08 +0000)] 
Add the speed1p.test script.  Like speed1.test except that it tries to take
advantage of prepared statements. (CVS 4907)

FossilOrigin-Name: ece4fb9f7b93dc3e3cb77e40b011d013d0750dcf

17 years agoAdd the SQLITE_OMIT_DECLTYPE compile-time option. Remove more code when
drh [Sat, 22 Mar 2008 01:07:17 +0000 (01:07 +0000)] 
Add the SQLITE_OMIT_DECLTYPE compile-time option.  Remove more code when
SQLITE_ENABLE_COLUMN_METADATA is not defined. (CVS 4906)

FossilOrigin-Name: 8ef26646cff9be75c584a9abfcfffcfdb49b3969

17 years agoDefer allocating memory space to hold the array of column values and
drh [Fri, 21 Mar 2008 18:01:14 +0000 (18:01 +0000)] 
Defer allocating memory space to hold the array of column values and
names in sqlite3_exec() until there is a need to use the array.  In
the common case where there is no callback, this avoids a malloc() call. (CVS 4905)

FossilOrigin-Name: d8686abcdf9e566571033f2f137142f742df9357

17 years agoBetter integrate the new malloc related instrumentation with the test infrastructure...
danielk1977 [Fri, 21 Mar 2008 17:29:37 +0000 (17:29 +0000)] 
Better integrate the new malloc related instrumentation with the test infrastructure. (CVS 4904)

FossilOrigin-Name: d2140cae39dcced63e3ad5771e52d522ce587c96

17 years agoMake sure the text result of an aggregate function has the correct
drh [Fri, 21 Mar 2008 17:13:13 +0000 (17:13 +0000)] 
Make sure the text result of an aggregate function has the correct
encoding.  Ticket #3009. (CVS 4903)

FossilOrigin-Name: 13e388cecf53d680a79ef29ff4e82e59de8f1264

17 years agoAdd a completely new testing system for the Bitvec object. The new
drh [Fri, 21 Mar 2008 16:45:47 +0000 (16:45 +0000)] 
Add a completely new testing system for the Bitvec object.  The new
testing system uses sqlite3_test_control() instead of unpublished
APIs.  Now provides 100% condition/decision coverage.  Obscure bugs
in Bitvec found and fixed as a result of the enhanced coverage. (CVS 4902)

FossilOrigin-Name: 2498d3ea36ecab6d9c0f04ef1c49d76a7a215a4f

17 years agoAdd some more logging to the malloc system used when SQLITE_MEMDEBUG is defined....
danielk1977 [Fri, 21 Mar 2008 14:22:44 +0000 (14:22 +0000)] 
Add some more logging to the malloc system used when SQLITE_MEMDEBUG is defined. (CVS 4901)

FossilOrigin-Name: 79738f582fbac87f2d335e0c6b7f53e3054b41ba

17 years agoIn the sqlite3_limit() interface, take out the feature where zero means
drh [Thu, 20 Mar 2008 18:00:49 +0000 (18:00 +0000)] 
In the sqlite3_limit() interface, take out the feature where zero means
use the hard upper bound.  If an application wants the hard upper bound,
it can set the limit to 0x7fffffff and the bound will be automatically
truncated. (CVS 4900)

FossilOrigin-Name: d6be1f495ec57158f7bcca3e32145a9a8fde723a

17 years agoReinstate test cases for the limit tests. The sqlite3_limit() API is now
drh [Thu, 20 Mar 2008 16:30:17 +0000 (16:30 +0000)] 
Reinstate test cases for the limit tests.  The sqlite3_limit() API is now
tested and working. (CVS 4899)

FossilOrigin-Name: 4c4be4c3c8aae97f1d85442b25afba9f0b02c8b3

17 years agoDo not run crash7.test as part of a quick test. (CVS 4898)
danielk1977 [Thu, 20 Mar 2008 16:26:48 +0000 (16:26 +0000)] 
Do not run crash7.test as part of a quick test. (CVS 4898)

FossilOrigin-Name: 53b4a09040341a981b2f33399a1ddcee952ba3ef

17 years agoInitial implementation of per-connection limits and the sqlite3_limit() API.
drh [Thu, 20 Mar 2008 14:03:29 +0000 (14:03 +0000)] 
Initial implementation of per-connection limits and the sqlite3_limit() API.
The sqllimits1.test script crashes.  SQLITE_LIMIT_PAGE_COUNT and
SQLITE_LIMIT_VDBE_OP are currently ignored. (CVS 4897)

FossilOrigin-Name: 60c77882b2de9f6a45f8bd87c9c6a0cc613f8373

17 years agoAllow a VACUUM operation to change the page-size in the same way as it can be used...
danielk1977 [Thu, 20 Mar 2008 11:04:21 +0000 (11:04 +0000)] 
Allow a VACUUM operation to change the page-size in the same way as it can be used to change a database between auto-vacuum and normal mode. (CVS 4896)

FossilOrigin-Name: 871df0e7c36a88f175cfc63797745e52a1b1796b