To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62164 Issue #:|62164 Summary:|Cannot create relationship for MySQL 5.x with UI Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|atjensen
------- Additional comments from [EMAIL PROTECTED] Thu Feb 16 08:26:21 -0800 2006 ------- Having connected to a MySQL 5.0.18 server using the JDBC connector 3.1.12 and the overrideSupportsIntegrityEnhancementFacility option I can open the Base relationship window. If I try to create a relationship between two tables by dragging a column in one table to a column in a second table the following error is produced: SQL Status: 42000 Error code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT `employeetasks_ibfk_1`' at line 1 If I create the exact same relationship by selecting 'Insert>New Relation...' and entering the column names int he dialog box there is no error and the constraint is created. This was tested under 2.0.1 and dev. build 156 with no difference in behavior. --------------------------------------------------------------------- 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]
