SQLite

Timeline
Login

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

100 check-ins occurring around 61c38f3bfe.

2002-02-21
12:01
Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) (check-in: b2a9807fed 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: ffb00bf36a user: drh tags: trunk)
2002-02-19
22:43
Fix a comment. (CVS 384) (check-in: 953928537c user: drh tags: trunk)
22:42
New ROWIDs are numbered sequentially. (CVS 383) (check-in: 1686196a8a user: drh tags: trunk)
15:00
Optimize simple min() and max() queries. (CVS 382) (check-in: cc5abfe392 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: c6e9048e66 user: drh tags: trunk)
00:30
Version 2.3.3 (CVS 444) (check-in: 72c5a92aa6 user: drh tags: trunk)
00:15
Final changes before 2.3.3 (CVS 380) (check-in: a53de7625a user: drh tags: trunk)
2002-02-18
22:50
Added a C wrapper program to test threading under Unix. (CVS 379) (check-in: 8d5634a447 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: 553579f936 user: drh tags: trunk)
18:30
Add support for CREATE TABLE AS. (CVS 377) (check-in: 78a50971e9 user: drh tags: trunk)
13:56
Allow general expressions in the VALUES clause of an INSERT statement. (CVS 376) (check-in: ec1f3fae6f user: drh tags: trunk)
13:35
Additional tests for the sub-query feature. (CVS 375) (check-in: a0019fce70 user: drh tags: trunk)
12:48
Enhancement to Windows "file-exists" function by Joel Lucsy. (CVS 374) (check-in: d3d59261da user: drh tags: trunk)
03:21
Test and documentation updates for sub-queries. (CVS 373) (check-in: 607c0c49b2 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: 89ffa9ff13 user: drh tags: trunk)
2002-02-17
00:30
Make the sqliteParseInfoReset() function locale to the select.c file. (CVS 371) (check-in: 2336b1eada 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: e17a858c9e user: drh tags: trunk)
13:00
Version 2.3.2 (CVS 446) (check-in: 4d06700007 user: drh tags: trunk)
12:50
Fix an incorrect assert() in pager.c. (CVS 369) (check-in: 08a68e098a user: drh tags: trunk)
2002-02-13
23:30
Version 2.3.1 (CVS 445) (check-in: 846148d6e3 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: df6bf627a5 user: drh tags: trunk)
2002-02-03
19:30
Version 2.3.0 (CVS 447) (check-in: 4c7dfd9353 user: drh tags: trunk)
19:15
Reenable testing code even if NDEBUG is defined. (CVS 367) (check-in: 0090c279d8 user: drh tags: trunk)
19:06
Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: 20ea737536 user: drh tags: trunk)
17:37
Put in PRAGMA SANITY_CHECK in place of VACUUM. (CVS 365) (check-in: 7c65029e5b user: drh tags: trunk)
03:34
The VACUUM command now does a database sanity check. (CVS 364) (check-in: 95d1f8389d user: drh tags: trunk)
00:56
Five-algorithm conflict resolution appears to be working. (CVS 363) (check-in: 0115518f8e user: drh tags: trunk)
2002-02-02
18:49
Get the ABORT conflict resolution algorithm working. (CVS 362) (check-in: 9be4d4c6f1 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: aaa53e113e 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: d0e7cf4a83 user: drh tags: trunk)
2002-01-30
16:17
Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) (check-in: cf1538d71c user: drh tags: trunk)
04:32
Better testing of the ON CONFLICT logic. (CVS 358) (check-in: 9bbddb8e01 user: drh tags: trunk)
00:54
More bug fixes in the ON CONFLICT enhancement. (CVS 357) (check-in: 8229b5f6a3 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: ac8a4189e2 user: drh tags: trunk)
18:41
Beginning to insert the infrastructure for ON CONFLICT clauses. (CVS 355) (check-in: e00a9ff8f9 user: drh tags: trunk)
2002-01-28
16:00
Version 2.2.5 (CVS 448) (check-in: af3bb80810 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: dbcfe198fb user: drh tags: trunk)
2002-01-24
00:00
Do not escape the backslash character in shell output. (CVS 353) (check-in: 5f8c097ebe user: drh tags: trunk)
2002-01-22
14:15
Version 2.2.4 (CVS 449) (check-in: 16712dae4f user: drh tags: trunk)
14:11
Constant ORDER BY or GROUP BY expressions are an error. (CVS 352) (check-in: 035984a5b0 user: drh tags: trunk)
12:39
Fix a bug in the -separator command-line option. (CVS 351) (check-in: 593c986f69 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: 3684beab0f user: drh tags: trunk)
2002-01-16
21:05
Version 2.2.3 (CVS 450) (check-in: a4fe893ce7 user: drh tags: trunk)
21:00
Added the last_insert_rowid API function. Improved documentation of the random ROWID algorithm. (CVS 349) (check-in: f74d61aaf3 user: drh tags: trunk)
2002-01-15
18:39
Added implementations for sqliteOsEnterMutex() and sqliteOsLeaveMutex(). (CVS 348) (check-in: f8a026a3ca user: drh tags: trunk)
2002-01-14
09:28
Fix warning messages in VC++. Patches from nicolas352001. (CVS 347) (check-in: f3038d218c user: drh tags: trunk)
03:00
Version 2.2.2 (CVS 451) (check-in: 7da00a33fe 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: 96cd07a881 user: drh tags: trunk)
2002-01-10
14:31
Fix a problem with the way temporary tables mask permanent tables. (CVS 345) (check-in: ba89da6031 user: drh tags: trunk)
2002-01-09
13:45
Version 2.2.1 (CVS 452) (check-in: 61c38f3bfe user: drh tags: trunk)
13:35
Homepage changes prior to version 2.2.1. (CVS 344) (check-in: e78b1ea23c user: drh tags: trunk)
13:30
Continued work on the DROP/CREATE problem. (CVS 343) (check-in: 0a3aa99e11 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: b3656a5cfe user: drh tags: trunk)
2002-01-07
19:58
Added a manpage from A. Rottmann. (CVS 341) (check-in: 7deb622413 user: drh tags: trunk)
19:04
Makefile changes from Andreas Rottmann (CVS 1725) (check-in: 7910bc7885 user: drh tags: trunk)
19:04
Makefile changes from Andreas Rottmann (CVS 340) (check-in: e7004afbf8 user: drh tags: trunk)
2002-01-06
17:07
Comment updates most. Also some small changes to the VDBE. (CVS 339) (check-in: 9b0be4fcc1 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: 011be9a9d2 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: 18e606f748 user: drh tags: trunk)
2001-12-22
22:00
Version 2.2.0 (CVS 453) (check-in: 6bb62d8fab user: drh tags: trunk)
21:48
Bug fix in the out-of-order INSERT. (CVS 336) (check-in: a26d0880b2 user: drh tags: trunk)
19:27
Update documentation for the 2.2.0 release. (CVS 335) (check-in: 14392258c5 user: drh tags: trunk)
14:49
Bug fixing in the new integer primary key code. (CVS 334) (check-in: 29cab124b4 user: drh tags: trunk)
2001-12-21
14:30
Added support for the INTEGER PRIMARY KEY column type. (CVS 333) (check-in: 236a54d289 user: drh tags: trunk)
2001-12-16
20:05
Added the ability to say things like "SELECT rowid, * FROM table1;" (CVS 332) (check-in: ffbdd43f5d user: drh tags: trunk)
2001-12-15
14:22
Comment and documentation changes. (CVS 331) (check-in: e8595579a5 user: drh tags: trunk)
03:05
Version 2.1.7 (CVS 454) (check-in: 0d44465347 user: drh tags: trunk)
03:00
Typo in change log fixed. (CVS 330) (check-in: 3a31daf646 user: drh tags: trunk)
02:58
Release 2.1.7 (CVS 329) (check-in: 71cb9e8ad7 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: 1404ac076b user: drh tags: trunk)
02:35
Fix a critical bug in the creation of temporary tables. (CVS 327) (check-in: 96f7074136 user: drh tags: trunk)
2001-12-14
15:15
Version 2.1.6 (CVS 455) (check-in: 6ecd90b6c3 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: b0d2188764 user: drh tags: trunk)
2001-12-06
13:30
Version 2.1.5 (CVS 456) (check-in: 8e90ad552f user: drh tags: trunk)
13:24
Bug fix in the sqliteOsLock() and sqliteOsUnlock() routines of POSIX. Version 2.1.5. (CVS 325) (check-in: 6694540608 user: drh tags: trunk)
2001-12-05
01:00
Version 2.1.4 (CVS 457) (check-in: 121c522e67 user: drh tags: trunk)
00:46
Minor changes prior to 2.1.4 (CVS 324) (check-in: 2fb22adbd1 user: drh tags: trunk)
00:22
Version 2.1.4 (CVS 323) (check-in: 003f967e87 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: 585ed5ebf1 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: 653f37c365 user: drh tags: trunk)
2001-11-24
13:50
Fix typos. (CVS 320) (check-in: 3be8a189e8 user: drh tags: trunk)
13:36
Typos fixed. (CVS 319) (check-in: e86a68c5ac user: drh tags: trunk)
13:23
Update the FAQ. Change the GMT timezone label to UTC on all files. (CVS 318) (check-in: f1a5808288 user: drh tags: trunk)
00:45
Version 2.1.3 (CVS 458) (check-in: 974d42839b 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: fc2aae0457 user: drh tags: trunk)
2001-11-23
00:30
Version 2.1.2 (CVS 459) (check-in: f14835df32 user: drh tags: trunk)
00:24
Fix a bug in DROP TABLE that could cause SQLITE_MASTER table corruption. The root problem was that the sequence of BTree operations (Delete, Next) would not always leave the cursor pointing at the first entry after the entry that was deleted. A consequence of this error was that a DROP TABLE on a table with indices would not always remove every index associated with that table from the SQLITE_MASTER table. Subsequent attempts to open the database will fail when the index for the missing table was parsed. Changes have also been made to ignore extra indices in the SQLITE_MASTER table so that a database previously corrupted by this bug is once again readable. (CVS 316) (check-in: 8a98466711 user: drh tags: trunk)
2001-11-22
00:01
Fix a bug in the locking protocol. (CVS 315) (check-in: a9db1c12c5 user: drh tags: trunk)
2001-11-21
02:21
Attempting to add support for 64-bit platforms. (CVS 314) (check-in: 03673adbfe user: drh tags: trunk)
2001-11-13
19:45
Version 2.1.1 (CVS 460) (check-in: be228cd13a user: drh tags: trunk)
19:36
Bug fix: Be sure to sends NULLs to the callback when the column value is NULL. (CVS 313) (check-in: 207a57ad2e user: drh tags: trunk)
19:35
Bug fix: Sometimes NULL results were not being passed as nulls to the callback function. (CVS 312) (check-in: 94ce828236 user: drh tags: trunk)
2001-11-12
14:00
Version 2.1.0 (CVS 461) (check-in: 56d8390e47 user: drh tags: trunk)
13:51
Update change log prior to release of 2.1.0. (CVS 311) (check-in: 6b3ccb37bf user: drh tags: trunk)
13:10
Fix to the SUBSTR() function and to the bigrow test. (CVS 310) (check-in: 8437076c25 user: drh tags: trunk)
12:43
Version 2.1.0 prerelease (CVS 309) (check-in: 4f4ac42214 user: drh tags: trunk)
2001-11-10
13:51
Comment changes (CVS 308) (check-in: 2d2ad264aa user: drh tags: trunk)
2001-11-09
22:41
Minor bugs fixed. (CVS 307) (check-in: 6e7e7dbf8e user: drh tags: trunk)
13:41
Bug fixes. (CVS 306) (check-in: 84997fda33 user: drh tags: trunk)