]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
17 years agoAllow the P2 operand to be negative on opcodes that are not jumps. (CVS 4680)
drh [Fri, 4 Jan 2008 19:33:49 +0000 (19:33 +0000)] 
Allow the P2 operand to be negative on opcodes that are not jumps. (CVS 4680)

FossilOrigin-Name: 717bcd11a222fe100e25c5b2eb6de8b6b9930de1

17 years agoFix mkopcodeh.awk so that it works on a mac. (CVS 4679)
drh [Fri, 4 Jan 2008 19:12:35 +0000 (19:12 +0000)] 
Fix mkopcodeh.awk so that it works on a mac. (CVS 4679)

FossilOrigin-Name: 59d3dfa41f99e99b836649a0870cbfc1c275a654

17 years agoSome modifications to insert.c to work without using the stack. (CVS 4678)
danielk1977 [Fri, 4 Jan 2008 19:10:28 +0000 (19:10 +0000)] 
Some modifications to insert.c to work without using the stack. (CVS 4678)

FossilOrigin-Name: d9ac6beef538376d0ea0a1daa95cf1dfe36143cf

17 years agoReplace the NOPUSH_MASKs with a bit-vector mechanism that can contain
drh [Fri, 4 Jan 2008 16:50:09 +0000 (16:50 +0000)] 
Replace the NOPUSH_MASKs with a bit-vector mechanism that can contain
several different properties about each opcode. (CVS 4677)

FossilOrigin-Name: 042dcb9621934d0318a7c6e9cd08b20a569db367

17 years agoModify FifoRead and FifoWrite to work exclusively with memory cells. (CVS 4676)
danielk1977 [Fri, 4 Jan 2008 13:57:26 +0000 (13:57 +0000)] 
Modify FifoRead and FifoWrite to work exclusively with memory cells. (CVS 4676)

FossilOrigin-Name: 2c913908a47e7ace7d964067e3566d232ee2d494

17 years agoModify the code generated for a DELETE to use registers instead of the vdbe stack...
danielk1977 [Fri, 4 Jan 2008 13:24:28 +0000 (13:24 +0000)] 
Modify the code generated for a DELETE to use registers instead of the vdbe stack. (CVS 4675)

FossilOrigin-Name: 173f281334d340290e1978abea5d1ea804141910

17 years agoAdd OP_MemSet, for setting a memory cell to a string value. (CVS 4674)
danielk1977 [Fri, 4 Jan 2008 11:01:03 +0000 (11:01 +0000)] 
Add OP_MemSet, for setting a memory cell to a string value. (CVS 4674)

FossilOrigin-Name: 8bb9f970dd71cbf19e45774fc822aa1efebc1724

17 years agoChange the sqlite3ExprCode() function so that callers can request that
drh [Thu, 3 Jan 2008 23:44:53 +0000 (23:44 +0000)] 
Change the sqlite3ExprCode() function so that callers can request that
the result of the expression be left on the stack or in a register. (CVS 4673)

FossilOrigin-Name: 61bfb77c4267b99ac8a8ef49355bcbc395a1a37b

17 years agoFix typo in comment. Ticket #2870. (CVS 4672)
danielk1977 [Thu, 3 Jan 2008 18:56:25 +0000 (18:56 +0000)] 
Fix typo in comment. Ticket #2870. (CVS 4672)

FossilOrigin-Name: e97e4578671d85b634072b8931cf55516bbd4ca8

17 years agoUpdate OP_Rowid, OP_Column and related opcodes to use registers. (CVS 4671)
drh [Thu, 3 Jan 2008 18:44:59 +0000 (18:44 +0000)] 
Update OP_Rowid, OP_Column and related opcodes to use registers. (CVS 4671)

FossilOrigin-Name: 4f3967073d2df9eae5a61b9770d5de2e1af47b4c

17 years agoModify VFilter and VRename to use registers instead of the vdbe stack for inputs...
danielk1977 [Thu, 3 Jan 2008 18:39:41 +0000 (18:39 +0000)] 
Modify VFilter and VRename to use registers instead of the vdbe stack for inputs. (CVS 4670)

FossilOrigin-Name: 253ed40aa36247fc846cc41c8612cd29899d9f8f

17 years agoRegisters (aka memory cells) in the VM are now numbered starting with 1
drh [Thu, 3 Jan 2008 18:03:08 +0000 (18:03 +0000)] 
Registers (aka memory cells) in the VM are now numbered starting with 1
instead of 0.  A register number of 0 means "no such register". (CVS 4669)

FossilOrigin-Name: 0b849805c3a0f562d50623f406279b400d335639

17 years agoModify OP_VUpdate to read arguments from a range of memory cells instead of from...
danielk1977 [Thu, 3 Jan 2008 17:31:44 +0000 (17:31 +0000)] 
Modify OP_VUpdate to read arguments from a range of memory cells instead of from the stack. (CVS 4668)

FossilOrigin-Name: 955b15a020e9ea6401fe03a36f5139a03ea80b8a

