https://bugs.freedesktop.org/show_bug.cgi?id=82336
Priority: medium
Bug ID: 82336
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: CRASH - executing mysql left outer join query on
multiple tables
Severity: blocker
Classification: Unclassified
OS: Mac OS X (All)
Reporter: ipla...@yahoo.co.uk
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Database
Product: LibreOffice
Attempting to execute a multi-table LEFT OUTER JOIN query to a mysql instance
via the native mysql connector causes LO to crash immediately.
If the Query mode button on the main database window is clicked first, and then
the query itself double-clicked to start it (request for login, then execution
of query), LO goes into beachball mode, procesor occupation goes up to 70% and
stays there until the application is forcibly killed. The query never gets
displayed.
The same query runs from a terminal against a local mysql instance in 0.08s and
returns 636 results.
The query is as follows :
SELECT * from ipgalore as t1 LEFT OUTER JOIN (priority as t2,owner_list as
t3,inventor_list as t4) ON (t2.fmpro_id = t1.fmpro_id AND t3.fmpro_id =
t1.fmpro_id AND t4.fmpro_id = t1.fmpro_id)
The same query runs almost instantly with LO 4233.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
