[Libreoffice-bugs] [Bug 143895] New: Mysql MEDIUMINT data type but interpreted correctly by Base table definition

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 143895
           Summary: Mysql MEDIUMINT data type but interpreted correctly by
                    Base table definition
           Product: LibreOffice
           Version: 7.0.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: farley.at.paradise at gmail.com

UI
I have a MySql database which I have successfully accessed via Base and
successfully created a form over.
I noticed one numeric column truncates to a value of 32,767. That column in the
MySql database is MEDIUMINT but Base has defaulted to SMALLINT.
If I edit the table definition in Base for that column to (what seems a valid)
value of MEDIUMINT, it is not accepted.
If I edit the table definition in Base for that column to value of INTEGER, it
is accepted.

-- 
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/20210816/b16370c9/attachment.htm>