https://bugs.documentfoundation.org/show_bug.cgi?id=67664
--- Comment #8 from Jakub KoĊcielak <[email protected]> --- https://gerrit.libreoffice.org/c/core/+/196141 Problem 2 submitted to the workshop: Two tables, unique column names - click "Finish" on the first page - set the column names as aliases. Two tables, unique column names - go through the wizard to the end, then in step 7, assign aliases; they must be unique - set the column names as aliases. Two tables, non-unique column names - click "Finish" on the first page - set the column names as Table.Column. Two tables, non-unique column names - go through the wizard to the end, then in step 7, assign aliases; they must be unique - set the column names as aliases. In step 7, we can delete some aliases. This means that we don't want aliases and want the column names as Table.Column. Now, you can't assign non-unique aliases, and leaving the alias blank doesn't generate errors. Until now, the wizard would end and the Table Data View would be empty, with an error message appearing because the SQL script had the alias AS "". I also removed the automatic aliasing of tables when alias = table name. Each query ended with: FROM "Table1" "Table1" In step 8, we can select "Modify Query" and the "Query Design View" will open. Error message added to the resources to facilitate translation: RID_QUERY_97=Duplicate column titles are not allowed: %DUPLICATES I tested on tables 1, 2, and 3, in various configurations. Anyone interested, please test it. -- You are receiving this mail because: You are the assignee for the bug.
