[Bug 119368] New: MySQL ODBC Connector 5.1.8 works, 5.1.11 crashes OpenOffice on table view

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119368

          Priority: P3
            Bug ID: 119368
                CC: ooo-issues@incubator.apache.org
          Assignee: needsconfirm@dba.openoffice.org
           Summary: MySQL ODBC Connector 5.1.8 works, 5.1.11 crashes
                    OpenOffice on table view
          Severity: normal
        Issue Type: DEFECT
    Classification: Application
                OS: Windows XP
          Reporter: dlindley@morristech.com
          Hardware: PC
            Status: UNCONFIRMED
           Version: OOo 3.4 Beta
         Component: MySQL Connector/OOo
           Product: database access

We have a MySQL database and were attempting to install our typical frontend
(OpenOffice base with MySQL ODBC Connector) on a new machine.  Everything
worked fine, we were able to see the tables on the chosen database, but when
attempting to view the data in the tables, OpenOffice crashes.  This was using
the MySQL ODBC Connector version 5.1.11, and the problem was solved by using
version 5.1.8.  I will post a bug report with the MySQL people as well, but I
was able to use HeidiSQL and a proprietary python program with the 5.1.11
connector with no issues, so I suspect that the problem may lay with
OpenOffice.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 119368] MySQL ODBC Connector 5.1.8 works, 5.1.11 crashes OpenOffice on table view

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119368

r4zoli <r4...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |r4zoli@apache.org

--- Comment #1 from r4zoli <r4...@apache.org> ---
For me the ODBC Connector 5.1.11 versions works with AOO 3.4 under windows 7.
No crash when open table. I connected to MySQL 5.1.16 installed as localhost.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 119368] MySQL ODBC Connector 5.1.8 works, 5.1.11 crashes OpenOffice on table view

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119368

--- Comment #5 from Dustin Lindley <dl...@morristech.com> ---
Sorry, I didn't know it was related to long table names initially, it was
suggested by a developer that it might be similar to another bug that had been
reported that had to do with long names.  If you look at
http://bugs.mysql.com/65341, you'll see that I posted nearly the same
information in both bug reports.

In any case, you're right, it's their bug.  Thanks for the work to reproduce.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 119368] MySQL ODBC Connector 5.1.8 works, 5.1.11 crashes OpenOffice on table view

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119368

Dustin Lindley <dl...@morristech.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED

--- Comment #2 from Dustin Lindley <dl...@morristech.com> ---
I'm assuming you meant ADO, and I was having problems with the ODBC driver.  In
any case, the bug has been confirmed over at the MySql group, and I was able to
fix the problem by using Connector 5.1.8.  Here's my bug report,
http://bugs.mysql.com/65341, and a related one,
http://bugs.mysql.com/bug.php?id=65200.

I'll also keep in mind using the ADO connector, but for the time being this one
is solved.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 119368] MySQL ODBC Connector 5.1.8 works, 5.1.11 crashes OpenOffice on table view

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119368

r4zoli <r4...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|FIXED                       |INVALID

--- Comment #3 from r4zoli <r4...@apache.org> ---
You not provided enough information, the ODBC 5.1.11 connection worked for me.
In original post you not mentioned long table names, only crash, which I can
not reproduce, in my MySQL-AOO setup.

If I create this table (code from MySQL bugreport 65200), in JDBC connected
MySQL, the table crated:

CREATE TABLE `thisisaverylongtablename` (
  `idthisisaverylongtablename` int(11) NOT NULL,
  `thisisaverylongtablenamecol` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`idthisisaverylongtablename`)
);

If I connect to same database with ODBC 5.1.11 connection the AOO 3.4 crash.

The crash caused by ODBC driver, this is out of AOO responsibility.

I set the status to invalid.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

[Bug 119368] MySQL ODBC Connector 5.1.8 works, 5.1.11 crashes OpenOffice on table view

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=119368

r4zoli <r4...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

--- Comment #4 from r4zoli <r4...@apache.org> ---
invalid -> closing.

-- 
You are receiving this mail because:
You are on the CC list for the bug.