[Libreoffice-bugs] [Bug 138394] New: truncated CLOB data
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Nov 21 16:52:12 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=138394
Bug ID: 138394
Summary: truncated CLOB data
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: trowelandmattock at yahoo.co.uk
Description:
CLOB fields which are larger than standard VARCHAR max do not display correctly
in LO - they appear to be truncated to VARCHAR max, eg in form text-fields, and
(unsurprisingly) in calc cells....
...since there is also an issue exporting .csv directly from Base+Firebird
(oops-lost link) this becomes a potentially big issue>>
ie: CLOB fields larger than VARCHAR max may become truncated and irrecoverable
by 'normal' means !!! :O
(perhaps a LO project could be fully reconstructed in external DB...but not
exactly for the standard user)
Steps to Reproduce:
1.make CLOB larger than VARCHAR max
2.try to extract or view....:/
3...sadly macro based.csv export also dosn't appear to work in LO-Firebird, so
stuck with truncation
Actual Results:
large CLOB truncated
Expected Results:
large CLOB not truncated :)
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
a .csv/text export would be great, But relevant SQL not working for firebird in
LO---
of course large CLOBS are not necessarily 'everyday' issue,but seems potential
serious data loss issue here...
...if LO-firebird CLOBS can not be fixed, maybe they need 'removing' or have a
BIG 'use-with-care' warning slapped on them !
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201121/1b9c9fe3/attachment.htm>
More information about the Libreoffice-bugs
mailing list