To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93474
User fs changed the following:
What |Old value |New value
================================================================================
Assigned to|msc |oj
--------------------------------------------------------------------------------
Status|REOPENED |NEW
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Dec 3 11:12:27 +0000
2008 -------
fs->oj: There's still a number of problems with creating the new relations. To
reproduce:
- import the attached script into a MySQL database of your choice. It will
create 3
tables: priorities, projects, release
- open the relation designer
=> the existing relation between priorities and projects is show - which is good
- add the "release" table to the relation design
=> the table is shown as "release", which is already wrong (also mentioned
above):
It should be "<cataolog>.release"
- create a relation between projects.Release and release.ProductID, by dragging
the
first field to the second
=> the relation is now shown (this is the part which is fixed here), but on the
projects
table, the relation is connected to the "ProjectID" field, which is wrong
- save, close, and re-open the relation-design
=> the relation between projects and release is now shown correctly, but the
relation
between projects and priorities is *not* shown anymore, which is heavily
wrong.
Doing a SHOW CREATE TABLE `projects` shows you that in fact the
FOREIGN key is still present in the database, but it is not shown in the
relation
designer anymore.
---------------------------------------------------------------------
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]
