db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <knut.hat...@oracle.com>
Subject Re: UPDATE FROM JOIN
Date Wed, 21 Dec 2011 14:45:11 GMT
Rick Hillegas <rick.hillegas@oracle.com> 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

Mime
View raw message