Description: Current FB3 release does not support future FB4 on disk structure. This will require updating the FB sources in the LO build tree. Firebird server version: WI-V4.0.0.2496 fIREBIRD 4.0 Cloned from bug 141846 Error Message: firebird_sdbc error: *unsupported on-disk structure for file C:\PROGRAM FILES\FIREBIRD\FIREBIRD_4_0\EXAMPLES\EMPBUILD\EMPLOYEE.FDB; found 13.0, support 12.0 caused by 'isc_attach_database' Steps to Reproduce: 1. Attempt to configure a connection to the example file provided in the FB4 server release. 2. Error message produced when attempting to view any table data. Actual Results: Error message when attempting to read table data from a FB4 server example FDB file Expected Results: Table should be read, and corresponding data displayed. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.1.4.1 (x64) / LibreOffice Community Build ID: f67b1ddedeb24fca1c5938e7cebfab73d708b35b CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: threaded
Just a note: as explained in bug 141846 comment 13, upgrading FB to v4 would mean that we loose compatibility with On-Disk Structure v12 - and will get the same error trying to open FDBs from FBv3.
(In reply to Mike Kaganski from comment #1) > Just a note: as explained in bug 141846 comment 13, upgrading FB to v4 would > mean that we loose compatibility with On-Disk Structure v12 - and will get > the same error trying to open FDBs from FBv3. Perfectly understandable - the question will then be when to move to FB4 v13 ods support. Personally, I only recently installed a FB3 server for macOS, and to my knowledge there is no FB4 version for macOS available for download (unless I'm looking in the wrong place).
It is an ask for enhancement. It doesn't work. So I set this one to new. But: I would prefer not to switch anything for the internal Firebird database. Internal Firebird database has enough problems.
Ilmari: following my response about your email concerning https://wiki.documentfoundation.org/Development/Budget2023#Make_Firebird_implementation_production-ready here's a pb with FB versions. It's not referenced by META tdf#51780 but obviously we can't stay stuck to FB3 forever.
There shouldn't be any problem in actualize the Firebird embedded databases, just because the way to actualize ODS (on disk structure) version is doing a backup with the old version and restore with the new version. Since the database is backed up in the ODB file, just opening with the new versión, and therefore restoring the database with the new version, the ODS is updated to the new version. In the case of external files, also is not very difficult to backup with the old version and restore with the new.
(In reply to jcsanz from comment #5) > There shouldn't be any problem in actualize the Firebird embedded databases, > just because the way to actualize ODS (on disk structure) version is doing a > backup with the old version and restore with the new version. > > Since the database is backed up in the ODB file, just opening with the new > versión, and therefore restoring the database with the new version, the ODS > is updated to the new version. > > In the case of external files, also is not very difficult to backup with the > old version and restore with the new. You vote for a change from Firebird 3.0 to Firebird 4.0 - or do I understand it wrong way?
(In reply to Robert Großkopf from comment #6) > You vote for a change from Firebird 3.0 to Firebird 4.0 - or do I understand > it wrong way? Yes, I vote for a change to Firebird 4.0, or better still for a change to Firebird 5.0 since while we are thinking about, Firebird 5.0 will be a mature version: version 5.0.1 is near to be released.
(In reply to jcsanz from comment #7) This is 134526, and a WIP is https://gerrit.libreoffice.org/c/core/+/168449.