/ Timeline
Login

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

100 check-ins occurring around 7fa623f24a6c566c.

2004-12-19
00:11
The optimizer now uses only the index and ignores the table if it can get away with doing so, thus saving a single BTree search per row of result. This could potentially double the speed of certain queries. The code passes all regression tests but new tests to exercise the new functionality are yet to be added. (CVS 2170) check-in: e5aa4894 user: drh tags: trunk
2004-12-18
18:40
Improvements to the query optimizer. This is a work in progress. (CVS 2169) check-in: 9b86993f user: drh tags: trunk
2004-12-17
20:48
Fix a C++-ism in the previous change to tclsqlite.c. (CVS 2168) check-in: b49b8fdd user: drh tags: trunk
15:41
Add 'copy' method for tcl interface. Behaves similar to shell .import or COPY statment in 2.x. (CVS 2167) check-in: a9311d9d user: tpoindex tags: trunk
2004-12-16
21:09
Make sure LIMITs are handled correctly on UNION operators. Ticket #1035. (CVS 2166) check-in: ece0085f user: drh tags: trunk
2004-12-14
03:34
Minor code and comment cleanup. (CVS 2165) check-in: d012628a user: drh tags: trunk
2004-12-10
18:00
Factor the test for zName==NULL out of the loop. Ticket #1032. (CVS 2164) check-in: 7f38f67c user: drh tags: trunk
17:17
Fix a problem with the automatic generation of the opcode name table. (CVS 2163) check-in: 9eefabc9 user: drh tags: trunk
03:08
Back out the USE_TCL_STUBS changes because it breaks the build. I think the strategy needs to be to abandon libtool and use tcl.m4 to figure out how to build our own shared libraries. Ticket #1034. (CVS 2162) check-in: 7f4679b9 user: drh tags: trunk
02:20
Improvements to the --help option to configure. Ticket #1033. (CVS 2161) check-in: 3032cc2b user: drh tags: trunk
02:08
Add a -DUSE_TCL_STUBS to the standard Makefile. This might help with ticket #1034. Or maybe not. (CVS 2160) check-in: 4c30c373 user: drh tags: trunk
2004-12-09
18:29
Enhance sqlite3_bind_parameter_index so that is does not segfault if you call it incorrectly by passing NULL in place of the parameter name. Ticket #1032. (CVS 2159) check-in: bf81aabf user: drh tags: trunk
2004-12-07
15:41
Only evaluate expressions once for UPDATE and INSERT statements that have BEFORE triggers. Fix for ticket #980. (CVS 2158) check-in: 4852186a user: drh tags: trunk
14:06
Simplify the trigger logic for DELETE, INSERT, and UPDATE. (CVS 2157) check-in: 8e164ab2 user: drh tags: trunk
12:29
Remove the unused sqlite3_context.isStep element. (CVS 2156) check-in: 7b20f2b7 user: drh tags: trunk
02:14
Updates to API documentation and comments in sqlite3.h. (CVS 2155) check-in: 46584348 user: drh tags: trunk
2004-12-02
20:17
Get the build of sqlite3_analyzer working with Makefile.in. (CVS 2154) check-in: f7415a0d user: drh tags: trunk
2004-11-27
15:52
Disable the cursors. "make install" now builds and installs a TCL package for SQLite if TCL is installed on the system. (CVS 2153) check-in: d75014c2 user: drh tags: trunk
2004-11-25
13:50
The configure script now automatically detects tclConfig.sh and builds the Tcl extension only if tclConfig.sh is present. The Tcl extension can be disabled using --disable-tcl. (CVS 2152) check-in: 12424bef user: drh tags: trunk
2004-11-24
01:16
Fix a memory leak in pager.c. (CVS 2151) check-in: 0ad4ed87 user: drh tags: trunk
2004-11-23
22:16
fulltest runs now, but still finds a memory leak. (CVS 2150) check-in: 5944d51e user: drh tags: trunk
16:31
Fix a memory leak in ALTER TABLE. (CVS 2149) check-in: ba71716c user: danielk1977 tags: trunk
15:41
Add authorization callbacks for REINDEX. (CVS 2148) check-in: 9f0d744e user: danielk1977 tags: trunk
12:24
Include the 'FOR' keyword in builds that include cursors but not triggers. (CVS 2147) check-in: 3053d82d user: danielk1977 tags: trunk
11:16
Make the test suite pass when SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS is defined. (CVS 2146) check-in: ff20c623 user: danielk1977 tags: trunk
10:52
Ensure the test suite runs with SQLITE_OMIT_PAGER_PRAGMAS defined. (CVS 2145) check-in: 2d1f0b92 user: danielk1977 tags: trunk
10:13
Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) check-in: 6ccb589b user: danielk1977 tags: trunk
09:06
Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) check-in: 557be3ff user: danielk1977 tags: trunk
01:47
More work on the implementation of cursors, but they are still not functioning. (CVS 2142) check-in: 8b61d1ae user: drh tags: trunk
2004-11-22
19:12
Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) check-in: fc8c1393 user: drh tags: trunk
19:07
Fix a long-standing bug in btree.c in the sqlite3BtreePrevious() routine. The problem has gone unnoticed before now because it only occurs when you use the OP_Prev opcode on a B+Tree. (CVS 2140) check-in: 3d2536c4 user: drh tags: trunk
15:05
Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) check-in: 894c142d user: danielk1977 tags: trunk
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) check-in: 007be591 user: danielk1977 tags: trunk
11:51
Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) check-in: 53894988 user: danielk1977 tags: trunk
10:20
Fix a test-suite error made in check-in (2132) (CVS 2136) check-in: 48c7eb7f user: danielk1977 tags: trunk
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2135) check-in: ec6b48f4 user: danielk1977 tags: trunk
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2134) check-in: af635cab user: danielk1977 tags: trunk
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2133) check-in: 91acd87e user: danielk1977 tags: trunk
08:43
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) check-in: 711e8d76 user: danielk1977 tags: trunk
05:26
Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) check-in: 9df837c0 user: danielk1977 tags: trunk
03:34
Fix auth.test to work when SQLITE_OMIT_ALTERTABLE is defined. (CVS 2130) check-in: 27a8379b user: danielk1977 tags: trunk
2004-11-21
01:02
AUTOINCREMENT documentation added. Improvements to lang.html. (CVS 2129) check-in: ac72a1d5 user: drh tags: trunk
2004-11-20
21:02
Fix to the documentation on sqlite3_create_function. Ticket #899. (CVS 2128) check-in: 4ab1d012 user: drh tags: trunk
20:44
Avoid excess heap usage when copying expressions. Ticket #979. (CVS 2127) check-in: d10560c7 user: drh tags: trunk
20:42
Avoid excess heap usage when copying expressions. Ticket #979. (CVS 2126) check-in: 0f444c03 user: drh tags: version_2
20:31
Correct use of usableSize versus pageSize in btree.c. Ticket #1010. (CVS 2125) check-in: 5a4013ec user: drh tags: trunk
20:18
Better error message on an SQLITE_RANGE error. Ticket #991. (CVS 2124) check-in: accd432e user: drh tags: trunk
19:55
Rename source file sqlite.1 as sqlite3.1. Ticket #995. (CVS 2123) check-in: 297559c6 user: drh tags: trunk
19:18
Omit the maximum loop count on the random name chooser in the VACUUM command. Add a comment to explain why this is safe and does not result in an infinite loop. Ticket #1009. (CVS 2122) check-in: 1241086f user: drh tags: trunk
19:18
Rig the sqliteMalloc() routine so that we can make it fail multiple times in a row. Modify the malloc.test procedure to make malloc fail in this way and verify that the failures are still handled correctly. (CVS 2121) check-in: 519bc9d9 user: drh tags: trunk
19:01
Preserve the default_temp_store pragma across VACUUM in version 2.8. (Version 3.0 already does this.) Ticket #1008. (CVS 2120) check-in: 7fa623f2 user: drh tags: version_2
18:13
Fix segfaults that might occur after a malloc failure. (CVS 2119) check-in: 36877448 user: drh tags: trunk
08:17
Documentation for REINDEX and ALTER TABLE commands. (CVS 2118) check-in: aceaa5f6 user: danielk1977 tags: trunk
06:05
Add a documentation page for compilation options. Still some work to go. (CVS 2117) check-in: 5efa2d2a user: danielk1977 tags: trunk
2004-11-19
11:59
Split up the lang.html page into a seperate page for each command. (CVS 2116) check-in: ea315668 user: danielk1977 tags: trunk
08:41
Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) check-in: f635b6aa user: danielk1977 tags: trunk
08:02
Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) check-in: 6e971868 user: danielk1977 tags: trunk
07:07
When dropping a table, update the sqlite_sequence table first, as auto-vacuum mode may need to move sqlite_sequence when the btree table is dropped. (CVS 2113) check-in: 0514107b user: danielk1977 tags: trunk
05:14
Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) check-in: 1fd8e835 user: danielk1977 tags: trunk
2004-11-18
15:44
Handle triggers correctly in ALTER TABLE. (CVS 2111) check-in: c61b7de1 user: danielk1977 tags: trunk
13:49
Speed improvement on the LIKE command. (CVS 2110) check-in: 85d56beb user: drh tags: trunk
02:10
Fix an obsolete comment that resulted in incorrect documentation. Ticket #1003. (CVS 2109) check-in: c93a9e18 user: drh tags: trunk
02:04
Clarify the documentation of the sqlite3_create_function API. Ticket #1004. (CVS 2108) check-in: ae45ad86 user: drh tags: trunk
2004-11-17
16:41
Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) check-in: 49268c2b user: danielk1977 tags: trunk
10:22
Extra tests and resulting bugfixes for btree cursors. (CVS 2106) check-in: e1530854 user: danielk1977 tags: trunk
2004-11-16
23:21
Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) check-in: e05f52d9 user: drh tags: trunk
15:50
Perform deletes in a single pass. (CVS 2104) check-in: a2e1c35b user: danielk1977 tags: trunk
04:57
Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103) check-in: 6ad5fc8e user: danielk1977 tags: trunk
2004-11-15
23:42
Fix a typo in the header comment to the MakeRecord opcode so that the documentation generator will actually see the opcode description. Ticket #1001. (CVS 2102) check-in: 33c9b647 user: drh tags: trunk
01:40
Add test cases for escape characters in the GLOB operator. (CVS 2101) check-in: bb2d9ff8 user: drh tags: trunk
2004-11-14
21:56
The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) check-in: 98c7a554 user: drh tags: trunk
04:04
Changes toward reducing code size when SQLITE_OMIT_UTF16 is enabled. (CVS 2099) check-in: 59a0a8b7 user: drh tags: trunk
2004-11-13
15:59
More compile-time options for removing components. (CVS 2098) check-in: dcbc0c22 user: drh tags: trunk
13:19
Code toward having btree cursors persist when their table is written too. Doesn't work properly yet. (CVS 2097) check-in: 5eaa18d4 user: danielk1977 tags: trunk
03:59
Fix the keyword generator so that it works with SQLITE_OMIT_ALTERTABLE. (CVS 2096) check-in: 60ace998 user: drh tags: trunk
03:48
Autoincrement is now working and has regression tests. (CVS 2095) check-in: 10c712a2 user: drh tags: trunk
2004-11-12
16:12
Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) check-in: 5e058318 user: danielk1977 tags: trunk
15:53
Add authorization callbacks to ALTER TABLE. (CVS 2093) check-in: c4115aa3 user: danielk1977 tags: trunk
13:42
Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) check-in: a1b2cc63 user: danielk1977 tags: trunk
03:56
Autoincrement code installed. Simple smoke-testing only. No regression tests developed yet. (CVS 2091) check-in: 8fde833c user: drh tags: trunk
2004-11-11
19:32
Website updates. (CVS 2090) check-in: 60fb0cef user: drh tags: trunk
05:10
Add the schema_cookie and user_cookie pragmas. (CVS 2089) check-in: d28d1d68 user: danielk1977 tags: trunk
01:50
Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) check-in: c85f13f8 user: danielk1977 tags: trunk
2004-11-10
15:27
Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) check-in: 0747b558 user: danielk1977 tags: trunk
12:34
Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086) check-in: 540ce7de user: danielk1977 tags: trunk
11:55
Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) check-in: 8e5c2e5d user: danielk1977 tags: trunk
05:48
Add user documentation for the "pragma auto_vacuum" command. (CVS 2084) check-in: fe200eaf user: danielk1977 tags: trunk
2004-11-09
16:13
Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) check-in: f81b9c1c user: danielk1977 tags: trunk
12:44
Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) check-in: 0d27c8ff user: danielk1977 tags: trunk
07:42
Refactor the space-analysis script for readability. (CVS 2081) check-in: 63f2ee22 user: danielk1977 tags: trunk
2004-11-08
16:15
Update the space-analyzer tool to support auto-vacuum databases. (CVS 2080) check-in: 1cb80866 user: danielk1977 tags: trunk
12:32
A few more auto-vacuum tests. (CVS 2079) check-in: 9d4a60bb user: danielk1977 tags: trunk
09:51
Check in the file autovacuum_crash.test that should be part of the previous check-in. (CVS 2078) check-in: 9d7cd1f7 user: danielk1977 tags: trunk
09:26
Test auto-vacuum mode for crash-proofness. Also fix a bug related to the same. (CVS 2077) check-in: 839ad771 user: danielk1977 tags: trunk
07:13
Auto-vacuum: Account for the page reserved for windows locking (PENDING_BYTE). (CVS 2076) check-in: d6335698 user: danielk1977 tags: trunk
2004-11-07
13:01
Reindex tests added and bugs fixed. (CVS 2075) check-in: ad433ec2 user: drh tags: trunk
2004-11-06
12:26
Auto-vacuum: Ensure pages to be removed by database truncation are in the journal file. Also fix an sqlite3pager_movepage() bug. (CVS 2074) check-in: 081676e4 user: danielk1977 tags: trunk
00:02
Compile and pass the quick regression tests with autovacuum disabled. (CVS 2073) check-in: 89b9026a user: drh tags: trunk
2004-11-05
23:46
First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072) check-in: 11dba47e user: drh tags: trunk
22:18
Use sqlite3NestedParse to implement DROP INDEX. (CVS 2071) check-in: 0f81aa5b user: drh tags: trunk