[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User amy2008 changed the following: What|Old value |New value Status|REOPENED |RESOLVED Resolution| |FIXED --- Additional comments from amy2...@openoffice.org Thu Apr 2 09:06:08 + 2009 --- Verified in OOo310m8 on WinXP - 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 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User amy2008 changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from amy2...@openoffice.org Thu Apr 2 09:06:54 + 2009 --- Verified and closing - 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 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User amy2008 changed the following: What|Old value |New value Status|VERIFIED |REOPENED Resolution|FIXED | --- Additional comments from amy2...@openoffice.org Wed Apr 1 02:43:40 + 2009 --- Odd. When right-click doesntwork choosing Edit in SQL view, there is an error dialog saying The communication to the data source escproc could not be established and the following is garbled. Pls take a look at it. - 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 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 --- Additional comments from amy2...@openoffice.org Wed Apr 1 02:50:39 + 2009 --- I just checked it using the attachment with OOo310m7 on WinXP - 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 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from [EMAIL PROTECTED] Tue Aug 19 11:27:36 + 2008 --- Please verify. Thanks. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 08:31:04 + 2008 --- Fixed in cws dba31b - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj Ever confirmed| |1 Status|UNCONFIRMED |NEW Priority|P3|P2 Target milestone|--- |OOo 3.1 --- Additional comments from [EMAIL PROTECTED] Mon Jul 28 11:52:00 + 2008 --- confirming, assigning, targeting - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 --- Additional comments from [EMAIL PROTECTED] Mon Jul 28 12:04:30 + 2008 --- fs-oj: there's two problems here: First, when a query is asked for its columns, its first approach is to use a SingleSelectQueryComposer. Only if this fails, a fallback to a prepared statement (and its result set meta data) is used. I suppose the proper solution here is to *not* use a query composer if the query's EscapeProcessing is set to FALSE. Second, the SingleSelectQueryComposer builds an SQL statement from the SELECT part of the underlying statement, a WHERE 0 = 1 condition, and the original GROUP BY clause. In particular, it completely drops the original where condition. Now the query in the example selects a cartesian product of three tables, but limits the results with a WHERE condition. The SingleSelectQueryComposer drops the WHERE condition, so what's left is a mere cartesian product over 3 very large tables - and this is *extremely* expensive. (Yes, in theory the Jet Engine could recognize and value the WHERE 0=1 condition, but obviously it doesn't.) So, I think we should first fix the Query implementation, which will make the bug here vanish. However, we should also fix the SingleSelectQueryComposer, to retain the original WHERE clause, else the bug might re-appear in other circumstances. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User fs changed the following: What|Old value |New value Attachment is patch| |Created an attachment (id= | |55409) suggested patch --- Additional comments from [EMAIL PROTECTED] Mon Jul 28 12:21:37 + 2008 --- Created an attachment (id=55409) suggested patch - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 Issue #|92164 Summary|Escape processing setting is ignored Component|Database access Version|1.0.0 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|newuser4 --- Additional comments from [EMAIL PROTECTED] Sat Jul 26 09:51:21 + 2008 --- Using an Odbc data source when running a query from the query panel escape processing setting is ignored. To reproduce the issue follow these steps: - open the attached file example; - select query panel; - right click on the query named doesntwork select run. On my system soffice.bin jumps to 98% cpu occupation and the only choice is to kill OpenOffice.org. Escape processing setting is recognized when: 1) opening the same query using Edit in SQL view, choosing then Run query; 2) creating the query using a syntax not supported by the internal SQL parser. An example of the same query with different syntax is the one named works which can be run from query panel. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 --- Additional comments from [EMAIL PROTECTED] Sat Jul 26 09:52:27 + 2008 --- Created an attachment (id=55376) Odb file to reproduce the issue - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 92164] Escape processing setting is ignored
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92164 User newuser4 changed the following: What|Old value |New value Version|1.0.0 |DEV300m26 --- Additional comments from [EMAIL PROTECTED] Sat Jul 26 09:53:47 + 2008 --- Please note that the attached example requires that a DSN named northwind already exists on the test system and it must point to the standard mdb example Northwind available from Microsoft web site here: http://www.microsoft.com/downloadS/details.aspx?familyid=C6661372-8DBE-422B-8676-C632D66C529Cdisplaylang=en I'm opening only the issue for escape processing inconsistent behaviour since I can't tell whether the query named doesntwork could lead to application freeze also on other systems. Feel free to add a separate bug report if the latter problem can be reproduced. - 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]