[HADOOP-18451] Update hsqldb.version from 2.3.4 to 2.5.2

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: common
• Labels: pull-request-available
• Target Version/s: 3.4.0
• Hadoop Flags: Reviewed
• Assignee: Shilun Fan
• Reporter: Shilun Fan
• Created: 13/Sep/22 00:49
• Updated: 20/Sep/22 22:18
• Resolved: 20/Sep/22 18:11

Description

I plan to upgrade the version of hsqldb from 2.3.4 to 2.5.2 for the following reasons:

1.Current version 2.3.4 is almost ~6 years old，Upgrading to new release to keep up for new features and bug fixes.

2.I plan to increase the verification of the table building statement, which needs to use the compatibility mode of Mysql and SqlServer. 
The 2.5.2 version of hsqldb does better.

3.We are temporarily unable to upgrade hsqldb to version 2.6.0 because version 2.6.0 depends on JDK11.

Issue Links

• links to: GitHub Pull Request #4880