Bug 56750

Summary: EDITING: Query wizard ignores relationships defined in database
Product: LibreOffice Reporter: robert
Component: DatabaseAssignee: 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

Description robert 2012-11-04 18:25:23 UTC
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.
Comment 1 robert 2012-11-04 18:27:37 UTC
This problem has been confirmed by other users in the German openoffice-forum. So I set the Status to new.
Comment 2 Alex Thurgood 2015-01-03 17:38:32 UTC
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.