[#NUCRDBMS-631] Support bulk delete when WHERE clause is across multiple tables - DataNucleus JIRA

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:

Andy Jefferson made changes - 10/Jan/13 12:38 PM

Field	Original Value	New Value
Description	See TODOs in JPQLQuery. Not all RDBMS support joining in a DELETE statement	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

[ Permalink | « Hide ]

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

Andy Jefferson made changes - 15/Jan/13 04:51 PM

Status	Open [ 1 ]	Resolved [ 5 ]
Fix Version/s		3.2.0.m3 [ 11840 ]
Resolution		Fixed [ 1 ]

Andy Jefferson made changes - 19/Jan/13 09:19 AM

Status

Resolved [ 5 ]

Closed [ 6 ]