17 years agoChange the VdbeOp.p4 union to include specific pointer types for the various values...
danielk1977 [Thu, 3 Jan 2008 11:50:29 +0000 (11:50 +0000)] 
Change the VdbeOp.p4 union to include specific pointer types for the various values of VdbeOp.p4type. (CVS 4667)

FossilOrigin-Name: 7e8330c8044dc7718e720dbd33f6e2fe970ead77

17 years agoChange the OP_Insert opcode to read the key and data to insert from memory cells...
danielk1977 [Thu, 3 Jan 2008 09:51:55 +0000 (09:51 +0000)] 
Change the OP_Insert opcode to read the key and data to insert from memory cells, not the stack. (CVS 4666)

FossilOrigin-Name: 46501f490a5f5577ea31c758df749e02c7c65f39

17 years agoChange the output of vdbe_trace etc. to include operands p3 and p5. (CVS 4665)
danielk1977 [Thu, 3 Jan 2008 08:18:30 +0000 (08:18 +0000)] 
Change the output of vdbe_trace etc. to include operands p3 and p5. (CVS 4665)

FossilOrigin-Name: 76f2040b051e1d4d8033e354dffe277b549f7962

17 years agoCombine the OP_Column and OP_DfltValue opcodes. (CVS 4664)
danielk1977 [Thu, 3 Jan 2008 08:08:40 +0000 (08:08 +0000)] 
Combine the OP_Column and OP_DfltValue opcodes. (CVS 4664)

FossilOrigin-Name: c30f8206353f32a08ef0b323c9fd0bdbeaa28b02

17 years agoChange OP_OpenRead and OP_OpenWrite so that the database number is read from the...
danielk1977 [Thu, 3 Jan 2008 07:54:23 +0000 (07:54 +0000)] 
Change OP_OpenRead and OP_OpenWrite so that the database number is read from the P3 operand, not the stack. (CVS 4663)

FossilOrigin-Name: 35da261daf602b1e938f05bbad1ff99213d9f4b9

17 years agoFix EXPLAIN and EXPLAIN query plan to work with new opcode format. (CVS 4662)
danielk1977 [Thu, 3 Jan 2008 07:09:48 +0000 (07:09 +0000)] 
Fix EXPLAIN and EXPLAIN query plan to work with new opcode format. (CVS 4662)

FossilOrigin-Name: b166c33a7b9a58d571619d2248019eda09651dd2

17 years agoRevamp sqlite3VdbeAddOpList() so that the structure holds integer values
drh [Thu, 3 Jan 2008 01:28:59 +0000 (01:28 +0000)] 
Revamp sqlite3VdbeAddOpList() so that the structure holds integer values
for P1, P2, and P3. (CVS 4661)

FossilOrigin-Name: 4dc507d87b242619fe32606452227900e16a6de7

17 years agoRefactoring the VM. The P3 parameter is changed to P4. A P5 parameter is
drh [Thu, 3 Jan 2008 00:01:23 +0000 (00:01 +0000)] 
Refactoring the VM.  The P3 parameter is changed to P4.  A P5 parameter is
added (though not currently used.)  Add routines sqlite3VdbeAddOpX() where
X is one of 0, 1, 2, 3, or 4. (CVS 4660)

FossilOrigin-Name: 027875e4d4c4bd7686dc880c6917a968049b2fec

17 years agoAdd operands p4 and p5 to the VdbeOp structure. (CVS 4659)
drh [Wed, 2 Jan 2008 17:25:54 +0000 (17:25 +0000)] 
Add operands p4 and p5 to the VdbeOp structure. (CVS 4659)

FossilOrigin-Name: ad528735e41ce2ec2e680b12e562d4ddb6650985

17 years agoMinor optimizations for sub-selects in EXISTS(...) expressions: Discard any DISTINCT...
danielk1977 [Wed, 2 Jan 2008 17:11:14 +0000 (17:11 +0000)] 
Minor optimizations for sub-selects in EXISTS(...) expressions: Discard any DISTINCT or ORDER BY clauses and do not calculate any column values. (CVS 4658)

FossilOrigin-Name: fbd17a8976cc9b4dd7c7c903d8beade9a7ef095f

17 years agoCombine the eDest and iParm arguments to sqlite3Select() into a single type - "Select...
danielk1977 [Wed, 2 Jan 2008 16:27:09 +0000 (16:27 +0000)] 
Combine the eDest and iParm arguments to sqlite3Select() into a single type - "SelectDest". (CVS 4657)

FossilOrigin-Name: 86dcdfe6d7d629618ccb3c3ff0ca09f2da2d06c7

17 years agoAdd opcodes OP_ResultRow and OP_RegMakeRec which are register-based
drh [Wed, 2 Jan 2008 14:28:13 +0000 (14:28 +0000)] 
Add opcodes OP_ResultRow and OP_RegMakeRec which are register-based
equivalents to OP_Callback and OP_MakeRecord.  Use the new opcodes. (CVS 4656)

