To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81652 Issue #|81652 Summary|view alteration in HSQL is prone to racing conditions Component|Database access Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|fs Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Mon Sep 17 12:32:34 +0000 2007 ------- With issue 49183, we implemented the possibility to alter, using Base's query designer, the statement which constitutes a view. Which is fine so far ... Unfortunately, HSQL does not really support altering a view as atomic operation. Thus, the implementation needs to a) drop the view b) re-create it with a new statement c) re-create it with the original statement if the second step failed. This approach is prone to racing conditions. For instance, imagine a second instance removes the table which the view is based on, just after step a), but before step c). In this case, to the user the attempt to alter the view will result in the loss of the view. We should implement the support for ALTER VIEW <name> TO <statement> in HSQLDB. --------------------------------------------------------------------- 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]