https://bugs.kde.org/show_bug.cgi?id=338658
--- Comment #54 from Stephan Diestelhorst <stephan.diestelho...@gmail.com> ---
For me mysql complained about "You can't specify target for update in FROM
clause". Wrapping things into another layer of SELECT did the trick:
DELETE FROM pimitemtable WHERE pimitemtable.id in (
SELECT id FROM (
SELECT id FROM pimitemtable
LEFT OUTER JOIN (
SELECT MIN(pimitemtable.id) as RowId, pimitemtable.remoteId,
pimitemtable.collectionId FROM pimitemtable GROUP by pimitemtable.remoteId,
pimitemtable.collectionId )
as KeepRows ON pimitemtable.id = KeepRows.RowId
WHERE KeepRows.RowId IS NULL)
AS foo)
--
You are receiving this mail because:
You are watching all bug changes.
