Bug 129556 - Appending data to Firebird Base table with copied Calc range can be over the field length
Summary: Appending data to Firebird Base table with copied Calc range can be over the ...
Status: RESOLVED DUPLICATE of bug 108082
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.8.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-12-23 05:32 UTC by Nukool Chompuparn
Modified: 2020-01-08 11:48 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Calc with string length = 3 (30.32 KB, image/jpeg)
2019-12-23 05:34 UTC, Nukool Chompuparn 		Details
Base field length = 2 (49.36 KB, image/jpeg)
2019-12-23 05:35 UTC, Nukool Chompuparn 		Details
Firebird database table accepts Calc string length = 3 into field length = 2 (127.42 KB, image/jpeg)
2019-12-23 05:37 UTC, Nukool Chompuparn 		Details
But Queries found this error. (63.75 KB, image/jpeg)
2019-12-23 08:35 UTC, Nukool Chompuparn 		Details
View All 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 Nukool Chompuparn 2019-12-23 05:32:13 UTC 
Description:
Base field length = 2 can append data from string of Calc length = 3

Steps to Reproduce:
1.Copy a range of cell from Calc including first row as header
2.Paste into Base table
3.

Actual Results:
Base field length = 2 can append data from string of Calc length = 3

Expected Results:
In sample images, it should not be appended. 


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Nukool Chompuparn 2019-12-23 05:34:09 UTC 
Created attachment 156736 [details]
Calc with string length = 3
Comment 2 Nukool Chompuparn 2019-12-23 05:35:13 UTC 
Created attachment 156737 [details]
Base field length = 2
Comment 3 Nukool Chompuparn 2019-12-23 05:37:57 UTC 
Created attachment 156738 [details]
Firebird database table accepts Calc string length = 3 into field length = 2
Comment 4 Nukool Chompuparn 2019-12-23 08:35:27 UTC 
Created attachment 156740 [details]
But Queries found this error.
Comment 5 Alex Thurgood 2019-12-23 11:00:37 UTC 
VARCHAR fields are encoded by up to 4 bytes per character with UTF-8 in Firebird.
Depending on your charset, what you are experiencing is kind of to be expected.

https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-datatypes-chartypes.html
Comment 6 Alex Thurgood 2019-12-23 11:02:25 UTC 
The problem is getting the UI fixed char length to be respected when copying data over. Pretty sure that that is a duplicate of an already existing bug.
Comment 7 Robert Großkopf 2019-12-29 20:24:45 UTC 
Could be it is a duplicate of bug 108082. I have reopened this bug, because it will appear again with LO 6.3.4.2 on OpenSUSE.

I could append 8 characters to a field with a length of 2 characters defined in Firebird. Have tested it with importing this from Calc. Makes no difference while inserting this characters directly to Firebird table.

Could you please test this with your own database?
Comment 8 Alex Thurgood 2020-01-08 11:48:51 UTC 
Seems to me that this is a DUP of bug 108082

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