FossilOrigin-Name: 4c7f35da7751c61a9b61b1d95adddcc37fff3266

17 years agoRemove a surplus OP_Close from delete.c. Fixes a problem with (4654). (CVS 4655)
drh [Wed, 2 Jan 2008 13:05:51 +0000 (13:05 +0000)] 
Remove a surplus OP_Close from delete.c.  Fixes a problem with (4654). (CVS 4655)

FossilOrigin-Name: 03cc91b3b0ff9be192532f8a404b3c7b827e1449

17 years agoTake advantage of the fact that b-tree cursors need not be closed while other cursors...
danielk1977 [Wed, 2 Jan 2008 11:50:51 +0000 (11:50 +0000)] 
Take advantage of the fact that b-tree cursors need not be closed while other cursors modify their tables to simplify trigger program generation code. (CVS 4654)

FossilOrigin-Name: f1966a8a47fca85f7862c0797a527ab01ac8b0c1

17 years agoAdd some extra tests for the recent trigger compilation optimization. (CVS 4653)
danielk1977 [Wed, 2 Jan 2008 04:41:24 +0000 (04:41 +0000)] 
Add some extra tests for the recent trigger compilation optimization. (CVS 4653)

FossilOrigin-Name: de54dad800f0b62740ad4ebb3780464b44eb6dff

17 years agoBegin setting a foundation on which to convert the VM from a stack-based
drh [Wed, 2 Jan 2008 00:34:36 +0000 (00:34 +0000)] 
Begin setting a foundation on which to convert the VM from a stack-based
to a register-based machine.  Everything is still mostly stack based with
this check-in.  This change merely begins adding infrastructure to support
a register-based architecture. (CVS 4652)

FossilOrigin-Name: 051ec01f2799e095516015f2ef0180e50fac387c

17 years agoOptimize trigger compilation to avoid populating the OLD.* and NEW.* pseudo-tables...
danielk1977 [Tue, 1 Jan 2008 19:02:09 +0000 (19:02 +0000)] 
Optimize trigger compilation to avoid populating the OLD.* and NEW.* pseudo-tables with data that will never be used. Some testing to come. (CVS 4651)

FossilOrigin-Name: e08a33ed7255c22ce2805363f44a1d7770acb2dd

17 years agoSilence a harmless unitialised variable warning in btree.c. Ticket #2862. (CVS 4650)
danielk1977 [Tue, 1 Jan 2008 06:19:02 +0000 (06:19 +0000)] 
Silence a harmless unitialised variable warning in btree.c. Ticket #2862. (CVS 4650)

FossilOrigin-Name: b51782ccac28598eec7adc9302fe7d1986bfdaf8

17 years agoDefine SQLITE_CORE=1 at the start of the amalgamation file for the benefit of any...
danielk1977 [Tue, 1 Jan 2008 05:49:07 +0000 (05:49 +0000)] 
Define SQLITE_CORE=1 at the start of the amalgamation file for the benefit of any extension source code (i.e. fts3) appended to it. Ticket #2858. (CVS 4649)

FossilOrigin-Name: 6dea8c16384443ed4ab59d1e2694534992ec3118

17 years agofix case in os2GetTempname() where none of the usual environment variables are set...
pweilbacher [Sun, 30 Dec 2007 23:38:00 +0000 (23:38 +0000)] 
fix case in os2GetTempname() where none of the usual environment variables are set to not overwrite two unrelated bytes (CVS 4648)

FossilOrigin-Name: 9719a063942256e34395868d974ed2d53b81b697

17 years agosimplify os2FullPathname() and at the same time make the allocations more robust...
pweilbacher [Sun, 30 Dec 2007 23:35:15 +0000 (23:35 +0000)] 
simplify os2FullPathname() and at the same time make the allocations more robust (CVS 4647)

FossilOrigin-Name: 6f8952a8366065c9baa48cacc9c36743788210db

17 years agomove variable declaration to be able to compile sqlite3_mutex_alloc() with older...
pweilbacher [Sun, 30 Dec 2007 23:29:06 +0000 (23:29 +0000)] 
move variable declaration to be able to compile sqlite3_mutex_alloc() with older compilers (like EMX/gcc 2.8.1) (CVS 4646)

FossilOrigin-Name: a568a9cf3705f45c4734f212eb359cadd3b0c897

17 years agoAdd experimental pragma "quick_check", a reduced version of integrity_check that...
danielk1977 [Sat, 29 Dec 2007 13:39:19 +0000 (13:39 +0000)] 
Add experimental pragma "quick_check", a reduced version of integrity_check that runs without most of the overhead of the full integrity_check. (CVS 4645)

FossilOrigin-Name: 2ddc8d72723e5a294e850491fcd9c1fb7474a9c3

17 years agoMem3.c enhanced so that an allocation of N bytes only requires (N+11)&~7 bytes
drh [Sat, 29 Dec 2007 13:18:22 +0000 (13:18 +0000)] 
Mem3.c enhanced so that an allocation of N bytes only requires (N+11)&~7 bytes
instead of (N+15)&~7 bytes of heap storage.  Minimum heap usage per
allocation is still 16 bytes.  8-byte alignment is preserved. (CVS 4644)

