[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #11 from Julien Nabet --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 Julien Nabet changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |serval2...@yahoo.fr |desktop.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 Julien Nabet changed: What|Removed |Added Blocks||51780 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=51780 [Bug 51780] [META] Default to Firebird not HSQLDB in Base (for _new_ files) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #10 from Dan Lewis --- (In reply to Alex Thurgood from comment #7) > @Dan : errors like the one you reported are often associated with the > fbclient library being used. > > It could be that the libfbclient library provided within LO does not have > support for the datatypes defined in the table. > > Alternatively, it could be that LO is trying to use a libfbclient that is > external to LO and that it is that library which is causing the issue. Only > an inspection of the Ubuntu packages will be able to indicate whether you > have more than one libfbclient library installed. > > This might also explain why the tables are read correctly by isql-fb, as > that client program would use the system libfbclient, rather than any lib > provided with LO. > > > You don't mention where you get your LO6341 from. I'm not sure that Ubuntu > provides LO6341 in the default package repositories, so have you installed > it from somewhere else ? (PPA, TDF download website ?) You may be right. To find out, I first used synaptic to remove firebird files that came from Ubuntu. Then I use a terminal window with administrative rights to remove every libfbdlient on my hard drive. I used sudo updatedb several times as I do so to make sure that I had removed every one. I have downloaded Firebird 3.05 for their website and then installed it. I still get the same results: an error for the same tables of employee.fdb. The latest attachment was made after connecting to employee.fdb using the direct connection. I conclude that the Ubuntu version of Firebird has anything to do with the problem. I download all of my LibreOffice versions are downloaded from the libreoffice.org. The are the pre-release versions which I try always get the latest version when it comes out. So, here is an update: I am now using 6.3.4.2 getting this error message. I also have LO 6.4.0.3 which I used as a test getting the same results: an error message. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #9 from Dan Lewis --- Created attachment 157646 --> https://bugs.documentfoundation.org/attachment.cgi?id=157646=edit picture of my search for libfbclient file on my hard drive -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 Alex Thurgood changed: What|Removed |Added OS|Linux (All) |All Ever confirmed|0 |1 Status|UNCONFIRMED |NEW -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #8 from Alex Thurgood --- I can confirm the described behaviour with Version: 6.3.4.2 Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa Threads CPU : 4; OS : Mac OS X 10.15.3; UI Render : par défaut; VCL: osx; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded and the employee.fdb file provided with the firebird ext source code in my master LO core build tree. The main difference I can see between the tables that fail and the tables that don't is that the failing ones have 3-field primary keys. Most of the other tables have only 1 primary key field, with EMPLOYEE_PROJECT having a 2-field primary key. This table is also displayed without error. So, it could be that the problem is due to our code being unable to handle more than 2 fields defined as joint primary key ? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #7 from Alex Thurgood --- @Dan : errors like the one you reported are often associated with the fbclient library being used. It could be that the libfbclient library provided within LO does not have support for the datatypes defined in the table. Alternatively, it could be that LO is trying to use a libfbclient that is external to LO and that it is that library which is causing the issue. Only an inspection of the Ubuntu packages will be able to indicate whether you have more than one libfbclient library installed. This might also explain why the tables are read correctly by isql-fb, as that client program would use the system libfbclient, rather than any lib provided with LO. You don't mention where you get your LO6341 from. I'm not sure that Ubuntu provides LO6341 in the default package repositories, so have you installed it from somewhere else ? (PPA, TDF download website ?) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 Julien Nabet changed: What|Removed |Added CC|serval2...@yahoo.fr | --- Comment #6 from Julien Nabet --- Indeed it seems specific to Firebird external to an odb, can't help here=>uncc myself. Sorry for the noise. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #5 from Dan Lewis --- (In reply to Julien Nabet from comment #3) > I expected an odb file containing the firebird tables. My problem is not with an embedded firebird database; it is with using firebird1.odb which connects to employee.fdb. Because of that, firebird1.odb contains the location of employee.fdb. The only way for you to change the address containing employee.fdb. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #4 from Dan Lewis --- Created attachment 157571 --> https://bugs.documentfoundation.org/attachment.cgi?id=157571=edit This is the database I used to access the employee.fdb file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #3 from Julien Nabet --- I expected an odb file containing the firebird tables. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 --- Comment #2 from Dan Lewis --- Created attachment 157568 --> https://bugs.documentfoundation.org/attachment.cgi?id=157568=edit this is the requested database. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 130334] firebird direct connector fails to display tables with some multi-field primary key in Base.
https://bugs.documentfoundation.org/show_bug.cgi?id=130334 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #1 from Julien Nabet --- Would it be possible to have a file with embedded Firebird (hoping it can be reproduced too in this case)? It would avoid to require Firebird server install + config. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
