[Libreoffice-bugs] [Bug 143656] Direct SQL: Queries in Tools → SQL and macro give wrong results - direct SQL works well

[bugzilla-daemon at bugs.documentfoundation.org]

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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|NOTABUG                     |---
             Status|RESOLVED                    |UNCONFIRMED

--- Comment #2 from Robert Großkopf <robert at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210801/3da6d3d0/attachment.htm>