https://bugs.documentfoundation.org/show_bug.cgi?id=147893
Bug ID: 147893
Summary: Embedded firebird extends size of CHAR() data field
beyond set boundaries and invokes error message
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When filling a field with a fixed character size data type with appropriate
data, the field is right padded with spaces to 4 times its defined length.
Steps to Reproduce:
1. Create new embedded firebird database
2. Create new table with a CHAR() data field (weather primary key or not)
3. Insert data, save and close table
4. Reopen table
Actual Results:
All entered data is right padded with spaces to 4 times its set size
Expected Results:
Spaces shouldn't have been added
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Base gives an error on trying to fill records in a form using a list box
linking to that column. Giving this error message:
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -303
*arithmetic exception, numeric overflow, or string truncation
*string right truncation
*expected length 3, actual 12
caused by
'isc_dsql_execute'
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-IE (en_IE); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
