To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110943 Issue #|110943 Summary|mysql relations with native driver not possible Component|Database access Version|DEV300m76 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|MySQL Connector/OOo Assigned to|oj Reported by|msc
------- Additional comments from [email protected] Fri Apr 16 11:53:59 +0000 2010 ------- 1. create a new mysql driver and use the mysql native driver (I use version 1.0.1) 2. create 2 tables CREATE TABLE `rel1` ( `idx` decimal(10,0) NOT NULL DEFAULT '0', `f_text` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`idx`) ) CREATE TABLE `rel2` ( `idx` decimal(10,0) NOT NULL DEFAULT '0', `f_text1` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `idx_2` decimal(10,0) NOT NULL DEFAULT '0', PRIMARY KEY (`idx`) ) 3. open the relation design window 4. add the 2 tables 5. open INSERT / NEW RELATION 6. select field idx from table rel1 and field idx_2 from table rel2 7. click OK 8. double click the created relation ==>> as you can see the relation fields are missed up or is empty --------------------------------------------------------------------- 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]
