https://bugs.documentfoundation.org/show_bug.cgi?id=145205
Bug ID: 145205
Summary: Errormessage when I try to open a certain database
table via LibreOffice 7.2 Database.
Product: LibreOffice
Version: 7.2.0.0.alpha0+
Hardware: Other
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
On Ubuntu 20.04 LTS, I am using MySQL 8 and I have build many Databases
already.
Today I was accessing these databases, but there is a problem opening/viewing a
table. The table causing an error via LibreOffice 7.2 was created with the
following "Create Table" statement:CREATE TABLE Leverancieren (ID smallint(5)
unsigned NOT NULL AUTO_INCREMENT,Tllr mediumint(8) unsigned NOT NULL,X bit(1)
DEFAULT NULL,Naam varchar(28) NOT NULL,Straat_ID mediumint(9) NOT NULL,Huisnr
varchar(7) NOT NULL,Busnr varchar(6) DEFAULT NULL,PostcodeGemeente_ID
smallint(5) unsigned NOT NULL,Bedrijvigheid varchar(50) DEFAULT NULL,TelGSM
varchar(12) DEFAULT NULL,website varchar(54) DEFAULT NULL,Overschrijvingnr
varchar(14) DEFAULT NULL,PRIMARY KEY (ID),KEY Tllr (Tllr),KEY Straat_ID
(Straat_ID),KEY PostcodeGemeente_ID (PostcodeGemeente_ID));
Is it "X bit(1) DEFAULT NULL" that leads to a problem?
Is LibreOffice 7.2 not completely compatible with MySQL?
Steps to Reproduce:
1.Create a database and table with given Create statement in MySQL 8
2.Access that database and table via a direct LibreOffice 7.2 Database
connection.
3.
Actual Results:
Following error-screen appears:
LibreOffice Base
The data content could not be loaded. /build/libreoffice/-
parts/libreoffice/build/connectivity/source/commontools/-
dbtools.cxx:751
Unknown column type when fetching result ...
Expected Results:
Normal opening of the mentioned table.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug.
