Apache OpenOffice (AOO) Bugzilla – Issue 67008
creating a query based on another query with non-unique column names fails
Last modified: 2017-05-20 10:48:18 UTC
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.
accepting
Created attachment 37495 [details] document to reproduce the bug case
hard to fix, and IMO not important enough for 2.x - the valid and easy workaround is to give an alias name to the second column when designing the query.
Reset assigne to the default "issues@openoffice.apache.org".