Ask Your Question
0

boolean expression in a query : is this a bug ? [closed]

asked 2014-01-22 10:57:55 +0200

Jean-Paul gravatar image

updated 2016-02-19 03:52:37 +0200

Alex Kemp gravatar image

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 ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 03:53:03.127701

2 Answers

Sort by » oldest newest most voted
1

answered 2014-01-22 12:14:33 +0200

frofa gravatar image

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

edit flag offensive delete link more
0

answered 2014-01-23 12:35:11 +0200

Jean-Paul gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-01-22 10:57:55 +0200

Seen: 873 times

Last updated: Jan 23 '14