Issue 67010 - updatability of simple queries such as "SELECT * FROM <query>" where <query> is "SELECT * FROM <table>"
Summary: updatability of simple queries such as "SELECT * FROM <query>" where <query> ...
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-07-04 14:12 UTC by Frank Schönheit
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

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

Attachments
document to reproduce the bug case (4.00 KB, application/vnd.sun.xml.base)
2006-07-04 14:13 UTC, Frank Schönheit 		no flags Details
document to reproduce the bug case (11.02 KB, application/vnd.sun.xml.base)
2006-07-04 14:14 UTC, Frank Schönheit 		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 Frank Schönheit 2006-07-04 14:12:38 UTC 
This bug exists in the implementation of "Queries in Queries", filed as issue
51143. It can be reproduced in the master builds as soon as CWS qiq
(http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fqiq) is
integrated.

- open the attached database document
- open the query "outer"
=> it is readonly. Since it is simply defined as SELECT * FROM "inner", where
the query 'inner' is defined as SELECT * FROM "customers, it should be possible
to make the "outer" query updatable.
Comment 1 Frank Schönheit 2006-07-04 14:13:27 UTC 
Created attachment 37496 [details]
document to reproduce the bug case
Comment 2 Frank Schönheit 2006-07-04 14:14:56 UTC 
Created attachment 37497 [details]
document to reproduce the bug case
Comment 3 Frank Schönheit 2006-07-04 14:15:14 UTC 
the second bugdoc is the correct one ...
Comment 4 Frank Schönheit 2006-07-04 14:15:56 UTC 
fs->oj: this is more yours than mine :)