| Summary: | EDITING: Query wizard ignores relationships defined in database | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | robert |
| Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | iplaw67 |
| Version: | 3.3.4 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Bug Depends on: | |||
| Bug Blocks: | 67664 | ||
| Attachments: | Example Databes with two queries - created by design view and by the wizard | ||
This problem has been confirmed by other users in the German openoffice-forum. So I set the Status to new. Adding self to CC if not already on |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 69527 [details] Example Databes with two queries - created by design view and by the wizard Create a database. Create two tables, one table with a foreignkey for the other. Link this tables with Tools → Relationships ... Put some data in both tables. → all this is prepared for everybody in the attachment. Create a query, which should show the content of both tables. In the example this is a query, which should show "Names" and the "Classes" for this Names. First use "Create Query in Design View ...". The Design View reads the relationships of the table. You could see this in the design. Execute the Query and count the rows - 6 rows in the example, because there are 6 "Names" in the table "Name". Now "Use Wizard to Create Query ...". When you choose two tables, the wizard creates a query, which shows all combinations between the tables. Count the rows - 18 in the example, because there are 3 rows in the table "Class" and 6 rows in the table "Name". 3*6=18. Have a look at the query. Try to edit it in SQL-View. The query has no condition defined in the WHERE-clause. This wizard in unusable for all queries, which should show data of more than one field. It doesn't work in any LO-Version and doesn't work also in OOo 3.3 - could be it never had been worked well.