FossilOrigin-Name: d027f91cea0a6fd1e04d2b3853f21348da601a17

17 years agoFix a race condition that can occur when reloading the database schema in shared...
danielk1977 [Thu, 27 Dec 2007 15:12:16 +0000 (15:12 +0000)] 
Fix a race condition that can occur when reloading the database schema in shared-cache mode. (CVS 4643)

FossilOrigin-Name: b37babef913fcceae7f0bd461a3105e184518d62

17 years agoFix for #2854. "BEGIN EXCLUSIVE" excludes other shared cache users from using the...
danielk1977 [Fri, 21 Dec 2007 04:47:25 +0000 (04:47 +0000)] 
Fix for #2854. "BEGIN EXCLUSIVE" excludes other shared cache users from using the database. (CVS 4642)

FossilOrigin-Name: 2e59b1d07ee422bd799b5b7aeea44ebc998d9481

17 years agoFix some issues with lemon. Tickets #2852 and #2835. (CVS 4641)
drh [Fri, 21 Dec 2007 00:02:11 +0000 (00:02 +0000)] 
Fix some issues with lemon.  Tickets #2852 and #2835. (CVS 4641)

FossilOrigin-Name: 5283e0d1467e0fc0ebbd1be553b5a8762e9c7975

17 years agoAdd the ioerr3.test file, that found an error in br3317. The error is not present...
danielk1977 [Wed, 19 Dec 2007 09:20:41 +0000 (09:20 +0000)] 
Add the ioerr3.test file, that found an error in br3317. The error is not present in this branch. (CVS 4640)

FossilOrigin-Name: d3efec148968538e225f5716359a6a25e8941362

17 years agoFix a problem with SQLITE_MAX_SQL_LENGTH introduced by check-in (4636).
drh [Tue, 18 Dec 2007 17:50:33 +0000 (17:50 +0000)] 
Fix a problem with SQLITE_MAX_SQL_LENGTH introduced by check-in (4636).
Ticket #2851 (CVS 4639)

FossilOrigin-Name: cdd866f59797b81b573c68d5c625f9bd9f0f6fde

17 years agoIn the CLI, quote strings that contain the separator character.
drh [Tue, 18 Dec 2007 15:41:44 +0000 (15:41 +0000)] 
In the CLI, quote strings that contain the separator character.
Ticket #2850. (CVS 4638)

FossilOrigin-Name: 493a17c46a66d2febc11205c052bf949a3f22bd8

17 years agoFix for typo in main.mk: the output of target sqlite3 was testcli. (CVS 4637)
danielk1977 [Tue, 18 Dec 2007 11:19:35 +0000 (11:19 +0000)] 
Fix for typo in main.mk: the output of target sqlite3 was testcli. (CVS 4637)

FossilOrigin-Name: 15675dc518dbcf2ce2daa0bbcaf8daf3329ead75

17 years agoWhen SQLITE_MAX_SQL_LENGTH is 0, disable the limit. Make the default 0.
drh [Mon, 17 Dec 2007 16:20:06 +0000 (16:20 +0000)] 
When SQLITE_MAX_SQL_LENGTH is 0, disable the limit.  Make the default 0.
Once again build the sqlite3 CLI from individual source files so that
it can be built on systems that lack tclsh.  Tickets #2845 and #2846. (CVS 4636)

FossilOrigin-Name: 07aeca3b9c51e538ba7939950a970f62e51bd3ea

17 years agoVersion 3.5.4 (CVS 4635)
drh [Fri, 14 Dec 2007 17:39:23 +0000 (17:39 +0000)] 
Version 3.5.4 (CVS 4635)

FossilOrigin-Name: cf4a11b2a8afcbc9cdcf5fa907ddb9865847ed11

17 years agoUpdate library version number to 3.5.4. (CVS 4634)
drh [Fri, 14 Dec 2007 17:24:59 +0000 (17:24 +0000)] 
Update library version number to 3.5.4. (CVS 4634)

FossilOrigin-Name: 5c653bfc7ffafcd3572d399aba05e39ea839068a

17 years agoFix a C++-ism in recent changes to select.c. (CVS 4633)
drh [Fri, 14 Dec 2007 17:24:39 +0000 (17:24 +0000)] 
Fix a C++-ism in recent changes to select.c. (CVS 4633)

FossilOrigin-Name: 4a00805014a5f4ad862bde0bb55fac934bab41dd

17 years agoChange to the crash simulator to give better diagnostics in case it
drh [Fri, 14 Dec 2007 17:22:23 +0000 (17:22 +0000)] 
Change to the crash simulator to give better diagnostics in case it
runs out of memory while using the mem3.c allocator. (CVS 4632)

FossilOrigin-Name: 0d5747dbad97bf09cf9050e44efbcf5d6b812fbd

