Issue 105801 - Add support to upate result set when based on a view, when the underlying database manager supports updateable views
Summary: Add support to upate result set when based on a view, when the underlying dat...
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-11 09:27 UTC by villeroy
Modified: 2013-02-07 21:57 UTC (History)
2 users (show)

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

Attachments
DB with ViewDeleteDupes (7.27 KB, application/vnd.sun.xml.base)
2009-10-11 09:29 UTC, villeroy 		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 villeroy 2009-10-11 09:27:58 UTC 
Don't know how to classify this. It behaves as desired but not specified, in the
wrong place though.

In the attached HSQLDB table "Data" has duplicates of Name AND Value.
"ViewDupes" gives an overview over duplicate entries.
"ViewDeleteDupes" shows all but the latest duplicates which can be deleted with:
DELETE FROM "Data" WHERE "ID" IN (SELECT "ID" FROM "ViewDeleteDupes");

The specified behaviour seems to be that all views are always read-only, even if
they rely on a single table including the PK. At least this is what I got used
to and "ViewDeleteDupes" gives a read-only record set.

OK, open "ViewDeleteDupes" for editing and run the query for preview
(menu:Edit>Run Query). The preview pane gives an editable row set where I can
delete my duplicates in a GUI.

I wish I could have editable row sets for regular use.
Comment 1 villeroy 2009-10-11 09:29:27 UTC 
Created attachment 65293 [details]
DB with ViewDeleteDupes
Comment 2 drewjensen.inbox 2009-10-12 00:35:52 UTC 
 see also:

[Informix] Views are not updateable
http://www.openoffice.org/issues/show_bug.cgi?id=86045

Updateable MySQL views cannot be updated via OOBase
http://www.openoffice.org/issues/show_bug.cgi?id=90393

writing to a writeable PostgreSQL view does not work
http://www.openoffice.org/issues/show_bug.cgi?id=96716

@Villeory - Currently HSQLdb 1.8 does not support updateable views. Version 1.9
lists support for this in the release notes, although I have not tested that
support in the current RC6 package. Nor would I have any knowledge of if/when
OO.o will move to 1.9.

As for supporting updateable views in the current package it has never, to my
knowledge, been support. (IIRC the MySQL native connector isn't supporting this
either)

That said I do believe that one can still update a view using a prepared
statement from witin a script currently and only the GUI lacks the option.

Now - I suppose all these issues should be pointing to some common record in the
tracking system