Bug 145899

Summary:	I can't open a document in LibreOffice 7.2.3.2 Base & in all 7.2.x.x
Product:	LibreOffice	Reporter:	Olrg Murawicki <murawicki>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	robert
Priority:	medium
Version:	7.2.2.2 release
Hardware:	All
OS:	macOS (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Olrg Murawicki 2021-11-26 13:28:14 UTC

Description:
The connection to the data source "patients_therapy-2021.11.24" could not be established.
firebird_sdbc error:
*arithmetic exception, numeric overflow, or string truncation
*string right truncation
*expected length 200, actual 215
*gds_$send failed
*Exiting before completion due to errors
caused by
'isc_service_query'

Steps to Reproduce:
1.open any Base document
2.
3.

Actual Results:
open any Base document

Expected Results:
I want to open Base files in LibreOffice 7.2


Reproducible: Always


User Profile Reset: No



Additional Info:
In LibreOffice 7.1 all OK

Comment 1 Robert Großkopf 2021-11-27 11:17:13 UTC

Try to open the database with LO 7.1. Seems there is a field in a table, which contains 215 characters, but is defined for 200 characters.

Up to LO 7.2 it has been possible to insert more characters as defined in a table. Has something to do with UTF8 and stringlength in Firebird.

Comment 2 Robert Großkopf 2021-11-27 11:20:23 UTC

Have a look here:
https://bugs.documentfoundation.org/show_bug.cgi?id=144163

I will mark this bug as a duplicate. Feel free to reopen if you think this is another bug.

*** This bug has been marked as a duplicate of bug 144163 ***