[Libreoffice-bugs] [Bug 132515] 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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
            Version|6.4.3.2 release             |6.3.0.4 release
     Ever confirmed|0                           |1
           Severity|normal                      |enhancement
                 CC|                            |robert at familiegrosskopf.de

--- Comment #5 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to hojp from comment #0)

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

Before LO 6.2 there hasn't been a native connector integrated in LO. So could
be you used the special connector of your system. There have been extensions
for this connector, but they weren't available for every system.

I could connect to a table with the Column Type 'year' in LO up to LO 6.3 - but
I can#t insert any values on a table up to this version and the content isn't
shown right. Since LO 6.3 I get the error-message you also get, because the
native connector doesn't know anything about the column type 'year'.

If you try it with JDBC it will show 'date' for this column and couldn't enter
data. And with ODBC it will show 'smallint' for this column - the only working
connection for this field type.

I will set this bug to new, switch the version to LO 6.3 and set it as a ask
for an enhancement, because there is no datatype available with any connection
to MariaDB/MySQL for the special tape 'year'.

Tested all with different LO-Versions. First Version with this error was LO
6.3, but before this version it was impossible to add data to a table with the
native connector here. Tested with OpenSUSE 15.1 64bit rpm Linux.

-- 
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/20200501/bb7bd733/attachment.htm>