Mihai Budiu created CALCITE-5615:
------------------------------------
Summary: Run SQLLogicTests using Calcite
Key: CALCITE-5615
URL: https://issues.apache.org/jira/browse/CALCITE-5615
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.34.0
Reporter: Mihai Budiu
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.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
