SQLite

Timeline
Login

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

49 check-ins occurring around 4c7dfd9353.

2002-02-23
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: 8da0ac9a8b 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: 39fed2df11 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: 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)