Re: Request for upload HSQLDB 2.3.3.zip on http://dev-www.libreoffice.org/src

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/hsqldb_2_3_3.zip to
> > http://dev-www.libreoffice.org/src ? (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
https://bugs.documentfoundation.org/show_bug.cgi?id=44854#c0

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 OpenOffice.org
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
https://bugs.documentfoundation.org/show_bug.cgi?id=44854#c0

The HSQL developers pledge to collaborate with us on that. See
http://hsqldb.org/web/openoffice.html

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

-- 
Lionel