DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Key: NUCRDBMS-631
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Support bulk delete when WHERE clause is across multiple tables

Created: 10/Jan/13 12:14 PM   Updated: 19/Jan/13 09:19 AM   Resolved: 15/Jan/13 04:51 PM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 3.2.0.m3


 Description  « Hide
See TODOs in JPQLQuery. Not all RDBMS support joining in a DELETE statement. Some syntax like

DELETE FROM films
  WHERE producer_id IN (SELECT id FROM producers WHERE name = 'foo');

is seemingly standard, but need to allow for more than 1 PK field

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 15/Jan/13 04:51 PM
SVN trunk should now support the vast majority of BULK DELETE operations, where there are multiple tables involved