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: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 67664
  Show dependency treegraph
 
Reported: 2012-11-04 18:25 UTC by Robert Großkopf
Modified: 2019-03-10 07:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


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 Großkopf
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 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 Großkopf 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 Comment hidden (no-value)
Comment 3 QA Administrators 2016-02-21 08:35:33 UTC Comment hidden (obsolete)
Comment 4 Robert Großkopf 2016-02-21 09:17:05 UTC
Bug still exists with LO 5.1.1.1, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 5 Robert Großkopf 2016-03-06 08:07:29 UTC
Bug appears also in the first available LO-version (LO 3.3.0.4, OpenSUSE 42.1 64bit rpm Linux). So I set this bug as "Inherited From OOo".

Seems the wizard is only usable for one table. Couldn't define the relationship while executing the wizard. Had to define the relationship afterwards.
Comment 6 QA Administrators 2017-03-06 15:18:12 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2017-03-07 16:16:48 UTC
Bug still exists with LO 5.3.1.1, OpenSUSE 42.1 Leap, 64bit rpm Linux.
Comment 8 QA Administrators 2018-03-08 03:44:31 UTC Comment hidden (obsolete)
Comment 9 Robert Großkopf 2018-03-09 07:05:09 UTC
Bug still exists with LO 6.0.2.1, OpenSUSE 42.3 Leap, 64bit rpm Linux.
Comment 10 QA Administrators 2019-03-10 03:19:40 UTC Comment hidden (obsolete)
Comment 11 Robert Großkopf 2019-03-10 07:34:15 UTC
Bug still exists in LO 6.2.1.2 on OpenSUSE 15, 64bit rpm Linux