https://bugs.freedesktop.org/show_bug.cgi?id=65630
Priority: medium
Bug ID: 65630
Assignee: [email protected]
Summary: CRASH - opening mysql table using native mysql C
connector causes LO to crash
Severity: major
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Database
Product: LibreOffice
For some reason, as yet unknown, the following mysql table causes LO to crash
when it is opened (double click) or previewed in the "Document preview" mode.
LO is configured to access the database via the native mysql C connector. All
other tables in the database can be opened or previewed without crashing.
This occurs in 4.0.2.2 production release and my master 4.2 build.
It is a regression over LO 3.3.4, OOo 3.2.1, and OOo 3.3.0 which use
corresponding earlier versions of the connector (1.0.0 for OOo 3.2.1, and 1.0.1
for OOo 3.3.0, and LO 3.3.4). In these versions, I can access the table in
Document Preview or direct open and there is no crash, all data is displayed.
The table definition is as follows :
CREATE TABLE `old_oldfmpro` (
`Agent` varchar(254) DEFAULT NULL,
`Ann_Fees1` date DEFAULT '0000-00-00',
`Ann_Fees` varchar(254) DEFAULT NULL,
`Attention` varchar(254) DEFAULT NULL,
`Client` varchar(254) DEFAULT NULL,
`Client_Copy` varchar(254) DEFAULT NULL,
`Code` varchar(254) DEFAULT NULL,
`Comments` varchar(254) DEFAULT NULL,
`Ctry_Short` varchar(254) DEFAULT NULL,
`Prio_Ctry` varchar(254) DEFAULT NULL,
`Prio_Ctry1` char(2) DEFAULT '',
`Prio_Ctry2` char(2) DEFAULT '',
`Prio_Ctry3` char(2) DEFAULT '',
`Prio_Ctry4` char(2) DEFAULT '',
`Prio_Ctry5` char(2) DEFAULT '',
`Prio_Ctry6` char(2) DEFAULT '',
`Ctry_List` varchar(254) DEFAULT NULL,
`Docket_Num` varchar(254) DEFAULT NULL,
`Earliest_Date` varchar(254) DEFAULT NULL,
`Earliest_Date1` date DEFAULT '0000-00-00',
`Exp_Date` varchar(254) DEFAULT NULL,
`Exp_Date1` date DEFAULT '0000-00-00',
`File_Code` varchar(254) DEFAULT NULL,
`File_Code_Copy` varchar(254) DEFAULT NULL,
`File_Num` varchar(254) DEFAULT NULL,
`Filing_Num` varchar(254) DEFAULT NULL,
`Filing_Date1` date DEFAULT '0000-00-00',
`Filing_Date` varchar(254) DEFAULT NULL,
`Grant_Num` varchar(254) DEFAULT NULL,
`Grant_Date` varchar(254) DEFAULT NULL,
`Grant_Date1` date DEFAULT '0000-00-00',
`Inventors` varchar(254) DEFAULT NULL,
`Inventor1` varchar(50) DEFAULT '',
`Inventor2` varchar(50) DEFAULT '',
`Inventor3` varchar(50) DEFAULT '',
`Inventor4` varchar(50) DEFAULT NULL,
`Inventor5` varchar(50) DEFAULT '',
`Inventor6` varchar(50) DEFAULT '',
`Inventor7` varchar(50) DEFAULT '',
`Inventor8` varchar(50) DEFAULT '',
`Inventor9` varchar(50) DEFAULT '',
`Inventor10` varchar(50) DEFAULT '',
`Keywords` varchar(254) DEFAULT NULL,
`Next_Date` varchar(254) DEFAULT NULL,
`Next_Date1` date DEFAULT '0000-00-00',
`Next_Date2` date DEFAULT '0000-00-00',
`Next_Date3` date DEFAULT '0000-00-00',
`Next_Date4` date DEFAULT '0000-00-00',
`Next_Date5` date DEFAULT '0000-00-00',
`Next_Date_Country` varchar(254) DEFAULT NULL,
`Next_Date_Country1` date DEFAULT NULL,
`Next_Month_AF` varchar(254) DEFAULT NULL,
`Next_M_Next_Date` varchar(254) DEFAULT NULL,
`Next_M_Next_Date1` date DEFAULT NULL,
`Our_Ref` varchar(254) DEFAULT NULL,
`Owner1` varchar(254) NOT NULL DEFAULT '',
`Owner2` varchar(254) DEFAULT NULL,
`Owner3` varchar(100) DEFAULT '',
`Owner4` varchar(100) DEFAULT '',
`Owner5` varchar(100) DEFAULT '',
`Owner6` varchar(100) DEFAULT '',
`Owner7` varchar(100) DEFAULT '',
`Owner8` varchar(100) DEFAULT '',
`Owner9` varchar(100) DEFAULT '',
`Owner10` varchar(100) DEFAULT '',
`Patent_Countries` varchar(254) DEFAULT NULL,
`Prio_SN` varchar(254) DEFAULT NULL,
`Prio_SN2` varchar(30) DEFAULT NULL,
`Prio_SN3` varchar(30) DEFAULT NULL,
`Prio_SN4` varchar(30) DEFAULT NULL,
`Prio_SN5` varchar(30) DEFAULT NULL,
`Prio_SN6` varchar(30) DEFAULT NULL,
`Prio_SN7` varchar(30) DEFAULT NULL,
`Prio_SN8` varchar(30) DEFAULT NULL,
`Prio_FF_Date` varchar(254) DEFAULT NULL,
`Prio_FF_Date1` date DEFAULT '0000-00-00',
`Prio_FF_Date2` date DEFAULT '0000-00-00',
`Prio_FF_Date3` date DEFAULT '0000-00-00',
`Prio_FF_Date4` date DEFAULT '0000-00-00',
`Prio_FF_Date5` date DEFAULT '0000-00-00',
`Prio_FF_Date6` date DEFAULT '0000-00-00',
`Prio_FF_Date7` date DEFAULT '0000-00-00',
`Prio_FF_Date8` date DEFAULT '0000-00-00',
`Pub_Num` varchar(254) DEFAULT NULL,
`Pub_Date` varchar(254) DEFAULT NULL,
`Pub_Date1` date DEFAULT '0000-00-00',
`Related_Files` varchar(254) DEFAULT NULL,
`Report_Date` varchar(254) DEFAULT NULL,
`Report_Date1` date DEFAULT '0000-00-00',
`Summary` varchar(254) DEFAULT NULL,
`Update_Num` varchar(254) DEFAULT NULL,
`What` varchar(254) DEFAULT NULL,
`What1` varchar(50) DEFAULT '',
`What2` varchar(50) DEFAULT '',
`What3` varchar(50) DEFAULT '',
`What4` varchar(50) DEFAULT '',
`What5` varchar(50) DEFAULT '',
`Who` varchar(254) DEFAULT NULL,
`Y_ref` varchar(254) DEFAULT NULL,
`State_dep` varchar(254) DEFAULT NULL,
`State_dep_num` varchar(254) DEFAULT NULL,
`chg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
`fmpro_id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`pay_ann_fee` char(1) NOT NULL DEFAULT '',
PRIMARY KEY (`fmpro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Alex
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
