[Libreoffice-bugs] [Bug 141846] Firebird 3 - failure to connect to Firebird file - file structure incompatibility on macOS

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #13 from Mike Kaganski <mikekaganski at hotmail.com> ---
Firebird itself does not support older on-disk structures (ODS). This is true
both for version 3 [1], and version 4 [2]. (Release notes for v4 do mention a
hack to support ODSv12 by copying a library from older version to /plugins;
while it could in theory be made for Windows, it's likely totally impossible
for Linux, where we rely on system FB, and thus custom (self-built?) library
for FB3.0 could fail to work with system FB4.0.)

The 12 vs 12.2 change was described in FB 3.0.4 release notes [3]. It is
described to have impact on macOS and 32-bit Linux; and note this excerpt:

> Existing databases ... are always opened successfully with Firebird 3.0.4
> on the platform *where they were initially created*

The overall policy of the project seems to require use of backup-move-restore
procedure whenever you want to move a BD to a different system; LibreOffice
embedded engine itself save the backup of the FDB, not the FDB itself, for that
reason. By the way, IIRC the ODS even of the same version will differ on
Big-Endian vs Little-Endian machines, making direct move of a FDB of the same
ODS version impossible.

And hence I consider this issue to be NOTABUG (assuming that it was a user
error not using the proper procedure when moving the database), or NOTOURBUG
(taking into account the phrase "A legacy provider for databases with ODS 8 to
11.2 is planned for a future sub-release" from 3.0 release notes, which is
curiously absent from 4.0 release notes).

[1]
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#_other_providers
[2]
https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb40-general
[3]
https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rlsnotes30.html#rnfb30-apiods-ods-12-2

-- 
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/20210919/b6fe7e9b/attachment.htm>