Boolean expression in a query : is this a bug?

[Jean-Paul1]

I am using LibreOffice Base (Version: 4.1.4.2 under Windows 8.1).
I create a simple table with 2 boolean columns :
CREATE CACHED TABLE “Table-Test-Booleans”(“ID” INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,“BOOLEAN1” BOOLEAN,“BOOLEAN2” BOOLEAN)

The following SELECT statement works correcty from the SQL tool, and also for the creation of a view, but not as the definition of a query (giving SQL Status: HY000, Error code: 1000, syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE:)

SELECT
“ID” AS “ID”
, “BOOLEAN1” AS “BOOLEAN1”
, “BOOLEAN2” AS “BOOLEAN2”
, ( “BOOLEAN1” OR “BOOLEAN2” ) AS “BOOLEAN1OR2”
FROM “Table-Test-Booleans”

Is this a bug or do I overlook something ?

[frofa]

Maybe try toggling the Run SQL Command directly button (top right) in the QUERY edit window. Let us know if this procedure works.

[Jean-Paul1]

Yes, this works great ! With “Run SQL command directly”, thet SELECT statement works correctly.
Thanks for your support.