]>
git.ipfire.org Git - thirdparty/sqlite.git/log
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
drh [Thu, 10 Jan 2008 03:46:36 +0000 (03:46 +0000)]
Continuing work toward registerizing the code generator. (CVS 4703)
FossilOrigin-Name:
173698c963473ab1b9db88b23a2de82e4097b96d
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
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
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
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
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
drh [Tue, 8 Jan 2008 23:54:25 +0000 (23:54 +0000)]
Registerify the comparison opcodes. (CVS 4697)
FossilOrigin-Name:
8862ce9ceefba4f5d1ffbd51d824c05f42a58c22
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
drh [Tue, 8 Jan 2008 16:03:49 +0000 (16:03 +0000)]
Add crash4.test with additional crash testing. (CVS 4695)
FossilOrigin-Name:
87b4ac4b73fb84411ced9e9a859dd0e2d211c4b3
drh [Tue, 8 Jan 2008 15:18:52 +0000 (15:18 +0000)]
Add additional randomness to crash tests. (CVS 4694)
FossilOrigin-Name:
3ccce1f58be46787f8a35f0fa6d738ed126c0f07
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
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
danielk1977 [Mon, 7 Jan 2008 10:16:40 +0000 (10:16 +0000)]
Comment changes in select.c. (CVS 4691)
FossilOrigin-Name:
38020592f15c072e0d221ae2e0df13508ac4bd49
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
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
danielk1977 [Sat, 5 Jan 2008 18:44:29 +0000 (18:44 +0000)]
Fix a memory leak introduced with #4687. (CVS 4688)
FossilOrigin-Name:
2b98b0fca82e285ae6b38384587aafa27985fa34
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
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
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
drh [Sat, 5 Jan 2008 05:38:21 +0000 (05:38 +0000)]
Register-ify the OP_ForceInt opcode. (CVS 4684)
FossilOrigin-Name:
32380dcabcd3839e79f91430b0c250d6e02d9243
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
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
drh [Fri, 4 Jan 2008 22:01:03 +0000 (22:01 +0000)]
Implement the out2-prerelease opcode design pattern. (CVS 4681)
FossilOrigin-Name:
fe057a88d0038ac349ea41883b979ceba6ae410a
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
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
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
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
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
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
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
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
danielk1977 [Thu, 3 Jan 2008 18:56:25 +0000 (18:56 +0000)]
Fix typo in comment. Ticket #2870. (CVS 4672)
FossilOrigin-Name:
e97e4578671d85b634072b8931cf55516bbd4ca8
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
drh [Fri, 14 Dec 2007 17:39:23 +0000 (17:39 +0000)]
Version 3.5.4 (CVS 4635)
FossilOrigin-Name:
cf4a11b2a8afcbc9cdcf5fa907ddb9865847ed11
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
danielk1977 [Tue, 11 Dec 2007 04:23:19 +0000 (04:23 +0000)]
Fix a 'const' issue in trimFunc(). (CVS 4608)
FossilOrigin-Name:
64787d78b99a549a87bc2baeff8ae87691612b77
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
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
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