[dba-issues] [Issue 113684] Oobase crashes opening a tablie witch VARCHAR 1023 characters (MySQL and ODBC)

2010-08-08 Thread mkotlin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113684


User mkotlin changed the following:

What|Old value |New value

 Summary|Oobase crashes when I try |Oobase crashes opening a t
|to open some table in MySQ|ablie witch VARCHAR  1023
|L (with ODBC) | characters (MySQL and ODB
|  |C)





-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 113684] Oobase crashes when I try to open some table in MySQL (with ODBC)

2010-08-07 Thread mkotlin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113684





--- Additional comments from mkot...@openoffice.org Sat Aug  7 14:02:04 
+ 2010 ---
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.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 113684] Oobase crashes when I try to open some table in MySQL (with ODBC)

2010-08-05 Thread mkotlin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113684
 Issue #|113684
 Summary|Oobase crashes when I try to open some table in MySQL 
|(with ODBC)
   Component|Database access
 Version|OOo 3.2
Platform|All
 URL|
  OS/Version|All
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P4
Subcomponent|MySQL Connector/OOo
 Assigned to|dbaneedsconfirm
 Reported by|mkotlin





--- Additional comments from mkot...@openoffice.org Thu Aug  5 12:28:48 
+ 2010 ---
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.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[dba-issues] [Issue 113684] Oobase crashes when I try to open some table in MySQL (with ODBC)

2010-08-05 Thread mkotlin
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113684





--- Additional comments from mkot...@openoffice.org Thu Aug  5 12:39:26 
+ 2010 ---
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`
--

/*!4 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,
plt;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