Fred Toussi

Regression: General Error in 2.7.5 when using expression in FILTER .. WHERE

Thanks for reporting. Fixed and committed. This issue existed before and relates to the use of MOD function.

core code updates - fix for bug #1750

Good suggestion about "not yet supported". But the feature is in the syntax diagram because it is less work than adding it later.

We may support them at some point. BTW, please test with the Release Candidate jar and report any regression. https://sourceforge.net/projects/hsqldb/files/release_candidate/

The release candidate jar is the latest equivalent to the hsqldb.jar. Create a directory and copy the release candidate jar there. You can rename it to hsqldb.jar if you need to.

Thanks for reporting. I suspect the issue with SqlTool is due to a setting in the SqlTool jar which looks for the HSQLDB jar where it expects it to be, therefore using the 2.7.4 jar. Juse copy the SqlTool jar alongside the Release Candidate jar and specify the RC jar path in the Java command.

HSQLDB version 2.7.5 will be released soon. A release candidate jar is available at https://sourceforge.net/projects/hsqldb/files/release_candidate/ Please try this jar with your applications and report any issues.