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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
