Issue 67692 - Undeletable relationships in queries in queries
Summary: Undeletable relationships in queries in queries
Status: CLOSED DUPLICATE of issue 67004
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-07-23 10:25 UTC by fornarif
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

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

Attachments
QIQ relationships not deletable (58.31 KB, application/msword)
2006-07-23 10:29 UTC, fornarif 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description fornarif 2006-07-23 10:25:29 UTC 
I have a QIQ based on tree table and a QIQ, all joined by some relationships. If
I try to eliminate the QIQ from the Design View, it in fact desappeare, but with
it desappeare all the relationships that join the tables and, if I try to save
the change, Base crashes. Please, see the attached sample.

Best regards,
Franco
Comment 1 fornarif 2006-07-23 10:29:20 UTC 
Created attachment 37969 [details]
QIQ relationships not deletable
Comment 2 Frank Schönheit 2006-07-24 08:41:45 UTC 
The relationships must disappear - where should they point to when you remove
the table/query which is one of their "end nodes"?

The crash after the deletion is a duplicate of issue 67004, which is fixed in
CWS dba204b, due for m179 or m180.

*** This issue has been marked as a duplicate of 67004 ***
Comment 3 Frank Schönheit 2006-07-24 08:42:13 UTC 
closing duplicate
Comment 4 fornarif 2006-07-24 09:33:25 UTC 
Hi,

perhaps I didn't make me clear enough. I agree that, deleting a query, the
related connections "must" desappear, but in my sample "all" connections
desappear, also those ones that connect tables. Please, open the sample query
"Undeletable relationships" in Design View and try to delete the query "QIQ1"
from there. You will see that "all" relationships will desappear from the pane.
About the crash, I don't know if it's related or not with this.

Best regards,
Franco
Comment 5 Frank Schönheit 2006-07-24 09:44:33 UTC 
it is :)

There was a bug that when deleting a table/query window from the query designer,
then internally, the data structures for (up to) *all* table/query windows were
deleted. As a consequence, the joins for all those (wrongly deleted) table/query
windows were deleted, too.

This bug is issue 67004, which describes a diagnostics output happenig only in
non-product builds (http://wiki.services.openoffice.org/wiki/Non_Product_Build).
If this is fixed, then neither the diagnostics output, nor your issue here
happen (I verified this issue here in CWS dba204b, where issue 67004 is fixed).
Comment 6 fornarif 2006-07-24 10:30:43 UTC 
Hi,

thanks for the clarification. All is clear now.

Best regards,
Franco