To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114189 Issue #|114189 Summary|Base crashes when using query filters / sorts on colum |ns created by correlated subqueries Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab
------- Additional comments from [email protected] Sun Aug 29 23:31:38 +0000 2010 ------- When using Base with an SQL query in which one of the column definitions uses a correlated subquery, trying to filter the query results in the display causes OpenOffice to crash. Furthermore, if the query was created using the "run SQL command directly" option, then tryint to sort the results will either cause OpenOffice to crash or to go into an indefinite loop (and may eventually crash, although I gave up waiting and used a force quit). However, if the query was run through the OpenOffice SQL parser, sorting does not appear to cause any crashes (although see issue 114187 and issue 114188 for other problems with sorting queries that I discovered while trying to isolate what was causing the crash). Filtering still causes a crash. However, this crash is more contained -- I get OpenOffice's "sorry but the program crashed your file will be recovered" message, instead of Mac's "OpenOffice crashed do you want to relaunch" message. The test database and an explanation of it are attached to issue 114187. --------------------------------------------------------------------- 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]
