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: 4.2.4.2 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