[jira] [Resolved] (CALCITE-5037) Upgrade HSQLDB to 2.5.2

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

     [ https://issues.apache.org/jira/browse/CALCITE-5037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-5037.
----------------------------------
    Resolution: Fixed

Fixed in [92843e8d|https://github.com/apache/calcite/commit/92843e8d63455cfb3cd8cc2b83951525e6e93143].

> Upgrade HSQLDB to 2.5.2
> -----------------------
>
>                 Key: CALCITE-5037
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5037
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>            Priority: Major
>             Fix For: 1.31.0
>
>
> Upgrade HSQLDB to 2.5.2 (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 HSQLDB's [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)