Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | OOo/MySQL combo hangs (with high CPU loads) when defining (certain SQL) queries | ||
---|---|---|---|
Product: | Base | Reporter: | novacek <novacek> |
Component: | code | Assignee: | Frank Schönheit <frank.schoenheit> |
Status: | CLOSED DUPLICATE | QA Contact: | issues@dba <issues> |
Severity: | Trivial | ||
Priority: | P1 (highest) | CC: | issues |
Version: | OOo 1.1 | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
novacek
2003-10-22 22:47:43 UTC
Alfred, thanks for reporting this. For tracking the issue down, can you please have a look at your ODBC logs when the query is executed? I strongly suppose that you will see something like ... HAVING 0 = 1 in the logs. If so, you're runnig into issues 18040/18039. The symptom is described in issue 18039, the reason in issue 18040. There's no workaround for this problem, yet. But since it hits everybody who uses a GROUP BY with a halfway larger MySQL table, we could probably fix this for 1.1.1. Thank You very much, Frank, for Your fast reply. The ODBC Log showed clearly, the query got rewritten as described in issues 18040/18039 (at least on Windows; on Linux, the query texts got truncated before the interresting parts), and the description of issue 18039 already sounded very familiar to me. Let's hope we don't have to wait too long for 1.1.1 :-) (skimming IssueZilla, I just found other issues 21024/20040 describing another problem I just wanted to report, telling it probably will be fixed in 1.1.1 too). Thank You very much - Alfred P.S.: With this posting, I am closing this issue by marking this issue as a duplicate to 18039 (which most closely describes the problem I observed first). *** This issue has been marked as a duplicate of 18039 *** change subcomponent to 'none' close issue. |