pb of backward compatibility 3.0.0 -> 3.0.7 (error "string right truncation expected length 5, actual 9...")

[serval2412]

Hello,

Summary: A user provided an odb file (generated on LibreOffice) containing embedded Firebird. At a moment LibreOffice upgraded from Firebird 3.00 to Firebird to 3.0.7 but it seems it corrupted the fbk file.

Details: The attachement firebird.zip contains a corrupted fbk file. This fbk file (created with Firebird version 3.0.0) is accepted by runBackupService(isc_action_svc_restore) from this same Firebird version 3.0.0 although it contains non-conforming data. After some investigation, the table has been defined for filed "Column 1" with VARCHAR(5) and for "Column 2" with VARCHAR(10). A look at the content (with Libreoffice 7.1.5.2, so with Firebird 3.0.0) shows that "Column 1" had some values with 9 characters, "Column 2" values with 11 characters.

When trying to open the odb file with recent Libreoffice (so with Firebird version 3.0.7) we got this error: *arithmetic exception, numeric overflow, or string truncation *string right truncation *expected length 5, actual 9 *gds_$send failed *Exiting before completion due to errors caused by 'isc_service_query'

This leads to users not being able to access their data anymore.

For reasons of backwards compatibility, would you consider making runBackupService(isc_action_svc_restore) more "be liberal in what it accepts", insofar as it will accept data produced by earlier versions of Firebird?

(see details here: https://bugs.documentfoundation.org/show_bug.cgi?id=144163)