Request for upload HSQLDB on

Lionel Elie Mamane lionel at
Mon Dec 14 08:58:36 PST 2015

On Mon, Dec 14, 2015 at 12:47:06PM +0100, Michael Stahl wrote:
> On 12.12.2015 00:44, julien2412 wrote:

>> I'm giving a try to tdf#44854 "Upgrade bundled HSQLDB to 2.x".
>> Would it be possible to upload the repackaged file from
>> http://localhost/serval2412/ to
>> ? (md5 =
>> 40cc60070acaa2d49193b3abd15e560e, no need to prefix the file with it)

>> For the moment, I just succeeded in:
>> - adding a flag ENABLE_HSQLDB2 (since experimental) +  building the package
>> - Creating a brand new file with a table

> what benefits does HSQLDB2 have?

>From my comment at

Upgrading the bundled HSQLDB to the latest 2.x would bring new
features and better ANSI SQL support for embedded-in-odb-file
databases. See e.g. bug 39872, and also support for "IS [NOT] DISTINCT
FROM" comparisons.

> i thought we use an old version of HSQLDB because its file format
> changed and so if we upgrade then we create compatibility issues with
> HSQLDB files embedded in ODB documents; is there more backward
> compatibility nowadays?

No, upgrade to HSQLDB will need a proper "file format changed"
migration path. AFAIK, there was some feature branch of
that had the beginnings of that, with a pop-up of "would you like to
upgrade the database format now and lose backward compatibility with
older versions of OpenOffice?".

>From my comment at

The HSQL developers pledge to collaborate with us on that. See

There is also a CWS with work on that, namely hsqldb19?


More information about the LibreOffice mailing list