]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
17 years agoMore work toward converting the VM into a register-based machine. (CVS 4704)
drh [Thu, 10 Jan 2008 23:50:11 +0000 (23:50 +0000)] 
More work toward converting the VM into a register-based machine. (CVS 4704)

FossilOrigin-Name: 8cbd46517f407b3b1ce187b623db10f00aa415ea

17 years agoContinuing work toward registerizing the code generator. (CVS 4703)
drh [Thu, 10 Jan 2008 03:46:36 +0000 (03:46 +0000)] 
Continuing work toward registerizing the code generator. (CVS 4703)

FossilOrigin-Name: 173698c963473ab1b9db88b23a2de82e4097b96d

17 years agoFix mixing quote excapes in an awk script. Ticket #2877. (CVS 4702)
drh [Thu, 10 Jan 2008 00:08:43 +0000 (00:08 +0000)] 
Fix mixing quote excapes in an awk script.  Ticket #2877. (CVS 4702)

FossilOrigin-Name: 05fbca91085cb1b271a05e62181596b4f6f1bb9e

17 years agoFix a test script problem associated with the new crash4.test file.
drh [Wed, 9 Jan 2008 23:21:25 +0000 (23:21 +0000)] 
Fix a test script problem associated with the new crash4.test file.
Ticket #2882. (CVS 4701)

FossilOrigin-Name: 1134c5ea7116bb2f342ccf09548d075c308c427b

17 years agoAll essential opcodes can now operate out of registers and completely
drh [Wed, 9 Jan 2008 23:04:12 +0000 (23:04 +0000)] 
All essential opcodes can now operate out of registers and completely
avoid the stack.  Many still optionally use the stack to support legacy
code generation, but the stack is not required.  The next step is to
update all code generation to avoid using the stack. (CVS 4700)

FossilOrigin-Name: e3cf1c1c114bcda8fe577beb5ee55b4a651b96db

