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

["Mihai Budiu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17710376#comment-17710376 ] 

Mihai Budiu commented on CALCITE-5615:
--------------------------------------

I have managed to run (some of the 7M) tests with the "default" Calcite implementation (via jdbc:calcite), and using HSQLDB to actually store the data.
The tests find a fair number of Calcite bugs: both crashes and incorrect results.
The next step is for me to remove all dependencies in the code from our own libraries and then contribute the code to Calcite.
In the meantime I can probably file bugs here for some of the programs that give incorrect results.




> 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
>            Priority: Minor
>
> 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)