To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97096 Issue #|97096 Summary|Alias names in MySQL queries ignored in Base unless fu |nction applied in SQL Component|Database access Version|OOO300m9 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atpat
------- Additional comments from [EMAIL PROTECTED] Wed Dec 10 12:54:38 +0000 2008 ------- N.B. I have selected "none" for the subcomponent field of this issue because I do not know what the only other option "SRB", means. Link a MySQL database to OO Base using JDBC (Sun). Open a MySQL view (regarded as a table by Base): aliases are ignored unless a function is used in the SQL for that field. This prevents systematic naming of query outputs in the context of that query; e.g. may wish to have two "Name" fields from different tables and to disambiguate them using aliases. The aliases are always correctly shown in the "edit" view of the query in Base. They are only ignored when the query is executed and its output displayed. The behaviour is inherited when the db is used to do mail merge in OO Text. Tests performed: - queries dropped and recreated: no effect. - CONCAT function applied: alias no longer ignored by Base. --------------------------------------------------------------------- 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]