17 years agoFix a typo in the previous check-in. Also simplify a line in select.c. (CVS 4631)
drh [Fri, 14 Dec 2007 16:11:09 +0000 (16:11 +0000)] 
Fix a typo in the previous check-in.  Also simplify a line in select.c. (CVS 4631)

FossilOrigin-Name: 86f45d7bb6f7d9e5c177be76d8a7ace754d52bcd

17 years agoFix an out-of-memory NULL pointer defer in the code generator. Ticket #2843. (CVS...
drh [Fri, 14 Dec 2007 15:12:21 +0000 (15:12 +0000)] 
Fix an out-of-memory NULL pointer defer in the code generator.  Ticket #2843. (CVS 4630)

FossilOrigin-Name: b821b6ed176b4259e1d4b56c8eb548933b6f530a

17 years agoChange all instances of "it's" in comments to either "its" or "it is",
drh [Thu, 13 Dec 2007 21:54:09 +0000 (21:54 +0000)] 
Change all instances of "it's" in comments to either "its" or "it is",
as appropriate, in case the comments are ever again read by a pedantic
grammarian.  Ticket #2840. (CVS 4629)

FossilOrigin-Name: 4e91a267febda572e7239f0f1cc66b3102558c36

17 years agoFix a memory leak that can occur following a malloc() failure. (CVS 4628)
danielk1977 [Thu, 13 Dec 2007 19:15:02 +0000 (19:15 +0000)] 
Fix a memory leak that can occur following a malloc() failure. (CVS 4628)

FossilOrigin-Name: 993a213024964f4411a9c25c10810543c8089d07

17 years agoFix the location of a #include in test_thread.c. ticket #2826. (CVS 4627)
drh [Thu, 13 Dec 2007 18:29:35 +0000 (18:29 +0000)] 
Fix the location of a #include in test_thread.c.  ticket #2826. (CVS 4627)

FossilOrigin-Name: 6129fce873da5adb05473129e610198a30e43ac8

17 years agoAdd test cases for errors in "IN(SELECT ...)" expressions where the SELECT statement...
danielk1977 [Thu, 13 Dec 2007 18:24:21 +0000 (18:24 +0000)] 
Add test cases for errors in "IN(SELECT ...)" expressions where the SELECT statement is a compound SELECT. No faults found. (CVS 4626)

FossilOrigin-Name: 49b67adfe9f15dfac34cb30f965920bf61bceee7

17 years agoAdd new makefile target for "testcli" that builds a CLI using individual
drh [Thu, 13 Dec 2007 18:20:46 +0000 (18:20 +0000)] 
Add new makefile target for "testcli" that builds a CLI using individual
source files instead of the amalgamation.  Ticket #2838. (CVS 4625)

FossilOrigin-Name: b6f04e5b93bb65287bfb697f2f059dd34c13102a

17 years agoAdditional test cases for tkt2822. Fix a related bug in printf(). (CVS 4624)
drh [Thu, 13 Dec 2007 17:50:22 +0000 (17:50 +0000)] 
Additional test cases for tkt2822.  Fix a related bug in printf(). (CVS 4624)

FossilOrigin-Name: 8f184e40ff79c3c5ef98337615f58a4a6d0249dd

17 years agoReturn an error if the user attempts to rename a view. Related to (but not a fix...
danielk1977 [Thu, 13 Dec 2007 08:15:30 +0000 (08:15 +0000)] 
Return an error if the user attempts to rename a view. Related to (but not a fix for) #2831. (CVS 4623)

FossilOrigin-Name: 19d56d997f50be81ac2baace16b7e7a1b674301a

17 years agoAdjust the test suite to account for recent changes related to #2822. Most changes...
danielk1977 [Thu, 13 Dec 2007 07:58:50 +0000 (07:58 +0000)] 
Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622)

FossilOrigin-Name: 2f88b9b3e3c9abc3ae4a5dcef82707dd74f8aace

17 years agoORDER BY in a compound SELECT will first match against the left-most SELECT.
drh [Thu, 13 Dec 2007 03:45:07 +0000 (03:45 +0000)] 
ORDER BY in a compound SELECT will first match against the left-most SELECT.
If there is no match there, it begins working its way to the right. (CVS 4621)

FossilOrigin-Name: 56063ec84b130bcdb0e90bc76fabca394d0d867f

17 years agoTowards getting ORDER BY to match against the correctin columns.
drh [Thu, 13 Dec 2007 02:45:31 +0000 (02:45 +0000)] 
Towards getting ORDER BY to match against the correctin columns.
This version only looks at the left-most column in a compound SELECT.
That is the correct thing to do, but not what SQLite has historically done. (CVS 4620)

FossilOrigin-Name: bbddf16ac9539c7d48adfc73c5a90eecb8df6865

17 years agoMinor cleanup changes on the OP_StackDepth opcode. Added the
drh [Wed, 12 Dec 2007 22:24:12 +0000 (22:24 +0000)] 
Minor cleanup changes on the OP_StackDepth opcode.  Added the
sidedelete test for additional testing of ticket #2832. (CVS 4619)

