https://bugs.documentfoundation.org/show_bug.cgi?id=123150
Robert Großkopf <rob...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|FIREBIRD: Simple SQL query |FIREBIRD: Query with 'LIKE'
|fails with error "malformed |fails with error "malformed
|string" |string", when index is set
| |for the field of the
| |condition of the query
--- Comment #9 from Robert Großkopf <rob...@familiegrosskopf.de> ---
(In reply to Gerhard Schaber from comment #8)
> This happens when manually executing the SQL query, as well as running it as
> Basic macro.
You are right. I have switches from GUI to SQL and back and tested the query
SELECT * FROM "MitgliederVerband" WHERE "Vorname" LIKE 'Ötkül*'
- * instead of % - and this gives different results.
Then I deleted the index for the field "Vorname" and the original query workes
- as you described.
When creating a new index the bug appears again.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs