Return-Path: Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org Received: (qmail 29557 invoked from network); 14 Mar 2007 02:42:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Mar 2007 02:42:46 -0000 Received: (qmail 92652 invoked by uid 500); 14 Mar 2007 02:42:55 -0000 Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org Received: (qmail 92617 invoked by uid 500); 14 Mar 2007 02:42:55 -0000 Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: open-jpa-dev@incubator.apache.org Delivered-To: mailing list open-jpa-dev@incubator.apache.org Received: (qmail 92593 invoked by uid 99); 14 Mar 2007 02:42:54 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Mar 2007 19:42:54 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of snoopdave@gmail.com designates 64.233.182.185 as permitted sender) Received: from [64.233.182.185] (HELO nf-out-0910.google.com) (64.233.182.185) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Mar 2007 19:42:43 -0700 Received: by nf-out-0910.google.com with SMTP id d4so23679nfe for ; Tue, 13 Mar 2007 19:42:22 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QpHTZzY+FOJNTvLCr3Vz4pOXihbkEahyZ33ySiCdqEjehV77jE3iwGhyJZDt7XDaGUL6W9B5pLo4wTidPHCZKy11/6gKF0USAFOFJfAFVTU5pVKgZri8f80oXl4XbG7EHsiK2UmT0DzC96lReiLgITTsAif1IL4Om/8IdpnVBRE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dMffDBXpvXkjW1gD/rhBDNiSL5cYm3zxyaKwKFoeFgVARCKbAd6y9APagazMzGmskFSxI6G61HMu6mODwRITVhIR8O1rdS8NdWinVPUUqHjkONNy2TbBmF9hUcS1kjDGiDXahI9UalRaH0gw6MLt5LXEtv1xxd7Y9jfQy8VA/KA= Received: by 10.78.189.5 with SMTP id m5mr789864huf.1173840142714; Tue, 13 Mar 2007 19:42:22 -0700 (PDT) Received: by 10.82.118.20 with HTTP; Tue, 13 Mar 2007 19:42:22 -0700 (PDT) Message-ID: <8fb9ac720703131942m661a78c5q84923124e9066c2a@mail.gmail.com> Date: Tue, 13 Mar 2007 22:42:22 -0400 From: Dave To: open-jpa-dev@incubator.apache.org Subject: Re: How to turn off sub-selects in updates? In-Reply-To: <8fb9ac720703120958s1929ecdaqdcce09c638e876ce@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8fb9ac720703120918g5a381b7w225c3ac428809233@mail.gmail.com> <7D856CDFE035FF45A0420ACBD71BDD630375CA22@repbex02.amer.bea.com> <8fb9ac720703120958s1929ecdaqdcce09c638e876ce@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org On 3/12/07, Dave wrote: > On 3/12/07, Patrick Linskey wrote: > > What is the JPQL query that you're issuing that is resulting in that SQL > > statement? One easy way to get this information is by setting the > > 'Query' log channel to TRACE. > > This is the query that caused the above trace. > > DELETE FROM WeblogEntryTagAggregateData w WHERE w.weblog = ?1 Ping! Any idea what might be going wrong with sub-select support in MySQL? I hope I'm not the first person to try this ;-) - Dave