https://bugs.documentfoundation.org/show_bug.cgi?id=145714
Bug ID: 145714
Summary: With the direct MySQL connector in Base, the
mediumblob fields (images) are shown as Text[VARCHAR].
Product: LibreOffice
Version: 6.0 all versions
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When editing a MySQL table (accessed with the direct MySQL connector) in Base,
the mediumblob fields are shown as Text[VARCHAR] instead of Image[MEDIUMBLOB].
Steps to Reproduce:
1. Use the direct MySQL connector to access MySQL.
2. Use Base SQL tool to :
CREATE TABLE `test-blobs` (
`ID` int NOT NULL AUTO_INCREMENT,
`Name` varchar(50) DEFAULT NULL,
`Photo1` longblob,
`Photo2` mediumblob,
`Photo3` blob,
PRIMARY KEY (`ID`) )
3. click on Tables, select the table just created, right click to "edit"
Actual Results:
all fields are shown as expected, except the mediumblob field (Photo2) which is
shown as Text[VARCHAR].
Expected Results:
all fields are shown as expected, including the mediumblob field (Photo2) which
is shown as Image[MEDIUMBLOB].
Reproducible: Always
User Profile Reset: No
Additional Info:
Note : This problem only happens if the connector to the external MySQL is
direct. It does if happen if the connector is MySQL-jdbc.
--
You are receiving this mail because:
You are the assignee for the bug.
