[Libreoffice-bugs] [Bug 141132] New: SQL Query to MARIADB fails (conn=1411) Could not set parameter at position..... in a formular

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141132
           Summary: SQL Query  to MARIADB  fails (conn=1411) Could not set
                    parameter at position..... in a  formular
           Product: LibreOffice
           Version: 7.1.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: herbert.giller at free.fr

Description:
A query to 2 mysql databases ( here : EIN2021 and adr01) breaks down when this
is set as a SubForm.

error message is:

Full Error Message as  example (german):
Die Dateninhalte konnten nicht geladen werden.
/home/abuild/rpmbuild/BUILD/libreoffice-7.1.1.2/connectivity/source/commontools/dbtools.cxx:751


SQL-Status: 42000
Fehlercode: -1

(conn=1411) Could not set parameter at position 1 (values was 565)
Query - conn:1411(M)  - "SELECT `adr01`.`KDNR`, `adr01`.`KDNR`, `adr01`.`NAME`,
`adr01`.`VORNAME`, `EIN2021`.`KDNR` FROM `KKS`.`EIN2021` `EIN2021`,
`KKS`.`adr01` `adr01` WHERE `EIN2021`.`KDNR` = `adr01`.`KDNR`"
/home/abuild/rpmbuild/BUILD/libreoffice-7.1.1.2/connectivity/source/drivers/jdbc/Object.cxx:175

Steps to Reproduce:
1.A Form ist edited. A Subform created and the  the SQL Query is inserted 
2.when editmode for the formular  is closed, the errormessage comes up 
with this titel: 
"Die Dateninhalte konnten nicht geladen werden.
/home/abuild/rpmbuild/BUILD/libreoffice-7.1.1.2/connectivity/source/commontools/dbtools.cxx:751"
3. When back to form and everything is written, the tablef-field remains empty.


Actual Results:
No query is possible in this environment.
MARIADB 

Expected Results:
SubForms could be usefull to create relational data connections.


Reproducible: Always


User Profile Reset: No



Additional Info:
It should show a form with relational subfoms linked by sql queries.
A KDNR in an accounting should be linked with KDNR in an adress database

-- 
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/20210320/e980a7eb/attachment.htm>