To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97811 Issue #|97811 Summary|Base with MS Access does not accept literals in concat |enation with plus symbol Component|Database access Version|OOO300m9 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eremmel
------- Additional comments from [email protected] Tue Jan 6 18:30:49 +0000 2009 ------- Not native executed queries in Base against MS access database that contain a concatenations based on plus symbol, break when a string literal value is involved. The reported error is: SQL Status HY000, Error code:1000 "Syntax error in SQL expression", "syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE" The following example goes wrong: SELECT f1 + 'value' FROM table1; whereas this is OK: SELECT f1 + f2 FROM table1; A workaround is: SELECT X.f1 + X.v FROM ( SELECT f1, 'value' AS "v" FROM table1 ) X --------------------------------------------------------------------- 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]
