[Libreoffice-bugs] [Bug 124530] New: PostgreSQL Native Driver: Images aren't shown in form when content of field is created in query

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124530
           Summary: PostgreSQL Native Driver: Images aren't shown in form
                    when content of field is created in query
           Product: LibreOffice
           Version: 6.2.2.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: robert at familiegrosskopf.de

You will need a PostgreSQL-database for testing this:

1. Create a table in PostgreSQL:
CREATE TABLE "public"."PG_LOconn" (
   "ID" serial NOT NULL,
   "PathName" text NULL,
   "PicName" text NULL,
   CONSTRAINT "PG_LOconn_pkey" PRIMARY KEY ("ID")
);
2. Create a form for input data into this table. "PathName" should save the
path to the image - so an image-control is needed. "PicName" should save only
the name of the image.
3. Insert one row in this table through the form.
4. Create a query like
SELECT "ID", "PathName", "PicName", CONCAT( '/home/yourname/', "PicName" ) AS
"PicPathName" FROM "public"."PG_LOconn"
The first part of the CONCAT-Function should be the same as in "PathName", so
could also be a relative link.
5. Open the form for editing, link the form to the query and create a new
image-control for "PicPathName".
6. Open the form for input data.
Bug: The image of the "PicPathName" won't be shown in PostgreSQL with the
native driver.
Now change the connection to PostgreSQL to JDBC. The image will be shown in
"PicPathName".

All tested with 
Version: 6.2.2.2
Build-ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU-Threads: 6; BS: Linux 4.12; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
Calc: threaded
on OpenSUSE 15, 64bit rpm Linux

-- 
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/20190403/7b088948/attachment.html>