/ 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 descendants of [4c30c373]

2005-01-21
18:28
Version 3.1.0 (alpha) (CVS 2260) check-in: 45094abe user: drh tags: trunk
18:19
Documentation updates prior to 3.1.0. (CVS 2259) check-in: fc4f1f13 user: drh tags: trunk
17:53
Initialize the random number generator from /dev/urandom, if available. (CVS 2258) check-in: aab8e7f8 user: drh tags: trunk
17:07
Change to mkopcodeh.awk to accomodate windows systems. (CVS 2257) check-in: 39786aa8 user: drh tags: trunk
17:03
Update change log for version 3.1.0. (CVS 2256) check-in: 4d9b8587 user: drh tags: trunk
15:52
Final preparations for the 3.1.0 alpha release. (CVS 2255) check-in: 17122c7e user: drh tags: trunk
11:55
Improve test coverage for minimum feature builds. (CVS 2254) check-in: 9c4d0e13 user: danielk1977 tags: trunk
08:13
Exclude a few more lines of code using OMIT macros. (CVS 2253) check-in: c6fc49e6 user: danielk1977 tags: trunk
04:25
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) check-in: d4e19efc user: danielk1977 tags: trunk
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) check-in: bb0254ab user: danielk1977 tags: trunk
02:34
Add a new test file for subqueries. (CVS 2250) check-in: de8ee3a2 user: drh tags: trunk
00:44
Change the implementation of ALTER TABLE so that it does not use the IN() operattor. (CVS 2249) check-in: 06887afb user: danielk1977 tags: trunk
00:22
Fix a segfault that occurs on a corrupt database. (CVS 2248) check-in: d1166472 user: drh tags: trunk
2005-01-20
23:23
Fix comment typo in mkopcodec.awk. (CVS 2247) check-in: 61771482 user: drh tags: trunk
22:48
Bug fixes and enhancements entered while on jury recess. (CVS 2246) check-in: 38401dfb user: drh tags: trunk
13:36
Added the SQLITE_OMIT_SUBQUERY compile-time option and the EXISTS operator. Regression tests are currently failing with an assertion fault. (CVS 2245) check-in: d30fdf0f user: drh tags: trunk
13:03
Remove a few more lines of code when SQLITE_OMIT_** macros are defined. (CVS 2244) check-in: 417bbba9 user: danielk1977 tags: trunk
11:32
Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) check-in: 5b1a9bf6 user: danielk1977 tags: trunk
05:24
Changes so that crash.test works when SQLITE_OMIT_PAGER_PRAGMAS is defined. (CVS 2242) check-in: f0add0a6 user: danielk1977 tags: trunk
02:17
Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) check-in: d267fb3c user: danielk1977 tags: trunk
02:14
Turn SQLITE_OMIT_CURSOR on by default. (CVS 2240) check-in: 2d3ab1ab user: drh tags: trunk
01:51
Expression generator bug fix. (CVS 2239) check-in: 39cf97a9 user: drh tags: trunk
01:17
Minor fix for sqlite3_clear_bindings(). (CVS 2238) check-in: ff5b338c user: danielk1977 tags: trunk
01:14
Add the experimental sqlite3_sleep() and sqlite3_clear_bindings() APIs. (CVS 2237) check-in: 9480209e user: danielk1977 tags: trunk
2005-01-19
23:24
Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) check-in: d8b2a7e0 user: drh tags: trunk
03:52
Another fix along the same lines as (2234) (CVS 2235) check-in: 27cf8322 user: danielk1977 tags: trunk
03:47
A few test cases were failing on windows due to mandatory locking. Omit them on that platform. (CVS 2234) check-in: 441316f1 user: danielk1977 tags: trunk
2005-01-18
17:40
Make sure USING and NATURAL work on joins even if the columns are renamed using an AS phrase. Ticket #523. (CVS 2233) check-in: c06add57 user: drh tags: trunk
17:20
CREATE TABLE ... AS ... uses short names for columns. Ticket #1036. (CVS 2232) check-in: b1d4c42d user: drh tags: trunk
16:02
Column names coming back from a SELECT are now just the name of the source column without the "table." prefix. In other words, "PRAGMA short_column_names=ON" is now the default. This makes the names of columns behave more like other SQL engines. The old behavior can be restored by setting "PRAGMA short_column_names=OFF". (CVS 2231) check-in: 9295050a user: drh tags: trunk
14:45
Continue refactoring name resolution. Fix for ticket #1047. (CVS 2230) check-in: 88d4834f user: drh tags: trunk
04:00
Refinements to the name resolution logic. Change the name of the keywordhash.c file to keywordhash.h. (CVS 2229) check-in: 0142ae6f user: drh tags: trunk
2005-01-17
22:08
Infrastructure changes to handle name resolution differently. This is needed to fix various long-standing problems with column names in joins. It will also make the implementation of correlated subqueries easier. (CVS 2228) check-in: 4a753439 user: drh tags: trunk
08:57
Fix a bug reported on the mailing list concerning a conflict between "INSERT INTO ... SELECT" statements and the "SELECT max(x) FROM tbl" optimization. (CVS 2227) check-in: 5a9da62a user: danielk1977 tags: trunk
07:53
Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226) check-in: 62442529 user: danielk1977 tags: trunk
03:42
Add incomplete, preliminary drafts of new documentation. (CVS 2225) check-in: a01159e8 user: drh tags: trunk
03:40
Fix a memory leak that occurs as a result of an IO error. (CVS 2224) check-in: 1edfdcbf user: danielk1977 tags: trunk
02:12
Change some assert()s that could fail if the database is corrupt to return SQLITE_CORRUPT instead. (CVS 2223) check-in: 2d58c0af user: danielk1977 tags: trunk
01:33
Have sqlite3pager_get() return SQLITE_CORRUPT for a page number greater than 2^31. (CVS 2222) check-in: feb49d10 user: danielk1977 tags: trunk
2005-01-16
23:21
Turn on quick-balance by default. (CVS 2221) check-in: d0356dee user: drh tags: trunk
20:47
Drop support for MAC OS9. SQLite 3 has never worked for that OS because the developers do not have access to a machine running it and nobody from the community has stepped forward to provide a port. By moving the os_mac.c file into the attic, we make the lack of support official. (CVS 2220) check-in: de9ad673 user: drh tags: trunk
11:07
Changes to make sure tests work when SQLITE_DEFAULT_AUTOVACUUM is defined. (CVS 2219) check-in: 6237c294 user: danielk1977 tags: trunk
09:06
Fixes so that compiling and testing works when SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2218) check-in: fe548561 user: danielk1977 tags: trunk
08:00
Move duplicate code to update pointer-map wrt overflow pages into a function. (CVS 2217) check-in: a5c21214 user: danielk1977 tags: trunk
2005-01-15
12:45
Enhance the performance of auto-vacuum databases by reducing the number of pointer-map entries written during tree balancing. Also fix bugs in balance_quick(). (CVS 2216) check-in: 0ae29538 user: danielk1977 tags: trunk
01:52
Test coverage improvements. (CVS 2215) check-in: 92f9d2b2 user: drh tags: trunk
00:40
Improved test coverage for update.c. (CVS 2214) check-in: 3ef95d5f user: drh tags: trunk
00:36
Improved coverage for insert.c. (CVS 2213) check-in: 997d8aff user: drh tags: trunk
2005-01-14
22:55
Add comments to the new balance_quick() routine. (CVS 2212) check-in: 183c42ea user: drh tags: trunk
13:50
Experimental patch to balance() (use -DSQLITE_BALANCE_QUICK). (CVS 2211) check-in: c550d80c user: danielk1977 tags: trunk
01:22
Improved test coverage on insert.c. (CVS 2210) check-in: c772f751 user: drh tags: trunk
2005-01-13
23:54
Need SQLITE_MEMDEBUG instead of SQLITE_DEBUG in tclsqlite.c. (CVS 2209) check-in: 6e905270 user: drh tags: trunk
23:54
Fix a bug in lemon that does not effect SQLite. Ticket #1068. (CVS 2208) check-in: 7113b5ed user: drh tags: trunk
13:35
Tidy up malloc.test a bit. (CVS 2207) check-in: 94cf91cc user: danielk1977 tags: trunk
11:10
Fix typo in shell .help. Ticket #1071. (CVS 2206) check-in: 2c7a1a16 user: danielk1977 tags: trunk
11:07
Test cases to improve coverage of pager.c. (CVS 2205) check-in: 0428a148 user: danielk1977 tags: trunk
02:14
Fixes to 'configure' build system. Also extra coverage for main.c. (CVS 2204) check-in: 8378455f user: danielk1977 tags: trunk
2005-01-12
13:04
Fix a test bug introduce with the previous commit. (CVS 2203) check-in: 1c19e8bd user: danielk1977 tags: trunk
12:44
Tests to improve coverage of main.c. (CVS 2202) check-in: 4e28c82a user: danielk1977 tags: trunk
09:10
Tests to improve coverage of vdbeaux.c. (CVS 2201) check-in: 2b3e21ce user: danielk1977 tags: trunk
07:15
Tests to improve coverage of vdbemem.c. (CVS 2200) check-in: 319bb4a9 user: danielk1977 tags: trunk
00:08
Fix a bug in tclsqlite.c. (CVS 2199) check-in: 50f1e229 user: drh tags: trunk
2005-01-11
18:13
Fix for ticket #1062: Correctly handle redundant terms in a WHERE clause. (CVS 2198) check-in: 1bee1bb9 user: drh tags: trunk
17:59
Allow '$' in the middle of identifiers. Ticket #1066. This is an experimental change. It might be backed out at a later date. (CVS 2197) check-in: 00a352ea user: drh tags: trunk
17:46
Test coverage improvements on tokenize.c. (CVS 2196) check-in: 5767850c user: drh tags: trunk
16:54
Improved test coverage for vdbeaux.c. (CVS 2195) check-in: 3f46cd77 user: drh tags: trunk
15:28
Improved test coverage for util.c. (CVS 2194) check-in: ad451a2d user: drh tags: trunk
13:02
Test cases to improve coverage of vdbe.c. (CVS 2193) check-in: a6b45722 user: danielk1977 tags: trunk
11:08
Remove a C++ style comment that went in with the previous commit. (CVS 2192) check-in: ce8e4e88 user: danielk1977 tags: trunk
10:25
Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2191) check-in: a37e0108 user: danielk1977 tags: trunk
10:25
Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) check-in: 8ced4915 user: danielk1977 tags: trunk
2005-01-10
12:59
Extra test cases to improve coverage of btree.c (CVS 2189) check-in: a4619886 user: danielk1977 tags: trunk
06:39
Update some documentation for version 3.1. (CVS 2188) check-in: 5b7a5a4d user: danielk1977 tags: trunk
02:48
Fix an assertion failure due to interaction between the count_changes pragma and triggers. (CVS 2187) check-in: 6c7bec1b user: danielk1977 tags: trunk
2005-01-08
18:42
Tcl interface does as sqlite3 or as sqlite. A compile-time option allows duel linking. Also fix a bug in the pragma change from earlier today. (CVS 2186) check-in: ad109537 user: drh tags: trunk
15:44
Fixes to the temp_store_directory pragma. (CVS 2185) check-in: 0a90eaf3 user: drh tags: trunk
15:43
Fix a comment. (CVS 2184) check-in: 26fbac8f user: drh tags: trunk
12:42
Fix a problem with auto-vacuum databases and the VACUUM command. Also add "pages read" and "pages written" statistics to the pager layer. (CVS 2183) check-in: fb3bf68d user: danielk1977 tags: trunk
02:35
Minor test script changes to allow all.test to run when SQLITE_DEFAULT_AUTOVACUUM=1 is defined. (CVS 2182) check-in: 5023b1db user: danielk1977 tags: trunk
2005-01-07
10:42
Reset the temp_store_directory each iteration of tests in all.test. (CVS 2181) check-in: 7373a5d4 user: danielk1977 tags: trunk
08:56
Fix a read of invalid memory that could occur in btree.c. (CVS 2180) check-in: 929745c1 user: danielk1977 tags: trunk
01:56
Remove incorrect assert() and add extra option to account for non-standard 'sort' program in some linux versions. (CVS 2179) check-in: bf143876 user: danielk1977 tags: trunk
2005-01-03
21:28
add --enable-debug to configure options, controls -DNDEBUG flag (CVS 2178) check-in: 9d674d1d user: tpoindex tags: trunk
18:13
add comment that table is accessed by primary key (CVS 2177) check-in: 707690c5 user: tpoindex tags: trunk
02:26
Allow GROUP BY on aggregate queries only. Ticket #1039. (CVS 2176) check-in: 8ef2c644 user: drh tags: trunk
01:33
Fix typos in comments in test code. (Oops. This check-in also picked up some unrelated changes to documentation.) (CVS 2175) check-in: 586acc85 user: drh tags: trunk
01:28
Fix a typo in a comment. No code changes. Ticket #1052. (CVS 2174) check-in: 9fb1402f user: drh tags: trunk
01:27
Fix comment typos. no code changes. (CVS 2173) check-in: 4165217e user: drh tags: trunk
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