Rick Hillegas <[email protected]> writes: > On 12/21/11 3:59 AM, JulioSerje wrote: >> Hi Rick, >> >> Unfortunately our expressions would require a high number of subqueries; >> ours is an engineering application that require many values from several >> tables in order to compute multiple complex formulae. >> >> In our specific case we know that by design that our UPDATE ..FROM >> statements will compute the same as the statement based on subqueries (i.e. >> statements are not ambiguous at all). >> >> The question is, are you aware of any plans to implement MERGE in Derby? In >> the meanwhile we are considering the use of an intermediate table with >> results INSERTed, as insert can use a full fledged select clause, and later >> use a much simpler UPDATE statement with less and simpler subqueries. > Hi Julio, > > There is an existing enhancement request for the MERGE operator: > https://issues.apache.org/jira/browse/DERBY-3155 If you add your vote > on that issue, you will increase its chances of being implemented.
We also have https://issues.apache.org/jira/browse/DERBY-4074, which requests syntax that provides functionality similar to UPDATE ... FROM. -- Knut Anders
