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

[John T. Dow (JIRA)]

Subquery causes error: 'updateString' not allowed because the ResultSet is not 
an updatable ResultSet
-----------------------------------------------------------------------------------------------------

                 Key: DERBY-4045
                 URL: https://issues.apache.org/jira/browse/DERBY-4045
             Project: Derby
          Issue Type: Bug
            Reporter: John T. Dow


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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.