SQLite

Timeline
Login

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

100 check-ins occurring around a9db1c12c5a4d574.

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)
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: 8a984667 user: drh tags: trunk)
2001-11-22
00:01
Fix a bug in the locking protocol. (CVS 315) (check-in: a9db1c12 user: drh tags: trunk)
2001-11-21
02:21
Attempting to add support for 64-bit platforms. (CVS 314) (check-in: 03673adb user: drh tags: trunk)
2001-11-13
19:45
Version 2.1.1 (CVS 460) (check-in: be228cd1 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: 207a57ad 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: 94ce8282 user: drh tags: trunk)
2001-11-12
14:00
Version 2.1.0 (CVS 461) (check-in: 56d8390e user: drh tags: trunk)
13:51
Update change log prior to release of 2.1.0. (CVS 311) (check-in: 6b3ccb37 user: drh tags: trunk)
13:10
Fix to the SUBSTR() function and to the bigrow test. (CVS 310) (check-in: 8437076c user: drh tags: trunk)
12:43
Version 2.1.0 prerelease (CVS 309) (check-in: 4f4ac422 user: drh tags: trunk)
2001-11-10
13:51
Comment changes (CVS 308) (check-in: 2d2ad264 user: drh tags: trunk)
2001-11-09
22:41
Minor bugs fixed. (CVS 307) (check-in: 6e7e7dbf user: drh tags: trunk)
13:41
Bug fixes. (CVS 306) (check-in: 84997fda user: drh tags: trunk)
2001-11-08
00:45
The new code for taking advantage of inequalities in WHERE clauses is in place. It appears to work. (CVS 305) (check-in: 262bcd17 user: drh tags: trunk)
2001-11-07
16:48
New Next opcode and indexing style implemented. (CVS 304) (check-in: decbeb91 user: drh tags: trunk)
14:22
Incremental update. We are in the middle of modifying the index system to support range queries without doing a complete table scan. (CVS 303) (check-in: e6ca23fa user: drh tags: trunk)
2001-11-06
14:10
Added support for LIMIT. (CVS 302) (check-in: 17701224 user: drh tags: trunk)
04:00
Implement indices that occur in sort order and the LIMIT...OFFSET clause of SELECT statements. (CVS 301) (check-in: eb07768a user: drh tags: trunk)
2001-11-04
18:32
Increase maximum row size to 1MB. (CVS 300) (check-in: 7dd58fad user: drh tags: trunk)
00:00
Version 2.0.8 (CVS 462) (check-in: 0fd28742 user: drh tags: trunk)
2001-11-03
23:59
Version 2.0.8 (CVS 299) (check-in: 0a8c2f4f user: drh tags: trunk)
23:57
Added "const" to lots of "char*" parameters in the API. (CVS 298) (check-in: 1c448f1f user: drh tags: trunk)
2001-11-01
14:41
Remove cruft: restrict the number of sorters and lists in the VDBE to one since no more than one was ever used anyway. This eliminates several op-codes and simplifies the implementation of several others. (CVS 297) (check-in: e1370276 user: drh tags: trunk)
13:52
Comment changes only. (CVS 296) (check-in: b2cb118f user: drh tags: trunk)
2001-10-31
15:44
More documentation updates (CVS 295) (check-in: f65df59e user: drh tags: trunk)
2001-10-25
20:37
Make lemon 64-bit clean (CVS 294) (check-in: 475e2fed user: drh tags: trunk)
2001-10-22
03:00
Version 2.0.7 (CVS 463) (check-in: b0442cb9 user: drh tags: trunk)
02:58
More changes for 2.0.7. (CVS 293) (check-in: f8328a5f user: drh tags: trunk)
2001-10-20
12:30
2.0.7 (CVS 292) (check-in: a835658e user: drh tags: trunk)
2001-10-19
16:45
Version 2.0.6 (CVS 464) (check-in: c8535a0d user: drh tags: trunk)
16:44
Version 2.0.6 (CVS 291) (check-in: 8467d84f user: drh tags: trunk)
2001-10-18
12:34
Support for UTF-8 and ISO8859 characters in identifiers. Bug fix in the column name generator for selects (was coreing). (CVS 290) (check-in: 22948fc6 user: drh tags: trunk)
2001-10-15
00:45
Version 2.0.5 (CVS 465) (check-in: e2d84f71 user: drh tags: trunk)
00:44
Added support for the COUNT_CHANGES pragma in order to help out the ODBC driver. Fixed a but on count(*) when applied to empty tables. (CVS 289) (check-in: 747bf1b3 user: drh tags: trunk)
2001-10-13
22:00
Version 2.0.4 (CVS 466) (check-in: 44444700 user: drh tags: trunk)
21:56
Bug fix. Raised version number to 2.0.4. (CVS 288) (check-in: 26972afd user: drh tags: trunk)
03:00
Version 2.0.3 (CVS 467) (check-in: a8fee23f user: drh tags: trunk)
02:59
2.0.3 (CVS 287) (check-in: 75e90cf0 user: drh tags: trunk)
01:06
Remove the P3 and label arguments from the internal sqliteVdbeAddOp() function. This makes the code easier to read and perhaps smaller as well. (CVS 286) (check-in: 288ef124 user: drh tags: trunk)
2001-10-12
17:30
Fix an assertion failure when the disk fills up. Add tests for a full disk situation. (CVS 285) (check-in: 0a7848b6 user: drh tags: trunk)
2001-10-09
14:00
Version 2.0.2 (CVS 468) (check-in: 44d00a6f user: drh tags: trunk)
13:46
The sqlite_busy_timeout() function was interpreting its second argument as seconds, not milliseconds as advertised. This patch fixes the problem. (CVS 284) (check-in: abe5a25b user: drh tags: trunk)
12:44
Remove files before rebuilding. (CVS 283) (check-in: 6307641d user: drh tags: trunk)
12:39
More changes prior to release 2.0.2. Mostly comment changes. But there was also a minor change to temptable.test so that it would work under Windows. (CVS 282) (check-in: 864349de user: drh tags: trunk)
04:21
Version 2.0.2 (CVS 281) (check-in: 765359c7 user: drh tags: trunk)
04:19
Fix the locking protocol. (CVS 280) (check-in: 484b82d8 user: drh tags: trunk)
2001-10-08
13:22
Support for temporary tables added. Still need more testing. (CVS 279) (check-in: 9368c62e user: drh tags: trunk)
2001-10-06
16:33
Adding table column query capability to support ODBC. (CVS 278) (check-in: b63b3f36 user: drh tags: trunk)
2001-10-02
13:05
Version 2.0.1 (CVS 469) (check-in: e4980849 user: drh tags: trunk)
13:01
Remove C++ comments from btree.c. (CVS 277) (check-in: 4b7710e2 user: drh tags: trunk)
2001-10-01
14:29
The .dump output uses INSERT instead of COPY now. Expression syntax of the form "expr NOT NULL" is now supported. (CVS 276) (check-in: 20382325 user: drh tags: trunk)