[Libreoffice-bugs] [Bug 138394] New: truncated CLOB data

[bugzilla-daemon at bugs.documentfoundation.org]

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>