[Libreoffice-bugs] [Bug 119569] New: Open Sub-Form causes PostgreSQL error

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: albrecht.dress at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180828/0cb994f2/attachment.html>