To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96657 Issue #|96657 Summary|issue a warning in relationship manager when relations |hip cannot be stored Component|Database access Version|OOO300m9 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|leggewie
------- Additional comments from [EMAIL PROTECTED] Thu Nov 27 12:12:25 +0000 2008 ------- This is something I discovered after trying to verify issue 93474 as being fixed. The relationship manager (Tools - Relationships) allows adding constraints between tables. Storing the relationship information seems to be left to the backend. MySQL supports foreign keys in InnoDB tables only. Creating a relationship between other MySQL tables seems to succeed at first (the relationship is shown), but it is not stored and thus lost after closing the relationship manager. The relationship manager should test the relation has indeed been added and issue a warning if that test failed. Steps to reproduce * load https://bugzilla.novell.com/attachment.cgi?id=251407 into a MySQL db * access that db from OOo * Open the relationship manager * add a relationship between the guid field which is present in both tables * close the relationship manager and reopen it result: the tables are still there, the relationship is gone --------------------------------------------------------------------- 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]