You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Mihai Budiu (Jira)" <ji...@apache.org> on 2023/03/28 17:37:00 UTC

[jira] [Created] (CALCITE-5615) Run SQLLogicTests using Calcite

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)