FossilOrigin-Name: c0689409320de1532be0c0cae12b4b716f6bffb9

17 years agoRemove an (explain) accidentally left in tkt2832.test. (CVS 4618)
danielk1977 [Wed, 12 Dec 2007 18:05:20 +0000 (18:05 +0000)] 
Remove an (explain) accidentally left in tkt2832.test. (CVS 4618)

FossilOrigin-Name: 48947e2b75d39c5be0d08fe1c7b888d9065f9116

17 years agoTry to find some more stack leaks by adding OP_StackDepth to loops in DML statements...
danielk1977 [Wed, 12 Dec 2007 17:42:53 +0000 (17:42 +0000)] 
Try to find some more stack leaks by adding OP_StackDepth to loops in DML statements. None were found. (CVS 4617)

FossilOrigin-Name: 12c3029b1edcff4435177c709fb2584323f8c515

17 years agoRemove a couple of lines in delete.c that weren't doing anything. (CVS 4616)
danielk1977 [Wed, 12 Dec 2007 17:19:27 +0000 (17:19 +0000)] 
Remove a couple of lines in delete.c that weren't doing anything. (CVS 4616)

FossilOrigin-Name: 86332c79aedb64842e589ff941c637f8e1aabd41

17 years agoFix some problems similar to #2832, but caused by triggers instead of an OR REPLACE...
danielk1977 [Wed, 12 Dec 2007 16:06:23 +0000 (16:06 +0000)] 
Fix some problems similar to #2832, but caused by triggers instead of an OR REPLACE clause. (CVS 4615)

FossilOrigin-Name: ee98ae17187296f7b0181c3d4d2b942d5cd4bc8f

17 years agoTest file containing minimal example of bug #2832. (CVS 4614)
danielk1977 [Wed, 12 Dec 2007 14:46:58 +0000 (14:46 +0000)] 
Test file containing minimal example of bug #2832. (CVS 4614)

FossilOrigin-Name: ed2e61a9fab6a9a102031c10bc6f89e78b4c7447

17 years agoFix database corrupting code generation error for UPDATE OR REPLACE.
drh [Wed, 12 Dec 2007 12:25:21 +0000 (12:25 +0000)] 
Fix database corrupting code generation error for UPDATE OR REPLACE.
ticket #2832.  Still need to add test cases and additional defensive
logic to avoid future occurrences of similar problems. (CVS 4613)

FossilOrigin-Name: 18e10f816782ca7842f651e9b2a23da1aab645c8

17 years agoAdd a new OP_StackDepth opcode to help detect VDBE stack leaks early,
drh [Wed, 12 Dec 2007 12:00:45 +0000 (12:00 +0000)] 
Add a new OP_StackDepth opcode to help detect VDBE stack leaks early,
before they cause damage.  For diagnostics in ticket #2832. (CVS 4612)

FossilOrigin-Name: 3fd6a267533cedcca9b8ba3533c107d7341a06c6

17 years agoFix test numbering in tkt2822.test. Ticket #2830. (CVS 4611)
danielk1977 [Wed, 12 Dec 2007 04:38:26 +0000 (04:38 +0000)] 
Fix test numbering in tkt2822.test. Ticket #2830. (CVS 4611)

FossilOrigin-Name: 8fe8e9c460e0f8ebc4267de96b0c971cb6370861

17 years agoFix a comment on the SQLITE_SQL_MAX_LENGTH definition. (CVS 4610)
drh [Tue, 11 Dec 2007 20:04:14 +0000 (20:04 +0000)] 
Fix a comment on the SQLITE_SQL_MAX_LENGTH definition. (CVS 4610)

FossilOrigin-Name: 9335c940504f5979066b70ec445b57acfb251713

17 years agoBuild the CLI using the amalgamation. Relax the limit on SQL statement
drh [Tue, 11 Dec 2007 19:34:44 +0000 (19:34 +0000)] 
Build the CLI using the amalgamation.  Relax the limit on SQL statement
length when building the CLI. (CVS 4609)

FossilOrigin-Name: a5d81cd371913dff4b1337a9586645f967371ab9

17 years agoFix a 'const' issue in trimFunc(). (CVS 4608)
danielk1977 [Tue, 11 Dec 2007 04:23:19 +0000 (04:23 +0000)] 
Fix a 'const' issue in trimFunc(). (CVS 4608)

FossilOrigin-Name: 64787d78b99a549a87bc2baeff8ae87691612b77

17 years agoMake sure the windows driver responds correctly to the
drh [Mon, 10 Dec 2007 21:11:31 +0000 (21:11 +0000)] 
Make sure the windows driver responds correctly to the
SQLITE_OPEN_DELETEONCLOSE flag.  Ticket #2829. (CVS 4607)

FossilOrigin-Name: 19db91fd683c465b8c8a862143a01178682da445

