To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=67008 Issue #|67008 Summary|creating a query based on another query with non-uniqu |e column names fails Component|Database access Version|current Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|fs Reported by|fs
------- Additional comments from [EMAIL PROTECTED] Tue Jul 4 06:06:19 -0700 2006 ------- This bug exists in the implementation of "Queries in Queries", filed as issue 51143. It can be reproduced in the master builds as soon as CWS qiq (http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fqiq) is integrated. - open the attached database document - with the query wizard, create a query based on the query "non-unique column names", adding all fields - open the resulting query => error message saying that the data content could not be loaded. The problem here is that the existing query selects column "Name" twice. When executed directly, OOo makes the names unique, by naming on of them "Name1" instead. The query wizard uses this "Name1" column name. Now when the query is used as sub query, the names are kept non-unique, so the reference to "Name1" in the wizard-generated query is bogus. --------------------------------------------------------------------- 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]
