SQLite

Timeline
Login

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

100 check-ins occurring around 553579f936b3a447.

2002-03-11
02:06
Preparing for the 2.4.0 release. (CVS 426) (check-in: 9f5b241c 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: 02cc2d60 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: 145516c9 user: drh tags: trunk)
2002-03-07
02:02
Fix a bug in the sorting of compound selects. (CVS 423) (check-in: 0a513235 user: drh tags: trunk)
2002-03-06
22:04
Beta 2 (CVS 422) (check-in: 6c3fb547 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: 161c0c5f user: drh tags: trunk)
03:08
Optimizations to the processing of integer comparisons. (CVS 420) (check-in: b7a7dae9 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: 480eef1a 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: 414da4af 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: 36a8fe0a user: drh tags: trunk)
2002-03-03
23:06
More bugs fixed for views. (CVS 416) (check-in: 81307762 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: 6121e5ab user: drh tags: trunk)
03:42
Fix a memory leak in expression processing. (CVS 414) (check-in: dfe431c9 user: drh tags: trunk)
03:11
Additional tests of flattening (CVS 413) (check-in: e1d93c59 user: drh tags: trunk)
03:03
Suppress superfluous OP_OpenTemps when flattening subqueries. (CVS 412) (check-in: 000441c8 user: drh tags: trunk)
02:49
Bug fixes and additional tests for the subquery flattener. (CVS 411) (check-in: 2c05389e 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: cf1ebcfb 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: abbb999d 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: d5d3e79c user: drh tags: trunk)
2002-02-28
04:10
Bug fix when -DMEMORY_DEBUG is off. (CVS 407) (check-in: e14b0c82 user: drh tags: trunk)
04:00
Fix bugs in substr() for UTF-8. (CVS 406) (check-in: e9fd9e7b user: drh tags: trunk)
03:31
Remove unused opcodes from the VDBE and fix a bug in the substr() function. (CVS 405) (check-in: e8611e0c user: drh tags: trunk)
03:14
Change the IFNULL and NVL functions to COALESCE. Change MIN and MAX so that they require at least one argument. (CVS 404) (check-in: 7d86749d user: drh tags: trunk)
03:04
The new function code passes regression tests. (CVS 403) (check-in: b00cf110 user: drh tags: trunk)
01:46
Fix the coredump. There are still problems in the test suite though. (CVS 402) (check-in: 6af10cc5 user: drh tags: trunk)
00:46
Added IFNULL and NVL functions. (CVS 401) (check-in: c6a85c8e user: drh tags: trunk)
00:41
Completely remove the old SQL function system and replace it with the new user functions. The code currently compiles but it coredumps on the test suite. Do not use in its present state. (CVS 400) (check-in: 50797fee user: drh tags: trunk)
2002-02-27
19:50
Try to reduce the number of malloc() for user-defined functions. Begin transfering built-in functions over to the user-define function mechanism. (CVS 399) (check-in: c4f9e017 user: drh tags: trunk)
19:00
Revise the API for user-defined functions. (CVS 398) (check-in: 633951f0 user: drh tags: trunk)
01:53
The user-defined function routines failed to detect a malloc() failure. (CVS 397) (check-in: 085b0d67 user: drh tags: trunk)
01:47
Bug fixes in the VIEW implementation. (CVS 396) (check-in: 668ef638 user: drh tags: trunk)
2002-02-26
23:55
Comment changes only. (CVS 395) (check-in: 63b87f2e user: drh tags: trunk)
23:24
Fix a bug in the quoting of .dump output. By Rajit Singh. (CVS 394) (check-in: f2310f36 user: drh tags: trunk)
2002-02-24
17:12
Added a "stddev()" aggregate function for testing the new user aggregate function interface. (CVS 393) (check-in: 21981097 user: drh tags: trunk)
03:25
Code for user-defined aggregates added. Legacy tests all pass but there has been no testing of the new user-defined aggregate code. (CVS 392) (check-in: 1e037eb3 user: drh tags: trunk)
01:55
Move the build-in function definitions into a new source file "func.c". (CVS 391) (check-in: 530b0f4f user: drh tags: trunk)
2002-02-23
23:45
Added support for user-defined normal functions. Support for user-defined aggregates is pending. (CVS 390) (check-in: c490a1ff user: drh tags: trunk)
19:39
Modify lemon to use much less memory for its parser tables. This reduces the size of the library by 50K, which is important for an embedded library. (CVS 389) (check-in: 67a135a0 user: drh tags: trunk)
18:45
Bug fix in lemon: 3-way conflicts (SHIFT/REDUCE/REDUCE) were not detected or resolved. This is now fixed. Also, table compression works a little better. (CVS 388) (check-in: 8da0ac9a user: drh tags: trunk)
02:32
Code to implement CREATE VIEW is in place. A quick smoke test shows that it works, but there are probably still many bugs. (CVS 387) (check-in: 39fed2df user: drh tags: trunk)
2002-02-21
12:01
Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) (check-in: b2a9807f user: drh tags: trunk)
02:25
Do not allow dot-commands to occur in the middle of a real SQL command. (CVS 385) (check-in: ffb00bf3 user: drh tags: trunk)
2002-02-19
22:43
Fix a comment. (CVS 384) (check-in: 95392853 user: drh tags: trunk)
22:42
New ROWIDs are numbered sequentially. (CVS 383) (check-in: 1686196a user: drh tags: trunk)
15:00
Optimize simple min() and max() queries. (CVS 382) (check-in: cc5abfe3 user: drh tags: trunk)
13:39
Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: c6e9048e user: drh tags: trunk)
00:30
Version 2.3.3 (CVS 444) (check-in: 72c5a92a user: drh tags: trunk)
00:15
Final changes before 2.3.3 (CVS 380) (check-in: a53de762 user: drh tags: trunk)
2002-02-18
22:50
Added a C wrapper program to test threading under Unix. (CVS 379) (check-in: 8d5634a4 user: drh tags: trunk)
22:49
Bug fix: CREATE TABLE, followed by DROP TABLE within the same transaction is working now. (CVS 378) (check-in: 553579f9 user: drh tags: trunk)
18:30
Add support for CREATE TABLE AS. (CVS 377) (check-in: 78a50971 user: drh tags: trunk)
13:56
Allow general expressions in the VALUES clause of an INSERT statement. (CVS 376) (check-in: ec1f3fae user: drh tags: trunk)
13:35
Additional tests for the sub-query feature. (CVS 375) (check-in: a0019fce user: drh tags: trunk)
12:48
Enhancement to Windows "file-exists" function by Joel Lucsy. (CVS 374) (check-in: d3d59261 user: drh tags: trunk)
03:21
Test and documentation updates for sub-queries. (CVS 373) (check-in: 607c0c49 user: drh tags: trunk)
01:17
Add support for subqueries in the FROM clause of a SELECT. Still need to add tests for this feature. (CVS 372) (check-in: 89ffa9ff user: drh tags: trunk)
2002-02-17
00:30
Make the sqliteParseInfoReset() function locale to the select.c file. (CVS 371) (check-in: 2336b1ea user: drh tags: trunk)
2002-02-14
21:42
All identifiers to be quoted in square brackets, for compatibility with MS-Access. (CVS 370) (check-in: e17a858c user: drh tags: trunk)
13:00
Version 2.3.2 (CVS 446) (check-in: 4d067000 user: drh tags: trunk)
12:50
Fix an incorrect assert() in pager.c. (CVS 369) (check-in: 08a68e09 user: drh tags: trunk)
2002-02-13
23:30
Version 2.3.1 (CVS 445) (check-in: 846148d6 user: drh tags: trunk)
23:22
Bug fix: if PRAGMA full_column_names=ON is set and you do a query like this: "SELECT rowid,* FROM ...", then an assertion failed. Bummer. (CVS 368) (check-in: df6bf627 user: drh tags: trunk)
2002-02-03
19:30
Version 2.3.0 (CVS 447) (check-in: 4c7dfd93 user: drh tags: trunk)
19:15
Reenable testing code even if NDEBUG is defined. (CVS 367) (check-in: 0090c279 user: drh tags: trunk)
19:06
Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: 20ea7375 user: drh tags: trunk)
17:37
Put in PRAGMA SANITY_CHECK in place of VACUUM. (CVS 365) (check-in: 7c65029e user: drh tags: trunk)
03:34
The VACUUM command now does a database sanity check. (CVS 364) (check-in: 95d1f838 user: drh tags: trunk)
00:56
Five-algorithm conflict resolution appears to be working. (CVS 363) (check-in: 0115518f user: drh tags: trunk)
2002-02-02
18:49
Get the ABORT conflict resolution algorithm working. (CVS 362) (check-in: 9be4d4c6 user: drh tags: trunk)
15:01
Checkpoint code added to the pager. Regression tests work but the new APIs have not been tested yet. (CVS 361) (check-in: aaa53e11 user: drh tags: trunk)
2002-01-31
15:54
Change to five conflict resolution algorithms: ROLLBACK, ABORT, FAIL, IGNORE, and REPLACE. This checkin is code only. Documentation and tests are still needed. Also, ABORT is not fully implemented. (CVS 360) (check-in: d0e7cf4a user: drh tags: trunk)
2002-01-30
16:17
Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) (check-in: cf1538d7 user: drh tags: trunk)
04:32
Better testing of the ON CONFLICT logic. (CVS 358) (check-in: 9bbddb8e user: drh tags: trunk)
00:54
More bug fixes in the ON CONFLICT enhancement. (CVS 357) (check-in: 8229b5f6 user: drh tags: trunk)
2002-01-29
23:07
The new ON CONFLICT logic is in and passes the legacy tests. But the new capabilities have not been tested and are likely broken. (CVS 356) (check-in: ac8a4189 user: drh tags: trunk)
18:41
Beginning to insert the infrastructure for ON CONFLICT clauses. (CVS 355) (check-in: e00a9ff8 user: drh tags: trunk)
2002-01-28
16:00
Version 2.2.5 (CVS 448) (check-in: af3bb808 user: drh tags: trunk)
15:53
Bug fix: The IN operator was not working if either side derived from an INTEGER PRIMARY KEY. (CVS 354) (check-in: dbcfe198 user: drh tags: trunk)
2002-01-24
00:00
Do not escape the backslash character in shell output. (CVS 353) (check-in: 5f8c097e user: drh tags: trunk)
2002-01-22
14:15
Version 2.2.4 (CVS 449) (check-in: 16712dae user: drh tags: trunk)
14:11
Constant ORDER BY or GROUP BY expressions are an error. (CVS 352) (check-in: 035984a5 user: drh tags: trunk)
12:39
Fix a bug in the -separator command-line option. (CVS 351) (check-in: 593c986f user: drh tags: trunk)
03:13
The right-hand side of an AS in a SELECT can be used within expressions of the WHERE, ORDER BY, GROUP BY, and/or HAVING clauses. (CVS 350) (check-in: 3684beab user: drh tags: trunk)
2002-01-16
21:05
Version 2.2.3 (CVS 450) (check-in: a4fe893c user: drh tags: trunk)
21:00
Added the last_insert_rowid API function. Improved documentation of the random ROWID algorithm. (CVS 349) (check-in: f74d61aa user: drh tags: trunk)
2002-01-15
18:39
Added implementations for sqliteOsEnterMutex() and sqliteOsLeaveMutex(). (CVS 348) (check-in: f8a026a3 user: drh tags: trunk)
2002-01-14
09:28
Fix warning messages in VC++. Patches from nicolas352001. (CVS 347) (check-in: f3038d21 user: drh tags: trunk)
03:00
Version 2.2.2 (CVS 451) (check-in: 7da00a33 user: drh tags: trunk)
02:56
Fix a bug that could cause UPDATE to fail for a table that contains both an INTEGER PRIMARY KEY and an index. (CVS 346) (check-in: 96cd07a8 user: drh tags: trunk)
2002-01-10
14:31
Fix a problem with the way temporary tables mask permanent tables. (CVS 345) (check-in: ba89da60 user: drh tags: trunk)
2002-01-09
13:45
Version 2.2.1 (CVS 452) (check-in: 61c38f3b user: drh tags: trunk)
13:35
Homepage changes prior to version 2.2.1. (CVS 344) (check-in: e78b1ea2 user: drh tags: trunk)
13:30
Continued work on the DROP/CREATE problem. (CVS 343) (check-in: 0a3aa99e user: drh tags: trunk)
03:19
Working on a bug: Dropping and recreating a table within a transaction causes an assertion failure. (CVS 342) (check-in: b3656a5c user: drh tags: trunk)
2002-01-07
19:58
Added a manpage from A. Rottmann. (CVS 341) (check-in: 7deb6224 user: drh tags: trunk)
19:04
Makefile changes from Andreas Rottmann (CVS 1725) (check-in: 7910bc78 user: drh tags: trunk)
19:04
Makefile changes from Andreas Rottmann (CVS 340) (check-in: e7004afb user: drh tags: trunk)
2002-01-06
17:07
Comment updates most. Also some small changes to the VDBE. (CVS 339) (check-in: 9b0be4fc user: drh tags: trunk)
2002-01-04
03:09
An attempt to delete a single row using a WHERE clause that specifies the rowid would result in an error if the rowid did not exist. This problem has been resolved. (CVS 338) (check-in: 011be9a9 user: drh tags: trunk)
2001-12-31
02:48
Comment changes. Change the use of BTree so that either the key is an integer or the data is empty. (CVS 337) (check-in: 18e606f7 user: drh tags: trunk)