[Libreoffice-bugs] [Bug 142091] Queries like "SELECT 1 + 1; " won't run on Libreoffice Base with the MySQL backend.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Alex Thurgood <iplaw67 at tuta.io> ---
Works for me too on

Version: 7.1.2.2 / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

cf. enclosed screenshot

As Robert has mentioned, you need to run the query in Direct SQL mode, i.e.
bypassing the LO SQL parser.

-- 
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/20210607/0064463b/attachment.htm>