Bug #30401 Relax restrictions on updateable ResultSets
Submitted: 14 Aug 2007 8:11 Modified: 4 Sep 2007 13:54
Reporter: Clemens Eisserer Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / J Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: Alexander Soklakov CPU Architecture:Any
Triage: D5 (Feature request)

[14 Aug 2007 8:11] Clemens Eisserer
Description:
Whenever the user would like to create an updateable, scroll-insensitive ResultSet using simple JIONS or functions or subselects Connector/J boils out saying support for this is not in spec.

However the spec only says that a driver that is not able to perform the operations is spec-compliant, not that a driver that is able to perform some of these operations breaks it.

What I am asking is mainly updateability for:
- The root-relation of a join (left table for left-join, right join for right table)
- Functions and/or subselects, if those are not edited but other parameters in a row.

Postgres allows both, so it would be really great if MySQL would have that functionality too.
Its really useful for Database-Fontend libraries that rely on JDBCRowset, and which often don't allow a lot of code between database and UI.

How to repeat:
simply create a left join on two tables and try to create an updateable resultset of that

Suggested fix:
relax restrictions - use best effort instead of simply boiling out.
[24 Aug 2007 20:30] Tonci Grgin
Hi Clemens and thanks for your report. I will ask our c/J team for consult.
[27 Aug 2007 8:50] Tonci Grgin
Clemens, we are still consulting over this although I've been informed there is a work in progress: http://lists.mysql.com/commits/32781. I will set this to verified now and add info as I gather it.
[4 Sep 2007 13:54] Clemens Eisserer
Thanks a lot for looking at this Feature Request, great to hear that there are already some plans to implement some of the suggested functionality.