You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/08/24 15:51:36 UTC
[Bug 120706] New: CRASH - navigating tables containing NULL
timestamps in DataSourceBrowser using mysql JDBC connector causes AOO to
crash
https://issues.apache.org/ooo/show_bug.cgi?id=120706
Priority: P3
Bug ID: 120706
CC: ooo-issues@incubator.apache.org
Assignee: needsconfirm@dba.openoffice.org
Summary: CRASH - navigating tables containing NULL timestamps
in DataSourceBrowser using mysql JDBC connector causes
AOO to crash
Severity: critical
Issue Type: DEFECT
Classification: Application
OS: Mac OSX, all
Reporter: iplaw67@yahoo.co.uk
Hardware: Mac
Status: UNCONFIRMED
Version: AOO 3.4.0
Component: none
Product: database access
Created attachment 79131
--> https://issues.apache.org/ooo/attachment.cgi?id=79131&action=edit
Apple crash trace
Using AOO 341 Rev 1372282 (13/08/2012)
OS : Mac OSX 10.8 Mountain Lion
Mysql ConnectorJ : 5.1.21
1) Create an ODB file configured to connect to a mysql server using the JDBC
connector.
2) Register the ODB file with the Office.
3) The mysql database contains at least 4 tables, some of which contain NULL
value timestamps, i.e. "0000-00-00 00:00:00"
4) Now, start AOO, open a new Writer Text Document
5) Press F4 (fn+F4 on Macbook), to open the DataSourceBrowser (DSB)
6) Select the registered database from the list in the left window pane, and
enter any id/password details as necessary to establish a connection to the
mysql database.
7) Now, click on the Tables entry in the tree hierarchy and select the first
table.
8) If this table contains NULL timestamp values, an error message appears
saying that the table can't be displayed. Click on 'OK'
9) Use the navigation arrow "down" to move down to the next table. Click on
'OK' each time the error message appears.
10) When you get to the fourth table, AOO will crash without warning.
Crash trace attached.
Alex
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 120706] CRASH - navigating tables containing NULL timestamps in
DataSourceBrowser using mysql JDBC connector causes AOO to crash
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120706
iplaw67@yahoo.co.uk changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P3 |P2
--- Comment #1 from iplaw67@yahoo.co.uk ---
See also :
https://bugs.freedesktop.org/show_bug.cgi?id=37529
--
You are receiving this mail because:
You are on the CC list for the bug.
[Bug 120706] CRASH - navigating tables containing NULL timestamps in
DataSourceBrowser using mysql JDBC connector causes AOO to crash
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120706
liupingtan <do...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
QA Contact| |alex13qa@gmail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 120706] CRASH - navigating tables containing NULL timestamps in
DataSourceBrowser using mysql JDBC connector causes AOO to crash
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120706
Yurggent Alfredo Chable Torrez <yu...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
QA Contact|yurggent1.791@gmail.com |
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 120706] CRASH - navigating tables containing NULL timestamps in
DataSourceBrowser using mysql JDBC connector causes AOO to crash
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120706
liupingtan <do...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
QA Contact|alex13qa@gmail.com |kschenk@apache.org
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 120706] CRASH - navigating tables containing NULL timestamps in
DataSourceBrowser using mysql JDBC connector causes AOO to crash
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120706
liupingtan <do...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
QA Contact|kschenk@apache.org |yurggent1.791@gmail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
[Bug 120706] CRASH - navigating tables containing NULL timestamps in
DataSourceBrowser using mysql JDBC connector causes AOO to crash
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120706
--- Comment #2 from iplaw67@yahoo.co.uk ---
Tables to reproduce bug :
First table :
CREATE TABLE `action_type` (
`type` varchar(15) NOT NULL DEFAULT '',
`comments` varchar(40) DEFAULT NULL,
`action_type_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`chg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`action_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
Second table :
CREATE TABLE `address` (
`address_id` int(11) NOT NULL AUTO_INCREMENT,
`LNAME` varchar(35) DEFAULT NULL,
`FNAME` varchar(35) DEFAULT NULL,
`TITLE` varchar(35) DEFAULT NULL,
`COMPANY` varchar(35) DEFAULT NULL,
`COADDR1` varchar(50) NOT NULL DEFAULT '',
`COADDR2` varchar(50) DEFAULT NULL,
`COADDR3` varchar(50) DEFAULT NULL,
`COCITY` varchar(35) NOT NULL DEFAULT '',
`COSTATE` varchar(35) DEFAULT NULL,
`COZIP` varchar(12) DEFAULT NULL,
`COCOUNTRY` varchar(35) NOT NULL DEFAULT '',
`SALUT` varchar(20) DEFAULT NULL,
`CUSTOM3` varchar(35) DEFAULT NULL,
`TEL1` varchar(40) DEFAULT NULL,
`FAX1` varchar(40) DEFAULT NULL,
`FAX2` varchar(40) DEFAULT NULL,
`MOBILE` varchar(40) DEFAULT NULL,
`EMAIL` varchar(75) DEFAULT NULL,
`WEBSITE` varchar(75) DEFAULT NULL,
`NOTES` mediumtext,
`chg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`address_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Third table :
CREATE TABLE `applicant` (
`applicant_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`applicant_short` char(3) NOT NULL DEFAULT '',
`applicant_long` varchar(30) NOT NULL DEFAULT '',
`address_id` int(11) unsigned DEFAULT NULL,
`chg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`applicant_id`)
) ENGINE=MyISAM AUTO_INCREMENT=972 DEFAULT CHARSET=latin1
Fourth table :
CREATE TABLE `assistant` (
`assistant_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`assistant` varchar(7) NOT NULL DEFAULT '',
`chg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`assistant_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
--
You are receiving this mail because:
You are on the CC list for the bug.