/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 ancestors of [bf81aabf]

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: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
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
20:58
Use sqlite3NestedParse to implement CREATE INDEX. (CVS 2070) check-in: 47d8ebda user: drh tags: trunk
17:17
Create table now works with sqlite3NestedParse. This changed uncovered a latent bug in xprintf which is also fixed. (CVS 2069) check-in: b0506bdd user: drh tags: trunk
16:37
Do not truncate a database file until after fsync() has been called on the journal. (CVS 2068) check-in: cfee7f4a user: danielk1977 tags: trunk
15:45
Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) check-in: b9d5f007 user: danielk1977 tags: trunk
12:58
Auto-vacuum bug: Don't set meta(3) to a pointer-map page number when deleting a table. (CVS 2066) check-in: 44a015b3 user: danielk1977 tags: trunk
12:27
Fix allocation of tables in an auto-vacuum database when the required root-page is on the free-list. (CVS 2065) check-in: 4e243337 user: danielk1977 tags: trunk
09:19
Don't code an OP_Statement within sqlite3NestedParse(). Also a correction to the UPDATE statement used within destroyRootPage(). (CVS 2064) check-in: fdcc31f0 user: danielk1977 tags: trunk
06:02
When using sqlite3NestedParse() to modify the sqlite_master table, do not code OP_Callback. (CVS 2063) check-in: 296a298c user: danielk1977 tags: trunk
05:23
Another bug fix from two check-ins ago. (CVS 2062) check-in: c46eef2f user: drh tags: trunk
05:20
Fix a bug in the previous check-in. (CVS 2061) check-in: 9d259d48 user: drh tags: trunk
05:10
More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060) check-in: ac2d5a60 user: drh tags: trunk
03:56
Begin using sqlite3NestedParse() to generate sections of code. (CVS 2059) check-in: 2d302931 user: drh tags: trunk
01:45
Fix bug introduced with (2057). (CVS 2058) check-in: aed2e623 user: danielk1977 tags: trunk
01:24
Pop the value pushed by OP_Destroy if SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2057) check-in: b0c10334 user: danielk1977 tags: trunk