[Libreoffice-bugs] [Bug 130334] New: firebird direct connector fails to display tables with some multi-field primary key in Base.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 130334
           Summary: firebird direct connector fails to display tables with
                    some multi-field primary key in Base.
           Product: LibreOffice
           Version: 6.4.0.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: elderdanlewis at gmail.com

Description:
The installation file from the computer's O/S distribution repository,
employee.fdb. Connecting to this database using Base using the direct firebird
connector works. Viewing the tables of this database results in all of the
tables except for JOB and PROJ_DEPT_BUDGET being open for viewing fields and
data. The error message is:
 firebird_sdbc error:
*Incorrect values within SQLDA structure
*empty pointer to data
*at SQLVAR index 3
caused by
'isc_dsql_fetch'

Steps to Reproduce:
1.Install firebird using your distributor's repository.
2.For Ubuntu, extract employee.sql from employee.sql.gz. Then using isql-fb to
create employee.fdb from employee.sql.

3.New > Connect to an existing database > Firebird file. Click Next. 
4.Browse to the location of employee.fdb.
5.Click Finish.
6.Browse to where this LO database is to be located and name it.
7.Click Save.
8.Open the LO database and click Tables in the main database window.
9. In the view area, change View to Document to the right of the list of tables
for employee.fdb.
10.Click each table in the table list to view the content of each one.


Actual Results:
I got an error message for the tables JOB and PROJ_DEPT_BUDGET. The other
tables can be opened revealing their fields and data. I had also connected to
this database using isql-fb -user SYSDBA -password 'password' <path to
employee.fdb>. Then SQL> SHOW TABLES; All of tables of employee.fdb are then
shown including JOB and PROJ_DEPT_BUDGET.

Expected Results:
all of the tables can be opened.


Reproducible: Always


User Profile Reset: No



Additional Info:
I use Ubuntu 18.04 with the latest updates and LibreOffice 6.3.4.1. It seems to
work for Open SuSe according to Robert Großkopf.

-- 
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/20200131/84fe3c18/attachment-0001.htm>