[CALCITE-5615] Run SQL Logic Test suite using Calcite's HSQLDB JDBC adapter

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.34.0, 1.35.0
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 28/Mar/23 17:36
• Updated: 10/Nov/23 11:34
• Resolved: 25/Aug/23 09:51

Description

Add support for running Sql Logic Test suite using Calcite's HSQLDB JDBC adapter. This essentially improves test coverage for the JDBC adapter with HSQLDB in particular.

Running the whole suite is pretty slow (more than 6h) so by default we run only one test file (namely select1.test).

The rest of the tests can be run manually by removing the @Disabled annotation.

Adding more test files and making this part of regular CI runs will be done in follow-up tickets.

Issue Links

• links to: GitHub Pull Request #3145