[Libreoffice-bugs] [Bug 141132] 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

Herbert <herbert.giller at free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|7.1.1.2 release             |7.1.2.2 release

--- Comment #4 from Herbert <herbert.giller at free.fr> ---
Version: 7.1.2.2 / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

System is : SuSE-Linus tubleweed and Mariadb
mariadb-admin  Ver 9.1 Distrib 10.5.9-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Server version          10.5.9-MariaDB
Protocol version        10
Connection              Localhost via UNIX socket


I created an HSQL Database  for Test : see attachment
then I created and copied the database to
1. mariadb - jdbc connection
2. mysql - direct connection using mariadb as well

Errors appeared in both mariadb versions while creating a form and setting a
subform with the help of the database-assistent :

Errormessage:
"Die Dateninhalte konn:en nicht geladen werden.
/home/buildslave/source/libo-core/connectivity/source/commontools/dbtools.cxx:751

You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near ':link_from_accNo )' at
line 1
/home/buildslave/source/libo-core/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119"

The errors are mostly always wih the remark: ":link_from_accNo" 
It seems to be an uncompatibility of mariadb with libreoffice-jdbc or mysql
direct connection.
As well errors appeard in case a field is not configured with a standard value.

With native HSQLDB it works fine. See the example database here attached.

-- 
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/20210413/e2a1931c/attachment.htm>