Bug in HyperSQL DB

[mihaibudiu]

I have filed https://sourceforge.net/p/hsqldb/bugs/1680/
This issue was discovered using this tool and it causes many of the tests to fail.
There is no other good place to mention this, so I am just opening an issue here too.

[julianhyde]

Bugs in underlying DBs will be the exception rather than the rule. A bug in HSQLDB (or Calcite) does not automatically become a bug in sql-logic-test (SLT).

SLT should have:

• A means to disable tests (files and queries within the files);
• A means to filter queries (e.g. convert minus space minus to minus minus or to nothing, if that is the workaround to HSQLDB 1680).

Do you consider this a blocking bug for SLT version 0.1? What do you consider to be a reasonable fix?

[mihaibudiu]

There is a way to disable tests using the -b argument, but there are literally tens of thousands of failures caused by this one problem, so that's not a workable approach - unless we automate generating that file.

I don't think this is a bug in SLT, just wanted to point out what SLT can do. We may want a way to keep track of the bugs discovered using SLT in other databases.

This suggests a different issue I will file: a way to automatically cluster bugs so that different queries that trigger the same bug produce a single bug report instead of thousands.