[Libreoffice-bugs] [Bug 133994] FIREBIRD: Query destroys connection to internal Firebird database

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133994

--- Comment #2 from Robert Großkopf <robert at familiegrosskopf.de> ---
Have found the reason in the code.
If I write this:

SELECT "a"."Datum" FROM "Ansicht_Datum_lfdNr" AS "a" WHERE "a"."Datum" BETWEEN
'2020-01-01' AND '2020-12-31'

Firebird database will disconnect

and if I get the same with
SELECT "a"."Datum" FROM "Ansicht_Datum_lfdNr" AS "a" WHERE "a"."Datum" >=
'2020-01-01' AND "a"."Datum" <= '2020-12-31'

Firebird will work as expected. But Firebird should know what "BETWEEN" is. It
is content of the docs of Firebird - and the alternative I wrote down is shown
there also as the possibility to get the same result.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200615/3c454009/attachment.htm>