SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around cf4a11b2a8.

2008-01-05
05:38
Register-ify the OP_ForceInt opcode. (CVS 4684) check-in: 32380dca user: drh tags: trunk
05:20
Register-ify the OP_AddImm and all casting opcodes. Omit the OP_MemIncr opcode. (CVS 4683) check-in: 3e8a07dd user: drh tags: trunk
04:06
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) check-in: cc149eb9 user: drh tags: trunk
2008-01-04
22:01
Implement the out2-prerelease opcode design pattern. (CVS 4681) check-in: fe057a88 user: drh tags: trunk
19:33
Allow the P2 operand to be negative on opcodes that are not jumps. (CVS 4680) check-in: 717bcd11 user: drh tags: trunk
19:12
Fix mkopcodeh.awk so that it works on a mac. (CVS 4679) check-in: 59d3dfa4 user: drh tags: trunk
19:10
Some modifications to insert.c to work without using the stack. (CVS 4678) check-in: d9ac6bee user: danielk1977 tags: trunk
16:50
Replace the NOPUSH_MASKs with a bit-vector mechanism that can contain several different properties about each opcode. (CVS 4677) check-in: 042dcb96 user: drh tags: trunk
13:57
Modify FifoRead and FifoWrite to work exclusively with memory cells. (CVS 4676) check-in: 2c913908 user: danielk1977 tags: trunk
13:24
Modify the code generated for a DELETE to use registers instead of the vdbe stack. (CVS 4675) check-in: 173f2813 user: danielk1977 tags: trunk
11:01
Add OP_MemSet, for setting a memory cell to a string value. (CVS 4674) check-in: 8bb9f970 user: danielk1977 tags: trunk
2008-01-03
23:44
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) check-in: 61bfb77c user: drh tags: trunk
18:56
Fix typo in comment. Ticket #2870. (CVS 4672) check-in: e97e4578 user: danielk1977 tags: trunk
18:44
Update OP_Rowid, OP_Column and related opcodes to use registers. (CVS 4671) check-in: 4f396707 user: drh tags: trunk
18:39
Modify VFilter and VRename to use registers instead of the vdbe stack for inputs. (CVS 4670) check-in: 253ed40a user: danielk1977 tags: trunk
18:03
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) check-in: 0b849805 user: drh tags: trunk
17:31
Modify OP_VUpdate to read arguments from a range of memory cells instead of from the stack. (CVS 4668) check-in: 955b15a0 user: danielk1977 tags: trunk
11:50
Change the VdbeOp.p4 union to include specific pointer types for the various values of VdbeOp.p4type. (CVS 4667) check-in: 7e8330c8 user: danielk1977 tags: trunk
09:51
Change the OP_Insert opcode to read the key and data to insert from memory cells, not the stack. (CVS 4666) check-in: 46501f49 user: danielk1977 tags: trunk
08:18
Change the output of vdbe_trace etc. to include operands p3 and p5. (CVS 4665) check-in: 76f2040b user: danielk1977 tags: trunk
08:08
Combine the OP_Column and OP_DfltValue opcodes. (CVS 4664) check-in: c30f8206 user: danielk1977 tags: trunk
07:54
Change OP_OpenRead and OP_OpenWrite so that the database number is read from the P3 operand, not the stack. (CVS 4663) check-in: 35da261d user: danielk1977 tags: trunk
07:09
Fix EXPLAIN and EXPLAIN query plan to work with new opcode format. (CVS 4662) check-in: b166c33a user: danielk1977 tags: trunk
01:28
Revamp sqlite3VdbeAddOpList() so that the structure holds integer values for P1, P2, and P3. (CVS 4661) check-in: 4dc507d8 user: drh tags: trunk
00:01
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) check-in: 027875e4 user: drh tags: trunk
2008-01-02
17:25
Add operands p4 and p5 to the VdbeOp structure. (CVS 4659) check-in: ad528735 user: drh tags: trunk
17:11
Minor optimizations for sub-selects in EXISTS(...) expressions: Discard any DISTINCT or ORDER BY clauses and do not calculate any column values. (CVS 4658) check-in: fbd17a89 user: danielk1977 tags: trunk
16:27
Combine the eDest and iParm arguments to sqlite3Select() into a single type - "SelectDest". (CVS 4657) check-in: 86dcdfe6 user: danielk1977 tags: trunk
14:28
Add opcodes OP_ResultRow and OP_RegMakeRec which are register-based equivalents to OP_Callback and OP_MakeRecord. Use the new opcodes. (CVS 4656) check-in: 4c7f35da user: drh tags: trunk
13:05
Remove a surplus OP_Close from delete.c. Fixes a problem with (4654). (CVS 4655) check-in: 03cc91b3 user: drh tags: trunk
11:50
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) check-in: f1966a8a user: danielk1977 tags: trunk
04:41
Add some extra tests for the recent trigger compilation optimization. (CVS 4653) check-in: de54dad8 user: danielk1977 tags: trunk
00:34
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) check-in: 051ec01f user: drh tags: trunk
2008-01-01
19:02
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) check-in: e08a33ed user: danielk1977 tags: trunk
06:19
Silence a harmless unitialised variable warning in btree.c. Ticket #2862. (CVS 4650) check-in: b51782cc user: danielk1977 tags: trunk
05:49
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) check-in: 6dea8c16 user: danielk1977 tags: trunk
2007-12-30
23:38
fix case in os2GetTempname() where none of the usual environment variables are set to not overwrite two unrelated bytes (CVS 4648) check-in: 9719a063 user: pweilbacher tags: trunk
23:35
simplify os2FullPathname() and at the same time make the allocations more robust (CVS 4647) check-in: 6f8952a8 user: pweilbacher tags: trunk
23:29
move variable declaration to be able to compile sqlite3_mutex_alloc() with older compilers (like EMX/gcc 2.8.1) (CVS 4646) check-in: a568a9cf user: pweilbacher tags: trunk
2007-12-29
13:39
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) check-in: 2ddc8d72 user: danielk1977 tags: trunk
13:18
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) check-in: d027f91c user: drh tags: trunk
2007-12-27
15:12
Fix a race condition that can occur when reloading the database schema in shared-cache mode. (CVS 4643) check-in: b37babef user: danielk1977 tags: trunk
2007-12-21
04:47
Fix for #2854. "BEGIN EXCLUSIVE" excludes other shared cache users from using the database. (CVS 4642) check-in: 2e59b1d0 user: danielk1977 tags: trunk
00:02
Fix some issues with lemon. Tickets #2852 and #2835. (CVS 4641) check-in: 5283e0d1 user: drh tags: trunk
2007-12-19
09:20
Add the ioerr3.test file, that found an error in br3317. The error is not present in this branch. (CVS 4640) check-in: d3efec14 user: danielk1977 tags: trunk
2007-12-18
17:50
Fix a problem with SQLITE_MAX_SQL_LENGTH introduced by check-in (4636). Ticket #2851 (CVS 4639) check-in: cdd866f5 user: drh tags: trunk
15:41
In the CLI, quote strings that contain the separator character. Ticket #2850. (CVS 4638) check-in: 493a17c4 user: drh tags: trunk
11:19
Fix for typo in main.mk: the output of target sqlite3 was testcli. (CVS 4637) check-in: 15675dc5 user: danielk1977 tags: trunk
2007-12-17
16:20
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) check-in: 07aeca3b user: drh tags: trunk
2007-12-14
17:39
Version 3.5.4 (CVS 4635) check-in: cf4a11b2 user: drh tags: trunk
17:24
Update library version number to 3.5.4. (CVS 4634) check-in: 5c653bfc user: drh tags: trunk
17:24
Fix a C++-ism in recent changes to select.c. (CVS 4633) check-in: 4a008050 user: drh tags: trunk
17:22
Change to the crash simulator to give better diagnostics in case it runs out of memory while using the mem3.c allocator. (CVS 4632) check-in: 0d5747db user: drh tags: trunk
16:11
Fix a typo in the previous check-in. Also simplify a line in select.c. (CVS 4631) check-in: 86f45d7b user: drh tags: trunk
15:12
Fix an out-of-memory NULL pointer defer in the code generator. Ticket #2843. (CVS 4630) check-in: b821b6ed user: drh tags: trunk
2007-12-13
21:54
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) check-in: 4e91a267 user: drh tags: trunk
19:15
Fix a memory leak that can occur following a malloc() failure. (CVS 4628) check-in: 993a2130 user: danielk1977 tags: trunk
18:29
Fix the location of a #include in test_thread.c. ticket #2826. (CVS 4627) check-in: 6129fce8 user: drh tags: trunk
18:24
Add test cases for errors in "IN(SELECT ...)" expressions where the SELECT statement is a compound SELECT. No faults found. (CVS 4626) check-in: 49b67adf user: danielk1977 tags: trunk
18:20
Add new makefile target for "testcli" that builds a CLI using individual source files instead of the amalgamation. Ticket #2838. (CVS 4625) check-in: b6f04e5b user: drh tags: trunk
17:50
Additional test cases for tkt2822. Fix a related bug in printf(). (CVS 4624) check-in: 8f184e40 user: drh tags: trunk
08:15
Return an error if the user attempts to rename a view. Related to (but not a fix for) #2831. (CVS 4623) check-in: 19d56d99 user: danielk1977 tags: trunk
07:58
Adjust the test suite to account for recent changes related to #2822. Most changes are related to English language error messages only. (CVS 4622) check-in: 2f88b9b3 user: danielk1977 tags: trunk
03:45
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) check-in: 56063ec8 user: drh tags: trunk
02:45
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) check-in: bbddf16a user: drh tags: trunk
2007-12-12
22:24
Minor cleanup changes on the OP_StackDepth opcode. Added the sidedelete test for additional testing of ticket #2832. (CVS 4619) check-in: c0689409 user: drh tags: trunk
18:05
Remove an (explain) accidentally left in tkt2832.test. (CVS 4618) check-in: 48947e2b user: danielk1977 tags: trunk
17:42
Try to find some more stack leaks by adding OP_StackDepth to loops in DML statements. None were found. (CVS 4617) check-in: 12c3029b user: danielk1977 tags: trunk
17:19
Remove a couple of lines in delete.c that weren't doing anything. (CVS 4616) check-in: 86332c79 user: danielk1977 tags: trunk
16:06
Fix some problems similar to #2832, but caused by triggers instead of an OR REPLACE clause. (CVS 4615) check-in: ee98ae17 user: danielk1977 tags: trunk
14:46
Test file containing minimal example of bug #2832. (CVS 4614) check-in: ed2e61a9 user: danielk1977 tags: trunk
12:25
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) check-in: 18e10f81 user: drh tags: trunk
12:00
Add a new OP_StackDepth opcode to help detect VDBE stack leaks early, before they cause damage. For diagnostics in ticket #2832. (CVS 4612) check-in: 3fd6a267 user: drh tags: trunk
04:38
Fix test numbering in tkt2822.test. Ticket #2830. (CVS 4611) check-in: 8fe8e9c4 user: danielk1977 tags: trunk
2007-12-11
20:04
Fix a comment on the SQLITE_SQL_MAX_LENGTH definition. (CVS 4610) check-in: 9335c940 user: drh tags: trunk
19:34
Build the CLI using the amalgamation. Relax the limit on SQL statement length when building the CLI. (CVS 4609) check-in: a5d81cd3 user: drh tags: trunk
04:23
Fix a 'const' issue in trimFunc(). (CVS 4608) check-in: 64787d78 user: danielk1977 tags: trunk
2007-12-10
21:11
Make sure the windows driver responds correctly to the SQLITE_OPEN_DELETEONCLOSE flag. Ticket #2829. (CVS 4607) check-in: 19db91fd user: drh tags: trunk
18:51
Further modifications to do with ORDER BY and compound SELECT queries. Related to ticket #2822. (CVS 4606) check-in: 0d9b0e6e user: danielk1977 tags: trunk
18:07
Fix a macro in func.c that causes problems for the amalgamation. (CVS 4605) check-in: 6adbe91e user: drh tags: trunk
17:55
Fix a bug in the compilation procedures for the Linux shared library that includes the TCL bindings. (CVS 4604) check-in: d384810a user: drh tags: trunk
05:03
Fix compilation/testing with OMIT_SUBQUERY defined. Ticket #2828. (CVS 4603) check-in: 0b34a186 user: danielk1977 tags: trunk
2007-12-08
21:10
Better resolution of ORDER BY terms in compound queries. Candidate solution for ticket #2822. Needs more testing and documentation before going final. (CVS 4602) check-in: 62a78d21 user: drh tags: trunk
18:01
Strengthen the tests for aggregate functions in GROUP BY clauses. Changes to test cases only. No changes to code. (CVS 4601) check-in: 4be8e676 user: drh tags: trunk
17:55
Fix a bug in the debugging printf logic. (CVS 4600) check-in: 1d6a9f5f user: drh tags: trunk
2007-12-07
23:47
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) check-in: feef1b15 user: shess tags: trunk
18:55
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) check-in: c9eb6591 user: drh tags: trunk
18:39
Get the LIKE and GLOB operators working again on systems using the EBCDIC character set. (CVS 4597) check-in: 754298a7 user: drh tags: trunk
2007-12-06
17:41
Fix a leaking database connection in the vacuum2 test script. Ticket #2827. (CVS 4596) check-in: f29deb5f user: drh tags: trunk
13:26
Use the specified buffer length, not the maximum buffer length in unixFullPathname() and related functions. (CVS 4595) check-in: f015a387 user: drh tags: trunk
02:42
Continuing work on the C/C++ interface requirements that appears as comments in sqlite.h.in. (CVS 4594) check-in: 2130e712 user: drh tags: trunk
2007-12-05
18:05
Begin adding requirements numbers to the C/C++ interface documentation. (CVS 4593) check-in: ae1936aa user: drh tags: trunk
01:38
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) check-in: bdfc19e8 user: drh tags: trunk
2007-12-04
16:54
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) check-in: bf34284f user: drh tags: trunk
13:41
Fix a bug in the TCL code for sqlite3_analyzer. (CVS 4590) check-in: 7c2cf454 user: drh tags: trunk
13:22
Clarify the operation of sqlite3_blob_close() in the API documentation. Ticket #2815. (CVS 4589) check-in: 78f359df user: drh tags: trunk
2007-12-03
21:52
Do not require os_other.h if compiling with -DOS_OTHER=1. (CVS 4588) check-in: 96ec3903 user: drh tags: trunk
2007-12-02
11:46
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) check-in: e6f02aa5 user: danielk1977 tags: trunk
2007-12-01
19:25
Another fix to Makefile.in for mingw. (CVS 4586) check-in: cfaeb025 user: drh tags: trunk
19:23
Beginning attempts at casting the sqlite.h.in documentation into formal requirements. (CVS 4585) check-in: 2ea78d2c user: drh tags: trunk