[Libreoffice-bugs] [Bug 132515] New: MYSQL/MariaDB native connector: Unknown Column Type when opening table

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132515
           Summary: MYSQL/MariaDB native connector: Unknown Column Type
                    when opening table
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jphorst at sciencebridge.de

When opening a table for viewing (similar when opening a form or query on this
table) the following error is shown:

"Unknown column type when fetching result"

The problem seems to be a column of the type year(4)


MariaDB [projekte]> show columns from rueckfluesse;
+------------------------+----------------------+------+-----+---------+----------------+
| Field                  | Type                 | Null | Key | Default | Extra 
        |
+------------------------+----------------------+------+-----+---------+----------------+
| Buchungsjahr           | year(4)              | YES  |     | 0000    |       
        |

(LO shows the column definition as TEXT[VARCHAR]) 

This problem does not occur with LO 6.0.7.3 (same base file and same database).

-- 
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/20200429/39b8b301/attachment.htm>