[jira] [Created] (CALCITE-5037) Upgrade HSQLDB to 2.5.1

["Julian Hyde (Jira)" <ji...@apache.org>]

Julian Hyde created CALCITE-5037:
------------------------------------

             Summary: Upgrade HSQLDB to 2.5.1
                 Key: CALCITE-5037
                 URL: https://issues.apache.org/jira/browse/CALCITE-5037
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


Upgrade HSQLDB to 2.5.1 (the last version that also supports Java 8) and allow people to run using HSQLDB 2.6.1 (the most recent version, which requires Java 11 or higher).

We cannot currently do this because we depend on scott-data-hsqldb:0.1, foodmart-data-hsqldb:0.4 and chinook-data-hsqldb:0.1, and these have embedded data files in HSQLDB 1.8 format, which HSQLDB 2.5.1 no longer supports.

Per release [release notes|http://hsqldb.org/doc/2.0/changelist_2_0.txt]:

{quote}
21 March 2021 - version 2.6.0
...
-- version 2.6.0 jar requires JRE 11 or later - tested up to Java 16 RC
-- version 2.6.0 alternative jar requires JRE 8 or later
...

24 June 2020 - version 2.5.1
version 2.5.1 jar requires JRE 8 or later - tested up to Java 14
... 
removed legacy support for opening version 1.8 databases
{quote}

I have released scott-data-hsqldb:0.2 and foodmart-data-hsqldb:0.5, and when we have chinook-data-hsqldb:0.2 we can upgrade to them and should be able to go to HSQLDB 2.5.1 or 2.6 (on Java 11, or on Java 8 with the alternative jar).



--
This message was sent by Atlassian Jira
(v8.20.1#820001)