[Libreoffice-bugs] [Bug 113617] New: Subform Postgresql "The column index out of range: 1, number of columns: 0

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113617
           Summary: Subform Postgresql "The column index out of range: 1,
                    number of columns: 0
           Product: LibreOffice
           Version: 5.3.6.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jeffsummer at mail.com

Description:
Cannot create a subform on a form in Base using postgresql tables connected
over jdbc, always shows the error: The data content could not be loaded."  "SQL
Status: 22023 The column index is out of range: 1, number of columns: 0."

Steps to Reproduce:
1. Create two related tables in postgresql, as simple as relating the integer
field in a second table to the primary key integer field in the first table
2. Connect base to this postgresql database using jdbc
3. Create a new form, use the first table as the outer data source, the second
table as the subform data source, then use the integer field as the master and
slave link field, then run the form, at that point you get the error message

Actual Results:  
error: The data content could not be loaded."  "SQL Status: 22023 The column
index is out of range: 1, number of columns: 0."  The main form gets data, the
subform does not

Expected Results:
A running form and subform


Reproducible: Always


User Profile Reset: No



Additional Info:
postgresql 9.6.4
postgresql-42.1.3.jar



User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36

-- 
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/20171103/930b85ef/attachment.html>