Apache OpenOffice (AOO) Bugzilla – Issue 113684
Oobase crashes opening a tablie witch VARCHAR > 1023 characters (MySQL and ODBC)
Last modified: 2010-10-15 12:33:27 UTC
I connect with ODBC to database located on MySQL server installed on my computer. Mysql version: Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 When I try to open one of my tables OpenOffice crashes. It crashes also when I try to use this table in report, etc. I tested it on my Linux box with OpenOffice and on Windows 7 x64 box. Windows box uses MySQL 5.1 ODBC driver linux use Unix ODBC. Both computers have installed 00o 3.2.0.
I can't post a attachement, so I paste SQL of the problematic table here. -- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.51a-24+lenny2-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema drlit -- CREATE DATABASE IF NOT EXISTS drlit; USE drlit; -- -- Definition of table `drlit`.`publikacje` -- DROP TABLE IF EXISTS `drlit`.`publikacje`; CREATE TABLE `drlit`.`publikacje` ( `ID` int(10) unsigned NOT NULL auto_increment, `PMID` int(11) default NULL, `OWN` varchar(32) default NULL, `STAT` varchar(32) default NULL, `DA` varchar(32) default NULL, `IS` varchar(32) default NULL, `VI` varchar(32) default NULL, `IP` varchar(32) default NULL, `DP` varchar(32) default NULL, `TI` varchar(512) default NULL, `PG` varchar(32) default NULL, `AB` varchar(4096) default NULL, `AD` varchar(512) default NULL, `FAU` varchar(1024) default NULL, `AU` varchar(512) default NULL, `LA` varchar(16) default NULL, `PT` varchar(32) default NULL, `TT` varchar(255) default NULL, `DEP` varchar(32) default NULL, `TA` varchar(64) default NULL, `JT` varchar(256) default NULL, `JID` varchar(32) default NULL, `EDAT` varchar(32) default NULL, `MHDA` varchar(32) default NULL, `CRDT` varchar(32) default NULL, `PHST` varchar(512) default NULL, `AID` varchar(64) default NULL, `PST` varchar(32) default NULL, `SO` varchar(64) default NULL, `Rozdz` varchar(64) default NULL, `Uwagi` text, `PDF` longblob, `Supl1` longblob, `Supl2` longblob, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=247 DEFAULT CHARSET=utf8; -- -- Dumping data for table `drlit`.`publikacje` -- /*!40000 ALTER TABLE `publikacje` DISABLE KEYS */; LOCK TABLES `publikacje` WRITE; INSERT INTO `drlit`.`publikacje` VALUES (244,20680102,'NLM','In-Data-Review','20100803','1090-0535 (Electronic); 1090-053','16',NULL,'2010','Aqueous humor neutrophil gelatinase-associated lipocalin levels in patients with idiopathic acute anterior uveitis.','1448-52','PURPOSE: The purpose of this study was to evaluate the levels of neutrophil gelatinase-associated lipocalin (NGAL) in the aqueous humor in eyes with idiopathic acute anterior uveitis (AAU). METHODS: A comparative control study. Aqueous humor was collected from 20 eyes of 20 patients with idiopathic AAU. The control group included 20 aqueous samples from 20 patients about to undergo cataract surgery and without any other ocular or systemic diseases. The level of NGAL was determined with a commercially available ELISA kit. RESULTS: The concentration of NGAL in aqueous humor was markedly higher in patients with idiopathic AAU than in control subjects (Mann-Whitney U test, p<0.001). The level of NGAL was 139,197.38+/-183,426.36 (mean+/-SD) pg/ml in eyes with AAU and 3,169.96+/-1,595.78 pg/ml in the eyes of the control group. CONCLUSIONS: The aqueous humor NGAL level is increased in eyes with idiopathic AAU. These results imply that NGAL is associated with the regulation of inflammation in patients with AAU and could be used as a biomarker of ocular inflammation and immunomodulatory treatment response.',NULL,'Salom, David; Sanz-Marco, Empar; Mullor, Jose L; Lopez-Prats, Maria Jesus; Garcia-Delpech, Salvador; Udaondo, Patricia; Millan, Jose Maria; Arevalo, J Fernando; Diaz-Llopis, Manuel','Salom D; Sanz-Marco E; Mullor JL; Lopez-Prats MJ; Garcia-Delpech S; Udaondo P; Millan JM; Arevalo JF; Diaz-Llopis M','eng','Journal Article',NULL,'20100729','Mol Vis','Molecular vision','9605351','2010/08/04 06:00','2010/08/04 06:00','2010/08/04 06:00','2010/06/16 [received]; 2010/07/23 [accepted]; 2010/07/29 [epublish]',NULL,'epublish','Mol Vis. 2010 Jul 29;16:1448-52.',NULL,NULL,NULL,NULL,NULL), (246,20676813,'NLM','Publisher','20100802','1615-6714 (Electronic); 1434-529','71',NULL,'2010 Jul','Comparison of a Modified RME Appliance with Other Appliances for Transverse Maxillary Expansion.','265-272','AIM: : Plate appliances or fixed appliances for transverse expansion are used to treat lateral crossbites in early mixed dentition. The aim of this study was to compare these appliances\' dentoalveolar effects with those of a modified appliance with altered anchorage. PATIENTS AND METHODS: : Forty patients with early mixed dentition were examined. Twenty patients in the study group were treated with a modified RME appliance firmly anchored to the first permanent molars and with palatal rests in the first and second deciduous molar region. The appliance had wire extensions to the palatal aspects of the canines. One of the two comparison groups comprised 10 patients whose maxillary dental arch was transversally expanded with a split-plate appliance, and the other group contained 10 patients treated with a Hyrax-type rapid palatal expander fixed to the first permanent molars. After the plaster casts\' transverse parameters before and after expansion and after retention were measured to ascertain the treatment result, statistical analysis was performed applying the Wilcoxon test and Mann-Whitney U test. RESULTS: : The modified RME appliance expanded the anterior and posterior arch width highly significantly in transversal direction (p < 0.001). At the end of the retention phase, there were no significant differences between the modified RME appliance and the RME appliance with shortened arms. Compared to the splitplate appliance, the modified RME (p < 0.05) expanded the anterior arch width significantly. CONCLUSION: : The modified RME appliance can be used effectively for rapid maxillary expansion in the early mixed dentition. At the end of the retention phase, the overall effect of the modified appliance is similar to that of the other methods.','Department of Orthodontics, University Hospital Saarland, Homburg/Saar, Germany, catharina.weyrich@uks.eu.',NULL,'Weyrich C; Noss M; Lisson JA','ENG','JOURNAL ARTICLE','Vergleich einer modifizierten GNE-Apparatur mit weiteren Apparaturen zur Transversalerweiterung der Maxilla.','20100730','J Orofac Orthop','Journal of orofacial orthopedics = Fortschritte der Kieferorthopadie : Organ/official journal Deutsche Gesellschaft fur Kieferorthopadie','9713484','2010/08/03 06:00','2010/08/03 06:00','2010/08/03 06:00','2009/12/04 [received]; 2010/04/29 [accepted]; 2010/07/30 [aheadofprint]','10.1007/s00056-010-9945-7 [doi]','ppublish','J Orofac Orthop. 2010 Jul;71(4):265-272. Epub 2010 Jul 30.',NULL,NULL,NULL,NULL,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `publikacje` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
I can confirm it on win7 32 bit, with OOo 3.2.1 and OOO330_m2 (and with DEV300_m86), only in case of ODBC connection. MySQL 5.1.44, ODBC driver 5.1.6. When click on table, OOo crash. Crash report number with OOo 3.2.1: rdvw6fn Crash reporter not active on OOO330_m2. If I use JDBC or MySQL native driver no crash. Changed subcomponent. Assign developer.
I did some testing and detected the difference between "oobase crashing tables" :) and non crashing tables. Oobase crashes when trying to open table containing VARCHAR column that contains more tan 1023 characters of text. If the VARCHAR column is longer than 1023, but there is less than 1024 characters of data inside all rows of table, oobase works normally.
Created attachment 71526 [details] stripped SQL script to create a table exposing the problem
a crash is certainly not a P4 => adjusting prio to P2
grabbing
fixed in CWS dba33i find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba33i
fs->msc: please verify in CWS dba33i
verified in CWS dba33i find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300/dba33i
Checked in OOO330m10, Ok. Closing.