Issue 112126 - Query wizard doesn't keep table relations
Summary: Query wizard doesn't keep table relations
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO310m10
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2010-06-04 18:54 UTC by brissels
Modified: 2013-02-02 02:56 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Query design view (47.85 KB, text/plain)
2010-06-04 18:55 UTC, brissels
no flags Details
Example base with two queries (12.72 KB, text/plain)
2010-06-07 01:00 UTC, brissels
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description brissels 2010-06-04 18:54:01 UTC
I tried to make a query using the wizard.
That query involves two linked tables, it doesn't work.
In design view I found that relation is not displayed.
In design view if I add a new table, relation are displayed correctly.
So wizard may be the problem.
I found it in 3.0 and 3.1 ubuntu builts.
Comment 1 brissels 2010-06-04 18:55:19 UTC
Created attachment 69804 [details]
Query design view
Comment 2 r4zoli 2010-06-05 12:41:17 UTC
@Brissels 
> That query involves two linked tables, it doesn't work.
What you means under: "it doesn't work", please describe in more details.  

Can you upload an example file, without sensitive data?

I checked in DEV300m80(win7 and ubuntu 10.04) and found, if I add two tables,
connected in 1-n relations(checked only this), relations not shown in query
created with wizard.  
If I add new table in design view, and the new table have relation to one of the
existing in query table, the relation is show to newly added table. 
But relations between two existing tables not changes. 
The query runs and show all data.

Comment 3 brissels 2010-06-07 01:00:00 UTC
Created attachment 69842 [details]
Example base with two queries
Comment 4 brissels 2010-06-07 01:04:37 UTC
@r4zoli
> What you means under: "it doesn't work", please describe in more details.  
 
A mean that query neither shows relation nor gives a proper SQL statement.
I attached an example base. You'll find 2 queries, one made with wizard, the
other in design query view.
As you can see with wizard you get a SQL statement that doesn't take into
account relation between tables, so you get a kind of Cartesian product of two
tables and not a more logical query.
Comment 5 drewjensen.inbox 2010-06-07 01:10:41 UTC
I don't believe this has ever been supported in the Query wizard - ?

Seems like a valid enhancement request.
Comment 6 r4zoli 2010-06-07 09:39:41 UTC
If you read the Base Query wizard help text it is says about one table as source
of query.

In the main time you can select more than one table as source in wizards first
step. 
Some words in help can be useful, about consequence of selecting more than one
table. But best place for it in Base Guide.

It can be an enhancement to modify query wizard to recognize existing relations.   
Comment 7 Rob Weir 2013-02-02 02:56:52 UTC
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from http://www.openoffice.org/download

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
future.