[DERBY-4045] Subquery causes error: 'updateString' not allowed because the ResultSet is not an updatable ResultSet

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Component/s: SQL
• Assignee: Unassigned
• Reporter: John T. Dow
• Created: 02/Feb/09 15:34
• Updated: 21/Jan/11 17:52
• Resolved: 03/Jul/09 10:59

Description

Embedded Derby (don't know about client) demoted an updatable result set apparently due to a nested query.

select * from orders where (orders.recordno = (select max(orders.recordno) from orders))

Fix if possible.

If it can't be fixed, the documentation should be changed.

Issue Links

• relates to: DERBY-4049 SELECT statement topic in Reference Manual should reflect current WHERE clause behavior