[Libreoffice-bugs] [Bug 132377] New: Base - native MySQL - linked subforms do not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132377
           Summary: Base - native MySQL - linked subforms do not work
           Product: LibreOffice
           Version: 6.4.3.1 rc
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jphorst at sciencebridge.de

Description:
When opening forms with subforms the following error is produced:

SELECT * FROM "projekte"."nationalisierungen" WHERE (
"projekte"."nationalisierungen"."pID" = :link_from_str_ID ) ORDER BY "Land" ASC

nationalisierungen is a table included in the form as subform by linking its
field pID to the field str_ID of the main table/form.

"pID" = :link_from_str_ID does not seem to be standard SQL and throws the
error.

Base is connected to a MariaDB (10.1.44 Ubuntu 18.04.1) via
libreoffice-mysql-connector (6.4.3-1)

Steps to Reproduce:
1. Open form with subforms.
2.
3.

Actual Results:
Error shown.
Subform fields are not populated with data.

Expected Results:
Subform fields/tables should be populated with data


Reproducible: Always


User Profile Reset: No



Additional Info:
-

-- 
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/20200424/89acd677/attachment.htm>