SQLite

Timeline
Login

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

45 check-ins for the month beginning 2002-03-01

Following month ↑
2002-03-31
18:29
When an attempt is made to insert an explicit NULL into an INTEGER PRIMARY KEY column, automatically convert the NULL value into a unique integer key. This was already happening when an implied NULL was inserted - when the INTEGER PRIMARY KEY column was omitted from the list of columns being inserted. Patches from Christian Werner. (CVS 510) (check-in: 9e3cf4aa2c user: drh tags: trunk)
2002-03-30
15:32
Version 2.4.4 (CVS 509) (check-in: c4b6c0be00 user: drh tags: trunk)
15:27
Update the change log to include the previous commit. (CVS 508) (check-in: 81c4b74961 user: drh tags: trunk)
15:26
Fix for bug #3: Allow VIEW as a column name. Also allow COPY. (CVS 507) (check-in: d2bdc0feeb user: drh tags: trunk)
14:15
Describe the difference between the binary RPMs in the download.html file. (CVS 506) (check-in: 8ce9a1fad2 user: drh tags: trunk)
2002-03-29
18:16
Combine the homerpm.sh file in with publish.sh. Update the website files to refer to the new RPMs that are now being built. Fix a small problem with the spec file. (CVS 505) (check-in: 57d4c77047 user: drh tags: trunk)
01:29
added a section to create a spec file and build the rpm files (CVS 504) (check-in: e529143967 user: doughenry tags: trunk)
01:28
these files are needed by publish.sh to build rpms (CVS 503) (check-in: 3c25359376 user: doughenry tags: trunk)
2002-03-28
14:20
Two typos fixed in the documentation (lang.html). (CVS 502) (check-in: f0f241e1cc user: drh tags: trunk)
2002-03-27
12:52
Update the documentation to refer the reader to the CVS server for the change log, bug lists, or the latest sources. (CVS 500) (check-in: 2478ba8666 user: drh tags: trunk)
2002-03-26
03:11
Update the change log. (CVS 438) (check-in: 9637b9aa5d user: drh tags: trunk)
2002-03-24
13:13
Added support for CASE expressions - patches from Dan Kennedy. (CVS 437) (check-in: 836b59d057 user: drh tags: trunk)
2002-03-23
01:00
Version 2.4.3 (CVS 440) (check-in: 99d6764e57 user: drh tags: trunk)
00:52
The sqlite_get_table() function now returns an error if you pass in two or more SELECT statements that return different numbers of columns. (CVS 436) (check-in: e2558c3403 user: drh tags: trunk)
00:31
Fix a bug in subquery generation when the subquery is a compound select. Also added new tests to cover this case. (CVS 435) (check-in: aaf7fd4cef user: drh tags: trunk)
2002-03-20
01:05
Version 2.4.2 (CVS 441) (check-in: 49d0323255 user: drh tags: trunk)
00:00
One more change before 2.4.2: Make the os.h header file more robust in detecting whether to use unix or windows. (CVS 434) (check-in: c2e0b79057 user: drh tags: trunk)
2002-03-19
23:51
Version 2.4.2 (CVS 433) (check-in: b0805b6069 user: drh tags: trunk)
2002-03-18
13:03
Fix an uninitialized variable in AggReset() (CVS 432) (check-in: 3dcdeae7f6 user: drh tags: trunk)
2002-03-14
14:33
Bug fix: allow ROWID as a column in SELECT statements where the FROM clause includes views which are flattened. (CVS 431) (check-in: a3a360b308 user: drh tags: trunk)
2002-03-13
19:00
Version 2.4.1 (CVS 442) (check-in: 9f12b8805f user: drh tags: trunk)
18:54
Version 2.4.1 (CVS 430) (check-in: 9333ecca1e user: drh tags: trunk)
18:54
Fix bug in anonymous subquery in a join. Parser requires a semicolon or end-of-input before executing. (CVS 429) (check-in: c0e3f1c592 user: drh tags: trunk)
2002-03-12
23:10
Fix the return type of the xStep function in the FuncDef structure definition. (CVS 428) (check-in: 753adb789e user: drh tags: trunk)
2002-03-11
13:55
Change the way that lemon handles %extra_argument. (CVS 427) (check-in: ffc387a48a user: drh tags: trunk)
02:15
Version 2.4.0 (CVS 443) (check-in: d3f66b44e5 user: drh tags: trunk)
02:06
Preparing for the 2.4.0 release. (CVS 426) (check-in: 9f5b241cb2 user: drh tags: trunk)
2002-03-10
21:21
Bug fix: updates within a transaction would fail if there was existed a temporary table. (CVS 425) (check-in: 02cc2d60b2 user: drh tags: trunk)
2002-03-08
02:12
Added prototypes to sqlite.h for sqlite_freemem(), sqlite_libversion() and sqlite_libencoding(). (CVS 424) (check-in: 145516c93b user: drh tags: trunk)
2002-03-07
02:02
Fix a bug in the sorting of compound selects. (CVS 423) (check-in: 0a51323561 user: drh tags: trunk)
2002-03-06
22:04
Beta 2 (CVS 422) (check-in: 6c3fb5470e user: drh tags: trunk)
22:01
Added the default_cache_size and default_synchronous pragmas. Added additional tests for pragmas. Added a new speedtest script. (CVS 421) (check-in: 161c0c5f5d user: drh tags: trunk)
03:08
Optimizations to the processing of integer comparisons. (CVS 420) (check-in: b7a7dae919 user: drh tags: trunk)
2002-03-05
12:41
Change the pager locking mechanism so that we don't have to write page 1 to the journal and to the database unless it actually changes. (CVS 419) (check-in: 480eef1a3a user: drh tags: trunk)
01:11
Add the ability to turn of calls to fsync() using the "synchronous" pragma. Increased the default cache size from 100 to 2000 and made the "cache_size" pragma persistent. (CVS 418) (check-in: 414da4af1f user: drh tags: trunk)
2002-03-04
02:26
Updates to the documentation. Changed version number to 2.4.0-beta1 (CVS 417) (check-in: 36a8fe0ad0 user: drh tags: trunk)
2002-03-03
23:06
More bugs fixed for views. (CVS 416) (check-in: 8130776230 user: drh tags: trunk)
18:59
VIEWs are bound to tables when they are used, not when they are first entered. This works around the problem of what to do if a table is deleted that a view refers to. (CVS 415) (check-in: 6121e5ab93 user: drh tags: trunk)
03:42
Fix a memory leak in expression processing. (CVS 414) (check-in: dfe431c9b7 user: drh tags: trunk)
03:11
Additional tests of flattening (CVS 413) (check-in: e1d93c5923 user: drh tags: trunk)
03:03
Suppress superfluous OP_OpenTemps when flattening subqueries. (CVS 412) (check-in: 000441c8fe user: drh tags: trunk)
02:49
Bug fixes and additional tests for the subquery flattener. (CVS 411) (check-in: 2c05389eda user: drh tags: trunk)
2002-03-02
20:41
Pager optimization: do not write or journal free pages. This results in a 2x performance gain for large INSERTs and a 5x performance gain for large DELETEs. (CVS 410) (check-in: cf1ebcfb74 user: drh tags: trunk)
19:00
Change the btree node balancers to sort nodes into accending order. This improves insert and delete speed by 25%. (CVS 409) (check-in: abbb999d4f user: drh tags: trunk)
17:04
Subquery flattening is implemented and passes all regression tests. We still need to add addition tests to the suite to further exercise the flattener, however. (CVS 408) (check-in: d5d3e79cc5 user: drh tags: trunk)
Previous month ↓