Apache OpenOffice (AOO) Bugzilla – Issue 69227
wrong claim of cyclic sub queries in bug doc
Last modified: 2007-09-20 08:20:12 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.
Created attachment 38923 [details] document to reproduce the bug case
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
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 ...
Created attachment 39668 [details] (better) document to reproduce the bug case
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.
targeting to 2.1, since the fix is part of a CWS aiming for this release
fs-> msc: please verify in CWS dba205c
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
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