https://bugs.documentfoundation.org/show_bug.cgi?id=119569
Bug ID: 119569
Summary: Open Sub-Form causes PostgreSQL error
Product: LibreOffice
Version: 6.0.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: albrecht.dr...@arcor.de
Created attachment 144518
--> https://bugs.documentfoundation.org/attachment.cgi?id=144518&action=edit
Minimal test case for reproducing the bug
I created a LibreOffice document which accesses a PostgreSQL database using the
native (“Database type: PostgreSQL”) driver. If a form contains a linked
sub-form, opening it will cause a postgres server error message due to a
malformed query.
Please see the attached minimal test case:
- create the test db by calling (as postgres superuser)
psql postgres < lotest.sql
- open LO-Test.odb, select Forms, and double-click “Testform”
This causes the following messages in the Postgresql server log:
ERROR: syntax error at or near ":" at character 82
STATEMENT: SELECT * FROM "public"."tab2" WHERE ( 0 = 1 ) AND ( (
"public"."tab2"."ref_id" = :link_from_id ) )
The bug is reproducible with LibreOffice 6.0.4.2 on Ubuntu 18.04 LTS and 6.1.0
on Debian Stretch.
Apart from the initial faulty query, the form works as expected.
Side note: there are some similar but closed issues regarding the JDBC driver
where setting an advanced connection option should solve the bug. The
PostgreSQL driver apparently doesn't support these options, though (the
“Advanced Settings…” menu entry is inactive).
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
