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

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 :)