To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81691 Issue #|81691 Summary|ANSI quoting for table names not recognized for MySQL |dbs Component|Database access Version|OOo 2.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|oj Reported by|mux2005
------- Additional comments from [EMAIL PROTECTED] Tue Sep 18 10:23:14 +0000 2007 ------- A statement like this SELECT * FROM "table" produces an error when I pass it to my MySQL database via XStatement statement = conn.createStatement(); XResultSet results = statement.executeQuery(query); from a Java app. Note the double-quotes around the table name. These are ANSI SQL syntax for quoting identifiers which is by default not supported by MySQL (MySQL syntax uses backticks). If I set sql_mode="ANSI" on the db, the query works without error. So why am I reporting this as an OOo bug? Because 1. OOos driver layer should take care to either put MySQL into ANSI mode before issuing the query or the query should be rewritten to be MySQL-conforming. As I understand it, that's one purpose of OOos driver layer. 2. The same query works when I issue it from the OOo Base interface. So apparently OOo already has the ability to adapt the quoting. It's just not applied when I use the UNO API to issue the query. --------------------------------------------------------------------- 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]
