https://bugs.freedesktop.org/show_bug.cgi?id=78407
Priority: medium
Bug ID: 78407
Assignee: [email protected]
Summary: mysql-connector-ooo.oxt version 1.0.2 locks up when
executing single small table query
Severity: blocker
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.3.3 release
Component: Extensions
Product: LibreOffice
On a Windows 7 Prof machine with 16 GB RAM, local MySQL DB, local Libre Office:
The special information is that there are 120+ schema, each with 100+ tables
and 75+ views. All but 5 of the schema have the same table names and view
names.
When connecting, the login used has SELECT, EXECUTE and SHOW DATABASES
privileges.
I used the TCP connect method on the actual IP of the local machine.
All the schema display after a minute or so after clicking on the Tables
button.
Then, I click on the Queries button and click on Create Query in SQL View...
and enter "SELECT * FROM prexshared.mrmenu;" and click on the Run Query button
and it locks up.
This is a small table of about 600 rows containing the menu entries for our
application.
I was testing a small table before attempting to view content from a
cross-120+schema view of aged balances - a view that takes about 30 minutes to
return rows when executed at the mysql command line client prompt.
I tested this using the 32-bit MySQL ODBC Connector version 5.1 as well and
encounter the same issues. - The schema, tables and views appear, but it locks
up on the simplest execution of a query.
All other connections to the database continued to work even when LibreOffice
locked up. (MySQL Administrator, MySQL Command Line Client and using the linux
command line client from a remote server and for other users accessing the data
via ODBC using Microsoft Query tools for MS Office)
I am hoping this can be fixed, since the Microsoft Query tools are failing on
certain workstations when accessing that large aged balances view mentioned
above.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