17 years agoFix the build for AIX and other systems where "char" is unsigned by default. (CVS...
drh [Wed, 9 Jan 2008 18:31:45 +0000 (18:31 +0000)] 
Fix the build for AIX and other systems where "char" is unsigned by default. (CVS 4699)

FossilOrigin-Name: 47672af0c658573c6b305d224c6901058b8c0e00

17 years agoContinued work toward converting to a register-based VM. (CVS 4698)
drh [Wed, 9 Jan 2008 02:15:38 +0000 (02:15 +0000)] 
Continued work toward converting to a register-based VM. (CVS 4698)

FossilOrigin-Name: 92deff07bba2089bbe011f44defb3a0ac1362d56

17 years agoRegisterify the comparison opcodes. (CVS 4697)
drh [Tue, 8 Jan 2008 23:54:25 +0000 (23:54 +0000)] 
Registerify the comparison opcodes. (CVS 4697)

FossilOrigin-Name: 8862ce9ceefba4f5d1ffbd51d824c05f42a58c22

17 years agoFinish registerizing the core logic of INSERT and UPDATE. (CVS 4696)
drh [Tue, 8 Jan 2008 18:57:50 +0000 (18:57 +0000)] 
Finish registerizing the core logic of INSERT and UPDATE. (CVS 4696)

FossilOrigin-Name: 5fd1036788dbbc48ff1c746d2e1ba12b04a7e58c

17 years agoAdd crash4.test with additional crash testing. (CVS 4695)
drh [Tue, 8 Jan 2008 16:03:49 +0000 (16:03 +0000)] 
Add crash4.test with additional crash testing. (CVS 4695)

FossilOrigin-Name: 87b4ac4b73fb84411ced9e9a859dd0e2d211c4b3

17 years agoAdd additional randomness to crash tests. (CVS 4694)
drh [Tue, 8 Jan 2008 15:18:52 +0000 (15:18 +0000)] 
Add additional randomness to crash tests. (CVS 4694)

FossilOrigin-Name: 3ccce1f58be46787f8a35f0fa6d738ed126c0f07

17 years agoProgress toward registerification of the constraint checking logic for
drh [Tue, 8 Jan 2008 02:57:55 +0000 (02:57 +0000)] 
Progress toward registerification of the constraint checking logic for
INSERT and UPDATE. (CVS 4693)

FossilOrigin-Name: b9bf509e39f5ac38c2149d2a648f68e5df5ae9e3

17 years agoRegisterify the AUTOINCREMENT processing and the OP_IsNull and OP_NotNull
drh [Mon, 7 Jan 2008 19:20:24 +0000 (19:20 +0000)] 
Registerify the AUTOINCREMENT processing and the OP_IsNull and OP_NotNull
operators. (CVS 4692)

FossilOrigin-Name: aa48867cfa04da265b906e5b583bc7ac6b6a1157

17 years agoComment changes in select.c. (CVS 4691)
danielk1977 [Mon, 7 Jan 2008 10:16:40 +0000 (10:16 +0000)] 
Comment changes in select.c. (CVS 4691)

FossilOrigin-Name: 38020592f15c072e0d221ae2e0df13508ac4bd49

17 years agoRegisterify the SRT_Subroutine destination for SELECT results. (CVS 4690)
drh [Sun, 6 Jan 2008 00:25:21 +0000 (00:25 +0000)] 
Registerify the SRT_Subroutine destination for SELECT results. (CVS 4690)

FossilOrigin-Name: 8201f71729c3afbb41764cea3cda65b03150cb0c

17 years agoModify OP_RegMakeRec to take a base register and count and optionally
drh [Sat, 5 Jan 2008 18:48:24 +0000 (18:48 +0000)] 
Modify OP_RegMakeRec to take a base register and count and optionally
store results in the register specified by P3. (CVS 4689)

FossilOrigin-Name: 6bb1b1bc1858028b743a4f660d42d5e9595dc022

17 years agoFix a memory leak introduced with #4687. (CVS 4688)
danielk1977 [Sat, 5 Jan 2008 18:44:29 +0000 (18:44 +0000)] 
Fix a memory leak introduced with #4687. (CVS 4688)

FossilOrigin-Name: 2b98b0fca82e285ae6b38384587aafa27985fa34

17 years agoFirst pass at optimizing max()/min() as described in #2853. Some refinements to come...
danielk1977 [Sat, 5 Jan 2008 17:39:29 +0000 (17:39 +0000)] 
First pass at optimizing max()/min() as described in #2853. Some refinements to come. (CVS 4687)

FossilOrigin-Name: c449e04f1870b1ff726c95c0bf1c6c6a22ca588a

17 years agoRegisterify binary operators. Add register tracing to debugging output. (CVS 4686)
drh [Sat, 5 Jan 2008 16:29:28 +0000 (16:29 +0000)] 
Registerify binary operators.  Add register tracing to debugging output. (CVS 4686)

FossilOrigin-Name: 66396d2f0289e36b5fc0af5078c08d1b17f342ae

17 years agoExpression code generator takes advantage of recent opcode changes. (CVS 4685)
drh [Sat, 5 Jan 2008 06:51:30 +0000 (06:51 +0000)] 
Expression code generator takes advantage of recent opcode changes. (CVS 4685)

FossilOrigin-Name: 6c78d2a49a3e6ee8bc31f16488a430cba9eda59d

17 years agoRegister-ify the OP_ForceInt opcode. (CVS 4684)
drh [Sat, 5 Jan 2008 05:38:21 +0000 (05:38 +0000)] 
Register-ify the OP_ForceInt opcode. (CVS 4684)

FossilOrigin-Name: 32380dcabcd3839e79f91430b0c250d6e02d9243

17 years agoRegister-ify the OP_AddImm and all casting opcodes. Omit the
drh [Sat, 5 Jan 2008 05:20:10 +0000 (05:20 +0000)] 
Register-ify the OP_AddImm and all casting opcodes.  Omit the
OP_MemIncr opcode. (CVS 4683)

FossilOrigin-Name: 3e8a07dd3cc9921ad39e379576abb0b485a42202

17 years agoGet rid of OP_Dup, OP_MemStore, OP_MemLoad, and OP_MemMove. Replace
drh [Sat, 5 Jan 2008 04:06:03 +0000 (04:06 +0000)] 
Get rid of OP_Dup, OP_MemStore, OP_MemLoad, and OP_MemMove.  Replace
with OP_Copy, OP_SCopy, and OP_Move.  Add the infrastructure for
operation properties in1, in2, in3, out2, and out3 but do not yet
use any of these. (CVS 4682)

FossilOrigin-Name: cc149eb9ca3c672cc6fea3528353234ac2ed5745

17 years agoImplement the out2-prerelease opcode design pattern. (CVS 4681)
drh [Fri, 4 Jan 2008 22:01:03 +0000 (22:01 +0000)] 
Implement the out2-prerelease opcode design pattern. (CVS 4681)

FossilOrigin-Name: fe057a88d0038ac349ea41883b979ceba6ae410a

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