Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

boolean expression in a query : is this a bug ?

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 ?

boolean expression in a query : is this a bug ?

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 ?