[Libreoffice-bugs] [Bug 142091] New: 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

            Bug ID: 142091
           Summary: Queries like "SELECT 1 + 1;" won't run on Libreoffice
                    Base with the MySQL backend.
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: johnstonethepepsi at gmail.com

Description:
Queries like "SELECT 1 + 1;" refuse to run in Libreoffice Base with the MySQL
backend, even tough they run perfectly from the MySQL command line. Not sure if
this affects other backends too.
The example I provided might not seem very useful, but similar queries are
useful for getting ratios such as the percentage of men in a dataset:

SELECT (SELECT COUNT(*) FROM members WHERE gender = 'm') / (SELECT COUNT(*)
FROM members);

This query runs fine from the MySQL command line, but Libreoffice refuses to
run it for some reason.


Steps to Reproduce:
1. Create database with MySQL as backend.
2. Try running a query like "SELECT 1 + 1;"

Actual Results:
SQL Status: HY000
Error code: 1000

syntax error
/build/libreoffice-fresh/src/libreoffice-7.1.2.2/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:

SQL Status: HY000
Error code: 1000

/build/libreoffice-fresh/src/libreoffice-7.1.2.2/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:108

SQL Status: HY000
Error code: 1000

Syntax error in SQL statement
/build/libreoffice-fresh/src/libreoffice-7.1.2.2/dbaccess/source/core/api/SingleSelectQueryComposer.cxx:109

Expected Results:
It should return the number 2


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.2.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: hu-HU (en_US.utf8); UI: en-US
7.1.2-3
Calc: threaded

I am using Manjaro Linux.

-- 
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/20210505/f5b8acce/attachment-0001.htm>