That's right, Keith. Competing with that limitation, SqlTool has the advantage that if the SQL can be written in portable fashion (not possible if using proprietary SQL additions), the same script can be executed against HyperSQL and PostgreSQL.
I suggest you use SqlTool, which is designed to execute SQL files, and can detect and handle errors more reliably and with more control than Database Manager.
SqlTool doesn't support input or output of times without dates. This isn't a HyperSQL database limitation, but a SqlTool limitation so that SqlTool can behave the same regardless of database back end. Relevant code comment: // N.b. WE SPECIFICALLY DO NOT HANDLE TIMES WITHOUT // DATES, LIKE "3:14:00", BECAUSE, WHILE THIS MAY BE // USEFUL AND EFFICIENT, IT IS NOT PORTABLE. You can customize output format however you wish to by coding the Java extraction and string formatting around line 3927 of SqlFile.java...
When I have time on the weekend, I'll check if there is a direct way. In the mantime, you can specify the column list explicitly instead of "*" and use a SQL function to format the date/column as you want it. (FYI, you don't have to quote PUBLIC).
Merge revs 5753-5755 from truk unto tag 2.3.5
Merged in commit 5748 from trunk into tag 2.3.5
Prep for release 2.3.5
Release tag for 2.3.5. Tag adjustments forthco...