SQLite

Timeline
Login

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

100 check-ins occurring around 1241086f23a2ef7a.

2004-12-25
01:03
Fix ticket #1046 by removing code and simplifying the query optimizer. Remarkably, this simplification also makes the optimizer do a better job. Ticket #1051 was fixed as a side-effect. (CVS 2172) (check-in: 5fd1f471 user: drh tags: trunk)
2004-12-20
19:01
Add PRAGMA 'temp_store_directory'. Added os_*.c function sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into invalidateTempStorage(). (CVS 2171) (check-in: 772e22cb user: tpoindex tags: trunk)
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)