https://bugs.documentfoundation.org/show_bug.cgi?id=143656
Robert Großkopf <rob...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|NOTABUG |---
Status|RESOLVED |UNCONFIRMED
--- Comment #2 from Robert Großkopf <rob...@familiegrosskopf.de> ---
Please let it unconfirmed.
There shouldn't be a difference between direct connecting to the database with
a query and Tools → SQL.
I know it will work with
SELECT * FROM "Person" WHERE "Name" LIKE '%\*' ESCAPE '\'
This will also work in GUI.
HSQLDB accepts also
SELECT * FROM "Person" WHERE "Name" LIKE '%*'
with the right results, when switching to direct SQL. And this should be the
way Tools → SQL and also executing through macro should work: Direct to the
database without changing the content of a query.
By the way: It is the same buggy behavior when connecting to MariaDB.
SELECT * FROM `Person` WHERE `Name` LIKE '%*'
will work with direct SQL in the query-editor (and also, for example, in
PHPMyAdmin), but only
SELECT * FROM `Person` WHERE `Name` LIKE '%$*' ESCAPE '$'
will give the same result with Tools → SQL
Only queries created through the GUI should change the content so LO Base could
work with this queries, for example to input data. Changing content of input
though macros and Tools → SQL shouldn't be allowed.
--
You are receiving this mail because:
You are the assignee for the bug.
