[
https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis updated CALCITE-5615:
-----------------------------------------
Description:
Add support for running [Sql Logic Test
suite|https://github.com/hydromatic/sql-logic-test] 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|https://github.com/hydromatic/sql-logic-test/blob/0a809c530457bf0e56d637ef19fcaabd2964fd67/src/main/resources/test/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.
was:
Sqllogictest is a program designed to verify that an SQL database engine
computes correct results by comparing the results to identical queries from
other SQL database engines.
https://www.sqlite.org/sqllogictest/doc/trunk/about.wiki
The nice thing about SLT is that it contains more than 7 million tests. The
tests only cover the core of SQL, ideally the portable part across all engines.
They only test integers, doubles, and strings. So they could probably be part
of the Calcite slow tests.
The tests should be structured so that any query execution engine can be used.
I plan to contribute such an implementation if people think it is useful, but I
haven't yet worked out all the details.
> Run SQL Logic Test suite using Calcite's HSQLDB JDBC adapter
> ------------------------------------------------------------
>
> Key: CALCITE-5615
> URL: https://issues.apache.org/jira/browse/CALCITE-5615
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.34.0, 1.35.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.36.0
>
> Time Spent: 1h 20m
> Remaining Estimate: 0h
>
> Add support for running [Sql Logic Test
> suite|https://github.com/hydromatic/sql-logic-test] 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|https://github.com/hydromatic/sql-logic-test/blob/0a809c530457bf0e56d637ef19fcaabd2964fd67/src/main/resources/test/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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
