incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 120706] CRASH - navigating tables containing NULL timestamps in DataSourceBrowser using mysql JDBC connector causes AOO to crash
Date Sat, 25 Aug 2012 09:16:54 GMT
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.

Mime
View raw message