Bug 56750 - EDITING: Query wizard ignores relationships defined in database
Summary: EDITING: Query wizard ignores relationships defined in database
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 3.3.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 67664
  Show dependency treegraph
 
Reported: 2012-11-04 18:25 UTC by robert
Modified: 2015-01-03 17:38 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Example Databes with two queries - created by design view and by the wizard (4.28 KB, application/vnd.oasis.opendocument.base)
2012-11-04 18:25 UTC, robert
Details

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.