MySQL Bugs: #30401: Relax restrictions on updateable ResultSets

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:	Assigned Account	CPU Architecture:	Any

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.

Hi Clemens and thanks for your report. I will ask our c/J team for consult.

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.

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.