Subject: CVS commit: pkgsrc/databases/sqlite
To: None <pkgsrc-changes@netbsd.org>
From: Ty Sarna <tsarna@netbsd.org>
List: pkgsrc-changes
Date: 06/25/2003 19:24:22
Module Name: pkgsrc
Committed By: tsarna
Date: Wed Jun 25 19:24:22 UTC 2003
Modified Files:
pkgsrc/databases/sqlite: Makefile distinfo
Removed Files:
pkgsrc/databases/sqlite/patches: patch-aa
Log Message:
Update sqlite to 2.8.3. Major relevant changes:
2003 June 4 (2.8.3)
- Fix a problem that will corrupt the indices on a table if you
do an INSERT OR REPLACE or an UPDATE OR REPLACE on a table that
contains an INTEGER PRIMARY KEY plus one or more indices.
- Add the ability for INSERT and UPDATE statements to refer to
the "rowid" (or "_rowid_" or "oid") columns.
- Other important bug fixes
2003 May 17 (2.8.2)
- Fix a problem that will corrupt the database file if you drop a
table from the main database that has a TEMP index.
2003 May 16 (2.8.1)
- Reactivated the VACUUM command that reclaims unused disk space
in a database file.
- Added the ATTACH and DETACH commands to allow interacting with
multiple database files at the same time.
- Added support for TEMP triggers and indices.
- Added support for in-memory databases.
- Removed the experimental sqlite_open_aux_file(). Its function
is subsumed in the new ATTACH command.
- The precedence order for ON CONFLICT clauses was changed so
that ON CONFLICT clauses on BEGIN statements have a higher
precedence than ON CONFLICT clauses on constraints.
- Many, many bug fixes and compatibility enhancements.
To generate a diff of this commit:
cvs rdiff -r1.15 -r1.16 pkgsrc/databases/sqlite/Makefile
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/sqlite/distinfo
cvs rdiff -r1.2 -r0 pkgsrc/databases/sqlite/patches/patch-aa
Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.