[Libreoffice-bugs] [Bug 130334] 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

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |serval2412 at yahoo.fr

--- Comment #11 from Julien Nabet <serval2412 at yahoo.fr> ---
On Win10 with master sources updated today, I gave a new try.

Personal note:
- in DB wizard, use "connect to an existing database"
- select Firebird file
- click "Browse..."
- select fdb file
and validate.

Then, on Windows only because it works directly on Linux:
- Menu Edit/Database/Property
- Replace file:///...
by Replace file://...

I had an assertion (because I use debug option) for these 2 tables.
The problem isn't multiprimary key but the use of SQL_ARRAY which isn't
implemented at some locations:
-
https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/Util.cxx?r=1dd9200b#313
-
https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/Util.cxx?r=1dd9200b#370

However, I noticed in
https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes-bnrytypes.html#fblangref25-datatypes-array
that an Array was in fact a BLOB, extract:
"Arrays in Firebird are stored in BLOB of a specialized type"

Considering this can be treated as a BLOB, I changed locally the 2 elements I
quoted and I could open the tables.

-- 
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/20200309/b2e8cb5d/attachment.htm>