17 years agoFurther modifications to do with ORDER BY and compound SELECT queries. Related to...
danielk1977 [Mon, 10 Dec 2007 18:51:47 +0000 (18:51 +0000)] 
Further modifications to do with ORDER BY and compound SELECT queries. Related to ticket #2822. (CVS 4606)

FossilOrigin-Name: 0d9b0e6e3a8f8a66956878084085842e94c3cb2f

17 years agoFix a macro in func.c that causes problems for the amalgamation. (CVS 4605)
drh [Mon, 10 Dec 2007 18:07:20 +0000 (18:07 +0000)] 
Fix a macro in func.c that causes problems for the amalgamation. (CVS 4605)

FossilOrigin-Name: 6adbe91efffc6b3f53dae87494430ede61d40ecc

17 years agoFix a bug in the compilation procedures for the Linux shared library
drh [Mon, 10 Dec 2007 17:55:16 +0000 (17:55 +0000)] 
Fix a bug in the compilation procedures for the Linux shared library
that includes the TCL bindings. (CVS 4604)

FossilOrigin-Name: d384810a95c97b868a87d090f8dcb903cc82cbf7

17 years agoFix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603)
danielk1977 [Mon, 10 Dec 2007 05:03:46 +0000 (05:03 +0000)] 
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603)

FossilOrigin-Name: 0b34a18651764e650faba983be8593992ab2f4a9

17 years agoBetter resolution of ORDER BY terms in compound queries. Candidate
drh [Sat, 8 Dec 2007 21:10:20 +0000 (21:10 +0000)] 
Better resolution of ORDER BY terms in compound queries.  Candidate
solution for ticket #2822.  Needs more testing and documentation
before going final. (CVS 4602)

FossilOrigin-Name: 62a78d212c53a9cb1759d03134653a75f3a086b6

17 years agoStrengthen the tests for aggregate functions in GROUP BY clauses.
drh [Sat, 8 Dec 2007 18:01:30 +0000 (18:01 +0000)] 
Strengthen the tests for aggregate functions in GROUP BY clauses.
Changes to test cases only.  No changes to code. (CVS 4601)

FossilOrigin-Name: 4be8e6765bf8bc48747b2542f2ed77066fb9dcb9

17 years agoFix a bug in the debugging printf logic. (CVS 4600)
drh [Sat, 8 Dec 2007 17:55:35 +0000 (17:55 +0000)] 
Fix a bug in the debugging printf logic. (CVS 4600)

FossilOrigin-Name: 1d6a9f5fafb862fb31c8589fa118a5672bad6abd

17 years agoChange prefix search from O(N*M) to O(NlogM). The previous code
shess [Fri, 7 Dec 2007 23:47:53 +0000 (23:47 +0000)] 
Change prefix search from O(N*M) to O(NlogM).  The previous code
linearly merged the doclists, so as the accumulated list got large,
things got slow (the M term, a fucntion of the number of documents in
the index).  This change does pairwise merges until a single doclist
remains.  A test search of 't*' against a database of RFC text
improves from 1m16s to 4.75s. (CVS 4599)

FossilOrigin-Name: feef1b15d645d638b4a05742f214b0445fa7e176

17 years agoIn shared-cache mode, make sure the busy hander invoked is the
drh [Fri, 7 Dec 2007 18:55:28 +0000 (18:55 +0000)] 
In shared-cache mode, make sure the busy hander invoked is the
busy handler associated with the database connection that caused
the lock contention in the first place. (CVS 4598)

FossilOrigin-Name: c9eb65912f61ce0a6b66fe253652a1827e46b12a

17 years agoGet the LIKE and GLOB operators working again on systems using the
drh [Fri, 7 Dec 2007 18:39:04 +0000 (18:39 +0000)] 
Get the LIKE and GLOB operators working again on systems using the
EBCDIC character set. (CVS 4597)

FossilOrigin-Name: 754298a74e3d889f3767daba058262613d20a601

17 years agoFix a leaking database connection in the vacuum2 test script.
drh [Thu, 6 Dec 2007 17:41:27 +0000 (17:41 +0000)] 
Fix a leaking database connection in the vacuum2 test script.
Ticket #2827. (CVS 4596)

FossilOrigin-Name: f29deb5f0bfcd6d00795aeb66dece717a6c1768a

17 years agoUse the specified buffer length, not the maximum buffer length in
drh [Thu, 6 Dec 2007 13:26:20 +0000 (13:26 +0000)] 
Use the specified buffer length, not the maximum buffer length in
unixFullPathname() and related functions. (CVS 4595)

FossilOrigin-Name: f015a38771d98996366d66787b9b066f9ef5e248

17 years agoContinuing work on the C/C++ interface requirements that appears as
drh [Thu, 6 Dec 2007 02:42:07 +0000 (02:42 +0000)] 
Continuing work on the C/C++ interface requirements that appears as
comments in sqlite.h.in. (CVS 4594)

FossilOrigin-Name: 2130e7125187ca46df3f65237f933b0e568a36ed

