Return-Path: X-Original-To: apmail-db-torque-dev-archive@www.apache.org Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3041A633D for ; Mon, 20 Jun 2011 03:29:18 +0000 (UTC) Received: (qmail 76328 invoked by uid 500); 20 Jun 2011 03:29:18 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 76274 invoked by uid 500); 20 Jun 2011 03:29:17 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 76030 invoked by uid 99); 20 Jun 2011 03:29:10 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Jun 2011 03:29:10 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Jun 2011 03:29:08 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 70D70423D9E for ; Mon, 20 Jun 2011 03:28:47 +0000 (UTC) Date: Mon, 20 Jun 2011 03:28:47 +0000 (UTC) From: "Thomas Fox (JIRA)" To: torque-dev@db.apache.org Message-ID: <1350068526.19665.1308540527459.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (TORQUE-112) Delete via Join deletes all records in the table MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/TORQUE-112?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13051780#comment-13051780 ] Thomas Fox commented on TORQUE-112: ----------------------------------- When TORQUE-9 is implemented, delete using joins will not work any more because most databases will not execute DELETE FROM ${table} with joins. > Delete via Join deletes all records in the table > ------------------------------------------------ > > Key: TORQUE-112 > URL: https://issues.apache.org/jira/browse/TORQUE-112 > Project: Torque > Issue Type: Bug > Components: Runtime > Affects Versions: 3.3 > Environment: mysql, at least, though I suspect this bug is not database-specific. > Reporter: Carl Manaster > Attachments: JoinedDeleteTest.java > > Original Estimate: 72h > Remaining Estimate: 72h > > When I delete using a criteria that contains a join, instead of only the records of interest being deleted, all records are deleted. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org