Issue 67530 - queries in queries: calculated fields don't work
Summary: queries in queries: calculated fields don't work
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0.4
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-07-19 08:20 UTC by fornarif
Modified: 2006-08-25 14:48 UTC (History)
1 user (show)

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

Attachments
queries in queries: calculated fields don't work (1.02 MB, application/vnd.sun.xml.base)
2006-07-19 08:23 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-19 08:20:42 UTC 
Let's say that I build a query in query and inside the II Level query I put a
calculated field. All will work fine until the query will be closed and
re-opened or the Query Design View will be switched off and again on. After both
actions the II Level query won't work anymore, because Base modifies the
calculated field, inserting in the "Table" line the name of a "normal" table.
This behaviour can easily reproduced by the attached little sample database.

Best regards,
Franco
Comment 1 fornarif 2006-07-19 08:23:31 UTC 
Created attachment 37881 [details]
queries in queries: calculated fields don't work
Comment 2 marc.neumann 2006-07-19 08:45:58 UTC 
Hi,

I can reproduce this. Unfortunately the current version (m176) crash when I open
the second query in the bug database.

Set target and send to the right developer.

Bye Marc
Comment 3 marc.neumann 2006-07-19 08:49:25 UTC 
The bugid for the crash is 67532
Comment 4 Frank Schönheit 2006-07-19 14:37:47 UTC 
fixed in CWS dba204c

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%2Fdba204c
Comment 5 fornarif 2006-07-19 19:04:02 UTC 
Wow! What a quickness!
Many thanks,

Franco
Comment 6 Frank Schönheit 2006-08-02 11:17:09 UTC 
fs-> msc: please verify in CWS dba204c
Comment 7 marc.neumann 2006-08-04 11:33:17 UTC 
verified in CWS dba204b

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%2Fdba204b
Comment 8 marc.neumann 2006-08-24 09:33:22 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
Comment 9 fornarif 2006-08-24 15:08:07 UTC 
Hello,

if, as current master, you mean m180, I'm sorry but it doesn't work for me. The
problem happens exactly as described the first time. If you need further
informations, please, ask.

Best regards,
Franco
Comment 10 marc.neumann 2006-08-25 13:52:19 UTC 
Hi Franco,

Sorry, this issue is integrated in m181 as you can see in the EIS tool.

http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba204c

The m181 will be avalible soon.

Sorry for the confusing.

Bye Marc
Comment 11 fornarif 2006-08-25 14:48:55 UTC 
Hi Marc,

no problem, what counts is the solution.

Thanks for the clarification,

Franco