Changes to hsqldb v.1.8.0 since RC5
Fixed minor bugs
Added public shutdown() method to Server.
A new application log has been introduced as an optional feature. The property/value pair
"hsqldb.applog=1" can be used in the first connection string to log some important messages.
The default is "hsqldb.applog=0", meaning no logging. A file with the ending ".app.log" is
generated alongside the rest of the database files for this purpose.
In the current version only the classes used for file persistence (different in OpenOffice.org),
plus any error encountered while processing the .log file after an abnormal end is logged.
Bob Preston has updated the text table support to accept new line characters inside quoted
strings. It is still not possible to create / modify a row containing a new line inside the engine.
This will be a simple upgrade and will be included in the next RC.
Note that the JDBC driver and the engine for 1.8.0 cannot be mixed with those of earlier
versions in client/server setup. Check your classpaths and use the same version of the engine
for both client and server.
Fixed minor bugs
Release of Version 220.127.116.11
HSQLDB 1.7.3 CHANGE LOG
Version 1.7.2 was regularly updated after the initial release with bug fixes, leading to revision 18.104.22.168. In the meantime new work was carried out by Thomas Mueller on SQL Standard handling of NULL values and the BOOLEAN type. Towards the end of 2004, this work was included in a new version 1.7.3.
Bug fixes and enhancements in 1.7.3 up to revision 22.214.171.124:
Fixed bug with logging of deletes / updates from tables without primary keys. If the a row from such tables contained a null value and was deleted / updated, the operation was not logged correctly. Subsequently, if there was an abnormal termination after such changes and the database was restarted, the logged delete statement would not have any effect and result in duplicate rows. This bug did not affect tables with primary keys or the normal operation
(without abnormal termination) of any tables.
Allow conversion from BIGINT to SAMMLINT and TYNYINT (all other legal conversions worked fine)
Fixed issue with null values in calls to ResultSet methods with a Calendar argument.
Enhancement to allow INSERT INTO <T> SELECT (....) where no column list list for the table T is specified.
Corrected scripting of CHECK constraints with NOT NULL and IS NULL
Fixed NPE error when functions in subqueries.
Added support for STDDEV_POP, STDDEV_SAMP, VAR_POP, VAR_SAMP, EVERY and SOME set functions.
Fixed potential issues with logging DELETE statements for tables with multi-key primary keys.