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