Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | [cws dba24a] mysql odbc releations design: error when close dialog with OK | ||
---|---|---|---|
Product: | Base | Reporter: | marc.neumann |
Component: | code | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | recent-trunk | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | Linux, all | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
marc.neumann
2007-09-25 09:24:16 UTC
Driver problem. The driver doesn't return the name of the foreign key. So we can not drop it. *** Issue 81927 has been marked as a duplicate of this issue. *** SQLForeignKeys returns for a foreign key the name 'NULL'. Afterwards when trying to delete the foreign key the name 'NULL' is not accepted in ALTER TABLE 'x' DROP FOREIGN KEY 'NULL' So I assume that the name of the foreign key is wrong. Tested with a 3.51.23.00 (version 5.1 hangs under Windows) Seems this is reported in MySQL's bug database as http://bugs.mysql.com/bug.php?id=25772. Which is marked as duplicate of issue http://bugs.mysql.com/bug.php?id=19923, which IMO describes another problem. Besides this, there is a comment in #m25772# which claims the behaviour is correct, pointing to http://msdn2.microsoft.com/en-gb/library/ms709315.aspx, where the respective text portion reads "Foreign key name. NULL if not applicable to the data source.". However, neither in the ODBC documentation nor in the MySQL-issue is an explanation what "not applicable to the data source" means. |