Bug 144619 - FIREBIRD - support on disk structure for FB4 versions
Summary: FIREBIRD - support on disk structure for FB4 versions
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.1.4.1 rc
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Default
  Show dependency tree / graph
 
Reported: 2021-09-20 10:25 UTC by Alex Thurgood
Modified: 2023-10-30 12:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2021-09-20 10:25:43 UTC 
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
Comment 1 Mike Kaganski 2021-09-20 12:13:35 UTC 
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.
Comment 2 Alex Thurgood 2021-09-20 14:27:53 UTC 
(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).
Comment 3 Robert Großkopf 2021-09-25 07:06:58 UTC 
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.
Comment 4 Julien Nabet 2023-01-15 11:22:03 UTC 
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.