hsqldb 1.8.0 RC5

From: dedmike (dedmike_at_gmail.com)
Date: 01/25/05 

Date: 25 Jan 2005 02:42:01 -0800

hsqldb.org is proud to announce the newest Release Candidate in the
hsqldb 1.8.0 Development Tree: RC5. Users and developers are
encouraged to download and test the new Release Candidate at:

http://sourceforge.net/project/showfiles.php?group_id=23316&package_id=16702&release_id=295980

Changes include:

Chronological Change List

This file is the accumulated list of changes in the course of
development of
hsqldb 1.8.0 in reverse chronological order.

Fred Toussi (fredt@users.sourceforge.net)
Maintainer, HSQLDB Project

2005.01.24 1.8.0.RC5

Issues with SET CHECKPOINT DEFRAG fixed
New property for larger data file limits is introduced. Once set, the
limit will go up to 8GB. The property can be set with the following SQL
command only when the database has no tables (new database).

SET PROPERTY "hsqldb.cache_file_scale" 8

To apply the change to an existing database, SHUTDOWN SCRIPT should be
performed first, then the property=value line below should be added to
the .properties file before reopening the database.

hsqldb.cache_file_scale=8

It is now possible to add or drop a primary key. An existing primary
key that is to be removed should not be referenced in a FOREIGN KEY
constraint. If a table has an IDENTITY column, removing a primary key
will remove the identity attribute of the column but leave the actual
data. When adding a primary key, a NOT NULL constraint is
automatically added to the column definitions.
The table data for the columns of a newly declared primary key should
not contain null values.

ALTER TABLE <name> ADD CONSTRAINT <cname> PRIMARY KEY(collist);
ALTER TABLE <name> DROP CONSTRAINT <cname>;
ALTER TABLE <name> DROP PRIMARY KEY; // alternative syntax

2005.01.20 1.8.0.RC4

More minor bug fixes
ResultSetMetaData reports identical precision/scale in embedded and
client/server modes

2005.01.16 1.8.0.RC3

Regression bug fixes.
New property allows a CHECKPOINT DEFRAG to be performed automatically
whenever CHECKPOINT is performed internally or via a user command.

SET CHECKPOINT DEFRAG n
The parameter n is the megabytes of abandoned space in the .data file.
When a CHECKPOINT is performed either as a result of the .log file
reaching the limit set by "SET LOGSIZE m", or by the user issuing a
CHECKPOINT command, the amount of space abandoned during the session is
checked and if it is larger than n, a CHECKPOINT DEFRAG is performed
instead of a checkpoint.

2005.01.14 1.8.0.RC2

Regression bug fixes.

2005.01.10 1.8.0.RC1

Allows embedding into OpenOffice.org
Rewrite of log and cache handling classes, including:
New deleted block manager with more effective deleted block reuse.
Faster log processing after an abnormal termination.
Better checks when maximum data file size is reached.
Better recovery when maximum data file size is reached.

Changes to row access to use iterators. More code clarity.

Various refactorings and new package for improved modularity.

Enhancements to DatabaseManagerSwing

In all other respects, 1.8.0.RC1 is identical to 1.7.3.1

For Fred Toussi, hsqldb Project Maintainer
Michael J. Cannon
dedmike
hsqldb Project Manager