You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Thomas Fox (JIRA)" <ji...@apache.org> on 2011/06/20 05:28:47 UTC

[jira] [Commented] (TORQUE-112) Delete via Join deletes all records in the table

    [ 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