[Libreoffice-bugs] [Bug 126799] New: MYSQL/MariaDB native connector: Unknown Column Type "Text" in GUI when opening a Table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126799

            Bug ID: 126799
           Summary: MYSQL/MariaDB native connector: Unknown Column Type
                    "Text" in GUI when opening a Table
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

Connect to MariaDB with the native connector, which is included in LO 6.3.0.4.

Start this commands in Tools > SQL

CREATE TABLE strtest (d TEXT(10));
INSERT INTO strtest VALUES('Maria   ');

You could also write down 
SELECT * FROM strtest;
... and let you show the output - works.

Now try to open the table in the table-view of the GUI. Could be you have to
refresh the tables by View > Refresh Tables.

An error appears:
"Unknown column type when fetching result"

The data-type TEXT isn't known by the GUI. So it isn't possible to see data or
input data into such a column by the GUI, only by Tools > SQL.

All tested with LO 6.3.0.4, OpenSUSE 15 64bit rpm Linux, 10.2.22-MariaDB -
openSUSE package

-- 
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/20190809/635309bf/attachment-0001.html>