SQLite

Timeline
Login

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

100 check-ins occurring around dbcfe198fbaa1558.

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)
2001-12-22
22:00
Version 2.2.0 (CVS 453) (check-in: 6bb62d8f user: drh tags: trunk)
21:48
Bug fix in the out-of-order INSERT. (CVS 336) (check-in: a26d0880 user: drh tags: trunk)
19:27
Update documentation for the 2.2.0 release. (CVS 335) (check-in: 14392258 user: drh tags: trunk)
14:49
Bug fixing in the new integer primary key code. (CVS 334) (check-in: 29cab124 user: drh tags: trunk)
2001-12-21
14:30
Added support for the INTEGER PRIMARY KEY column type. (CVS 333) (check-in: 236a54d2 user: drh tags: trunk)
2001-12-16
20:05
Added the ability to say things like "SELECT rowid, * FROM table1;" (CVS 332) (check-in: ffbdd43f user: drh tags: trunk)
2001-12-15
14:22
Comment and documentation changes. (CVS 331) (check-in: e8595579 user: drh tags: trunk)
03:05
Version 2.1.7 (CVS 454) (check-in: 0d444653 user: drh tags: trunk)
03:00
Typo in change log fixed. (CVS 330) (check-in: 3a31daf6 user: drh tags: trunk)
02:58
Release 2.1.7 (CVS 329) (check-in: 71cb9e8a user: drh tags: trunk)
02:47
Fix a bug in the sqliteBtreeFirst() function which was causing the first row of a table to be repeated during a scan. (CVS 328) (check-in: 1404ac07 user: drh tags: trunk)
02:35
Fix a critical bug in the creation of temporary tables. (CVS 327) (check-in: 96f70741 user: drh tags: trunk)
2001-12-14
15:15
Version 2.1.6 (CVS 455) (check-in: 6ecd90b6 user: drh tags: trunk)
15:09
Fix a race condition in the locking code that would sometimes cause SQLITE_PROTOCOL or SQLITE_CORRUPT to be returned when SQLITE_BUSY should have been returned. (CVS 326) (check-in: b0d21887 user: drh tags: trunk)
2001-12-06
13:30
Version 2.1.5 (CVS 456) (check-in: 8e90ad55 user: drh tags: trunk)
13:24
Bug fix in the sqliteOsLock() and sqliteOsUnlock() routines of POSIX. Version 2.1.5. (CVS 325) (check-in: 66945406 user: drh tags: trunk)
2001-12-05
01:00
Version 2.1.4 (CVS 457) (check-in: 121c522e user: drh tags: trunk)
00:46
Minor changes prior to 2.1.4 (CVS 324) (check-in: 2fb22adb user: drh tags: trunk)
00:22
Version 2.1.4 (CVS 323) (check-in: 003f967e user: drh tags: trunk)
00:21
Bug fix: sqlite_exec() would sometimes return SQLITE_PROTOCOL when it should have returned SQLITE_BUSY. There was also a deadlock that the previous bug was masking. (CVS 322) (check-in: 585ed5eb user: drh tags: trunk)
2001-11-25
13:18
Add the ability to do a single .command as the second argument to the command-line shell. (CVS 321) (check-in: 653f37c3 user: drh tags: trunk)
2001-11-24
13:50
Fix typos. (CVS 320) (check-in: 3be8a189 user: drh tags: trunk)
13:36
Typos fixed. (CVS 319) (check-in: e86a68c5 user: drh tags: trunk)
13:23
Update the FAQ. Change the GMT timezone label to UTC on all files. (CVS 318) (check-in: f1a58082 user: drh tags: trunk)
00:45
Version 2.1.3 (CVS 458) (check-in: 974d4283 user: drh tags: trunk)
00:31
Fix comparison functions so that they are consistent with the order of elements in indices. Fix the handling of large integers. (CVS 317) (check-in: fc2aae04 user: drh tags: trunk)
2001-11-23
00:30
Version 2.1.2 (CVS 459) (check-in: f14835df user: drh tags: trunk)