Issue 69227

Summary:

wrong claim of cyclic sub queries in bug doc

Product:

Base

Reporter:

Frank Schönheit <frank.schoenheit>

Component:

code

Assignee:

marc.neumann

Status:

CLOSED FIXED

QA Contact:

issues@dba <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

680m181

Target Milestone:

OOo 2.1

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
document to reproduce the bug case	none
(better) document to reproduce the bug case	none

Description Frank Schönheit 2006-09-04 07:26:58 UTC

Open the attached document. It contains
- a table named "abc"
- a query named "level 1", based on "abc"
- a query named "level 2", based on "level 1" and "abc"
- a query named "level 3", based on "level 1" and "level 2"

Trying to open "level 3" gives you an error message saying that there are cyclic
sub queries. However, as you can see in the above structure, there aren't.

Comment 1 Frank Schönheit 2006-09-04 07:28:57 UTC

Created attachment 38923 [details]
document to reproduce the bug case

Comment 2 Frank Schönheit 2006-10-10 14:45:25 UTC

fixed in CWS dba205c

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba205c

Comment 3 Frank Schönheit 2006-10-10 14:47:53 UTC

note:
The query "level 3" will still not execute, since it contains ambiguous column
names when the sub queries are substituted. In thise sense, it's a bad bug doc ...

Comment 4 Frank Schönheit 2006-10-10 14:52:29 UTC

Created attachment 39668 [details]
(better) document to reproduce the bug case

Comment 5 Frank Schönheit 2006-10-10 14:53:59 UTC

the second attachement is a better bugdoc. It also exposes the original bug, but
does not suffer from the second one, so it's easier to verify the original bug
and its fix.

Comment 6 Frank Schönheit 2006-10-12 08:40:35 UTC

targeting to 2.1, since the fix is part of a CWS aiming for this release

Comment 7 Frank Schönheit 2006-10-12 09:47:44 UTC

fs-> msc: please verify in CWS dba205c

Comment 8 marc.neumann 2006-10-18 14:12:45 UTC

verified in CWS dba205c

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba205c

Comment 9 marc.neumann 2007-09-20 08:20:12 UTC

Hi,

this is fixed in the current master. The current master is available at
http://download.openoffice.org/680/index.html

I close this issue now.

Bye Marc