Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of kristian.waagan@oracle.com
 designates 148.87.113.117 as permitted sender)
Message-ID: <4FCCB9A2.3000208@oracle.com>
Date: Mon, 04 Jun 2012 15:35:30 +0200
From: Kristian Waagan <kristian.waagan@oracle.com>
User-Agent: Mozilla/5.0 (X11; SunOS i86pc;
 rv:10.0.3) Gecko/20120424 Thunderbird/10.0.3
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Re: "Conglomerate could not be created"?
References: <4FC8B339.8090502@gmail.com> <4FC9E882.8040609@gmail.com>
 <4FCCAF85.3040107@oracle.com>
In-Reply-To: <4FCCAF85.3040107@oracle.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit

On 04.06.12 14:52, Rick Hillegas wrote:
> On 6/2/12 3:18 AM, John English wrote:
>> On 01/06/2012 15:19, John English wrote:
>>> I'm having trouble with the following error: "Conglomerate could not be
>>> created". It happens when I do this:
>>>
>>> INSERT INTO resource_usage (resid,itemid,itemtype)
>>> (SELECT resid,?,? FROM resource_usage
>>> WHERE itemid=?
>>> AND itemtype=?
>>> AND NOT EXISTS (SELECT resid FROM resource_usage
>>> WHERE itemid=? AND itemtype=?));
>>>
>> I also get the same error from this, which looks fairly innocuous to me:
>> INSERT INTO resource_usage (resid,itemid,itemtype)
>> (SELECT resid,20,'final' FROM resource_usage WHERE itemid=? AND
>> itemtype=?);
>> Is it perhaps because I'm inserting into the same table I'm selecting
>> from?
> Hi John,
>
> Do you have a stack trace for this error?

My extremely simple attempt at reproducing this didn't succeed on trunk 
(10.10), and I could "duplicate" the matching rows (only changing the 
itemtype column).
Do you also have the schema and example of data that triggers the 
problem? Are there many matching rows for the select?


Thanks,
-- 
Kristian

>
> Thanks
> -Rick
>> --
>> John English If we were to define a religion to be a system of thought
>> which contains unprovable statements, so it contains an element of
>> faith, then G�del has taught us that not only is mathematics a
>> religion but it is the only religion able to prove itself to be one.
>> � John Barrow, /Pi in the Sky /
>>
>