Created attachment 100132 [details]
Screenshot of the SQL query and the resulting error messages.
In a database I created a table "foobar". I then tried both to use the SQL tool, and to create an SQL query, that executed the SQL command "truncate table foobar".
The error resulting is a basic "syntax erro", which if I ask for more detail breaks down into three errors none of which contain any actual information. So far as I can tell from HSQLDB docs, the syntax is flawless (I did play with presence and absence of a terminating ";", that makes no difference). And the "BETWEEN" and "IN" token referenced *aren't* syntactically valid there according to the HSQLDB docs.
Operating System: Windows 7
Version: 22.214.171.124 release
I could confirm the information of the error-message of the query-editor is very confusing. Don't know where the message come from (HSQLDB or internal dialog?). So I set this bug to new and as an ask for an enhancement (better messages ...).
It's the same behavior on all systems - get the same with Linux rpm.
What do you want to get with "truncate table toolbar"?
In the internal HSQLDB (1.8!) there is a function TRUNCATE.
TRUNCATE(2.37456,2) = 2.37
The code you put in the query-editor isn't a valid query for the internal HSQLDB and any other database. The query-editor does allow only queries. And so the editor produces an error-message, which seems to be the last in a circle of informations. Says only: I'm missing a possible end of a query. Better would be: The command isn't a query - it doesn't start with SELECT.
The code would work together, for example, MySQL, when you put it to Tools → SQL.
Could be you need something like
truncate table `toolbar`
Adding self to CC if not already on