Fred Toussi

You can create a bug report and attach the benchmark to it. It's possible to allow a user-defined property for the lock mode.

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.