[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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #1 from m.a.riosv <miguelangelrv at libreoffice.org> ---
See the help
https://help.libreoffice.org/latest/en-US/text/sdatabase/02010100.html?&DbPAR=BASE&System=WIN
search for
Like Escape Sequence: {escape 'escape-character'}
Example: select * from Item where ItemName like 'The *%' {escape '*'}
The example will give you all of the entries where the item name begins with
'The *'. This means that you can also search for characters that would
otherwise be interpreted as placeholders, such as *, ?, _, % or the period.

So in LO you need to escape *, with in direct-sql not.

I think it's not a bug, it is how it works. Maybe there was a reason to
implement such think in base.

-- 
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/9fdba37c/attachment.htm>