To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101947 Issue #|101947 Summary|opening the query-edit dialog adds brackets to from st |atement Component|Database access Version|OOo 3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|pirlo
------- Additional comments from [email protected] Fri May 15 09:14:30 +0000 2009 ------- when i build a select on an mysql table it works as long as i open the query-editor or save and reopen the query. this is the select which dose not work (after reopening): SELECT `MDE121`.`auftrag`, `MDE121`.`POSITION`, `MDE121`.`status`, `MDE121`.`ruestcode`, `MDE121`.`stoercode`, `MDE121`.`startzeit`, `MDE121`.`endzeit`, `MDE_ruest`.`code`, `MDE_ruest`.`ruesten`, `MDE121`.`lid`, `MDE_stoer`.`stoergrund` FROM { OJ ( `p2`.`MDE121` AS `MDE121` LEFT OUTER JOIN `p2`.`MDE_ruest` AS `MDE_ruest` ON `MDE121`.`ruestcode` = `MDE_ruest`.`code` ) LEFT OUTER JOIN `p2`.`MDE_stoer` AS `MDE_stoer` ON `MDE121`.`stoercode` = `MDE_stoer`.`code` } i use the mysql-odbc driver version 3.51 if i change the select like this one it works again - as long until i reopen the select: SELECT MDE121.auftrag, MDE121.position, MDE121.status, MDE121.ruestcode, MDE121.stoercode, MDE121.startzeit, MDE121.endzeit, MDE_ruest.code, MDE_ruest.ruesten, MDE121.lid, MDE_stoer.stoergrund FROM p2.MDE121 AS MDE121 LEFT OUTER JOIN p2.MDE_ruest AS MDE_ruest ON MDE121.ruestcode = MDE_ruest.code LEFT OUTER JOIN p2.MDE_stoer AS MDE_stoer ON MDE121.stoercode = MDE_stoer.code if i change to the design-view and back again to query-editor the brackets get added and i get an error message. --------------------------------------------------------------------- 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]