17 years agoBegin adding requirements numbers to the C/C++ interface documentation. (CVS 4593)
drh [Wed, 5 Dec 2007 18:05:16 +0000 (18:05 +0000)] 
Begin adding requirements numbers to the C/C++ interface documentation. (CVS 4593)

FossilOrigin-Name: ae1936aadf00bec91750d41be7507cf1b81fc411

17 years agoAdd the ability to change the autovacuum status of an existing database
drh [Wed, 5 Dec 2007 01:38:23 +0000 (01:38 +0000)] 
Add the ability to change the autovacuum status of an existing database
by setting the auto_vacuum pragma then running the VACUUM command. (CVS 4592)

FossilOrigin-Name: bdfc19e838b369a8c5d5d23663fad690f55ba3d7

17 years agoMake sure statement journals are initiated when doing DROP operations
drh [Tue, 4 Dec 2007 16:54:52 +0000 (16:54 +0000)] 
Make sure statement journals are initiated when doing DROP operations
(since the DROP might fail after sqlite_master changes).  Also make
sure statement journals are initiated if there are pending SELECT
statements.  Ticket #2820. (CVS 4591)

FossilOrigin-Name: bf34284ff0c60ae6e735e09bb29cd48b158e8dce

17 years agoFix a bug in the TCL code for sqlite3_analyzer. (CVS 4590)
drh [Tue, 4 Dec 2007 13:41:51 +0000 (13:41 +0000)] 
Fix a bug in the TCL code for sqlite3_analyzer. (CVS 4590)

FossilOrigin-Name: 7c2cf4542852a81daf29a930ab103c52bb678326

17 years agoClarify the operation of sqlite3_blob_close() in the API documentation.
drh [Tue, 4 Dec 2007 13:22:43 +0000 (13:22 +0000)] 
Clarify the operation of sqlite3_blob_close() in the API documentation.
Ticket #2815. (CVS 4589)

FossilOrigin-Name: 78f359dffa6f4af4d5b7e4523f451e0e405350c0

17 years agoDo not require os_other.h if compiling with -DOS_OTHER=1. (CVS 4588)
drh [Mon, 3 Dec 2007 21:52:09 +0000 (21:52 +0000)] 
Do not require os_other.h if compiling with -DOS_OTHER=1. (CVS 4588)

FossilOrigin-Name: 96ec39031e0b0b9a69e7b5647580326a87f94d2e

17 years agoWhen parsing CREATE INDEX statements from the sqlite_master table, do not search...
danielk1977 [Sun, 2 Dec 2007 11:46:34 +0000 (11:46 +0000)] 
When parsing CREATE INDEX statements from the sqlite_master table, do not search the temp database schema for the corresponding table. Only consider the database for which the schema is being parsed. Ticket #2817. (CVS 4587)

FossilOrigin-Name: e6f02aa5ae6da0befdf98fdd5884345f3cb7f5ea

17 years agoAnother fix to Makefile.in for mingw. (CVS 4586)
drh [Sat, 1 Dec 2007 19:25:17 +0000 (19:25 +0000)] 
Another fix to Makefile.in for mingw. (CVS 4586)

FossilOrigin-Name: cfaeb02554ab86fffbfb8eb2a78c7d8a59a9cba5

17 years agoBeginning attempts at casting the sqlite.h.in documentation into
drh [Sat, 1 Dec 2007 19:23:19 +0000 (19:23 +0000)] 
Beginning attempts at casting the sqlite.h.in documentation into
formal requirements. (CVS 4585)

FossilOrigin-Name: 2ea78d2cbd86edda6f998fbb364800d3ecf76479

17 years agoBug fix to Makefile.in to allow it to work with mingw. (CVS 4584)
drh [Sat, 1 Dec 2007 09:32:53 +0000 (09:32 +0000)] 
Bug fix to Makefile.in to allow it to work with mingw. (CVS 4584)

FossilOrigin-Name: fdca98d1eb44c05ffb3c42acb9f87f57460c4cc8

17 years agoAdd a few function requirements numbers to interfaces in the comments
drh [Fri, 30 Nov 2007 01:06:16 +0000 (01:06 +0000)] 
Add a few function requirements numbers to interfaces in the comments
of sqlite3.h.in.  This is experimental. (CVS 4583)

FossilOrigin-Name: b829a64515e88e83aecd339342bad3b140c86bb0

17 years agoMake sure we never try to "truncate" a file to a larger size. (CVS 4582)
drh [Thu, 29 Nov 2007 18:44:27 +0000 (18:44 +0000)] 
Make sure we never try to "truncate" a file to a larger size. (CVS 4582)

FossilOrigin-Name: 7d2f6a1d6c5ab89a3b65fbcaf172abf6d81e206b

17 years agoAdd the optional (and experimental) mmap() memory allocator in the
drh [Thu, 29 Nov 2007 18:36:49 +0000 (18:36 +0000)] 
Add the optional (and experimental) mmap() memory allocator in the
mem4.c module. (CVS 4581)

FossilOrigin-Name: cfd683ac80fd043343e0f0af90805058daa3818d